SQL

declare @tmpTbl table(d int primary key, c int, cr int) insert into @tmpTbl select MONTH(<datecol>),  ,count(userid),0 FROM <table_name> WHERE group […]

SUBSTRING(FileName,LEN(FileName) – FINDSTRING(REVERSE(FileName),”\\”,1) + 2,LEN(RIGHT(FileName,FINDSTRING(REVERSE(FileName),”\\”,1) – 1))) Recommend on Facebook share via Reddit Share with Stumblers Tweet about it

alter database <mydb> set recovery simple go checkpoint go alter database <mydb> set recovery full go backup database pubs to […]

SET NOCOUNT ON DBCC UPDATEUSAGE(0) — DB size. EXEC sp_spaceused — Table row counts and sizes. CREATE TABLE #t ( […]