摘要：set nocount on USE master IF exists(SELECT 1 from tempdb.sys.objects where object_id=object_id('tempdb..#temp')) drop TABLE tempdb..#temp SELECT db_na 阅读全文

摘要：--打开xp_cmdshell EXEC sp_configure 'show advanced options', 1GORECONFIGUREGOEXEC sp_configure 'xp_cmdshell', 1GORECONFIGUREGO use ConfigDBgospb_netuse_ 阅读全文

摘要：create database newtestdb use newtestdbgo drop table t1go create table t1 (id int not null identity(1,1) primary key,vdate datetime default (getdate() 阅读全文

摘要：backup database testdb to disk='c:\testdb_ful.bak' with compression backup log testdb to disk='c:\testdb_ful.trn' with compression restore filelistonl 阅读全文