sqlserver常用查询语句

–查询语句Select * FROM BASE_USER;–查询前10条语句Select TOP 10 * FROM BASE_USER;–允许脏读查询Select * FROM BASE_USER WITH(NOLOCK);–获取当前数据库名称Select DB_NAME(dbid) as dbName FROM master.dbo.sysprocesses Where STATUS=’runnable’;–获取当前日期与时间Select GETDATE();–获取当前月Select DATEPART(month, getdate());–获取当前年Select DATEPART(year, getdate());–获取倒推一个月的日期Select CONVERT(varchar(10), CONVERT(varchar(8),dateadd(month,-1,getdate()),23)+Datename(day,GetDate()) , 120);–字符串截取与定位Select substring(SERVICEGROUP_,4,1)，CHARINDEX(‘Partner’,STAFFLEVEL) FROM BASE_USER;–字符替换Select REPLACE(A.NAME,’11’,’22’)  FROM TD_STUDENTS;–检查数据库连接数select count(*) from master.dbo.sysprocesses ;–查询数据库版本Select @@VERSION;–最近七天select  convert(varchar(10),getdate() – 7,120)；

转载于天翼云，如有侵权，请联系删除，谢谢