sql操作个别语句

set identity_insert db on

set identity_insert db off



begin transaction

commit transaction



dump transaction test with no_log

DBCC   SHRINKFILE(test_log,1)



backup database db to 'e:/db.bak'



use master

declare @mycur cursor

declare @spid int

set @mycur = cursor for 

select spid from master..sysprocesses   where   dbid=db_id('test')

open @mycur

fetch next from @mycur into @spid

while @@fetch_status=0

   begin

   exec('kill '+@spid)

   fetch next from @mycur into @spid

   end

close @mycur

deallocate @mycur 

restore database test 

from disk='E:/test.bak'

with replace

go



select @@identity