qq_39366406的博客

declare @trun_name varchar(8000)set @trun_name=’’select @trun_name=@trun_name + 'truncate table ’ + [name] + ’ ’ from sysobjects where xtype=‘U’exec (@trun_name)

sql server分页查询–pageSize 每页显示的数量 100–pageIndex 起始索引　1select top 100 *from (select row_number() over(order by FEmpID asc) as rownumber,*from tbl_baseinfo) temp_rowwhere rownumber>((1-1)*100);s...

DELETE tbl_baseinfoWHERE FempID IN (SELECT TOP 1000 FempID FROM tbl_baseinfo)

Update tbl_baseinfo SET FRegNo =(select replace(ltrim(replace(FRegNo,'0',' ')),' ','0'))

SELECT id,count(1) FROM tbl_table GROUP BY id HAVING count(1) > 1

public class StringHelper { /// <summary> /// 过滤字符 /// </summary> /// <param name="str"></param> /// <returns></returns> public static str...

dbcc sqlperf(logspace) --查看日志大小USE[master]GOALTER DATABASE [punchWebDB] SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE [punchWebDB] SET RECOVERY SIMPLE --简单模式 GOUSE [punchWebDB] GODBCC SH...

CREATE FUNCTION f_RemoveLetter(@str VARCHAR(500))RETURNS VARCHAR(500)ASBEGIN– ‘%[0-9]%’ 所有數字– ‘%[A-Za-z]%’ 所有字母– ‘%[A-Za-z0-9]%’ 所有數字與字母– ‘%[吖-咗]%’ 所有汉字...

select a.FRegNo,a.FDate,a.FTime,a.num from(selectFRegNo,FDate=CONVERT(varchar(100), FDate, 23),FTime=STUFF((select ‘,’+rtrim(CONVERT(varchar(100), FTime, 8))from #temp where st.FRegNo=FRegNo and F...

1.LEFT ( character_expression , integer_expression )函数说明：LEFT ( 字段名 , ‘要截取最左边的字符数’ )返回从字符串左边开始指定个数的字符select LEFT(‘SQL_Server_2008’,4 );返回结果：SQL_2.RIGHT ( character_expression , integer_expressio...

sql 行转列方法1：select name ,sum(case when course=’语文’ then score end) as 语文, sum(case when course=’数学’ then score end )as 数学, sum(case when course=’英语’ then score end )as 英语 from Table_1 group by nam...