会python真的可以为所欲为0(回)
399天前
这里还有人吗1(回)
584天前这里还有人吗0(回)
584天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
809天前到处都是羊，不想上班0(回)
889天前
鸽子
0(回)
893天前declare @trun_name varchar(8000) |
declare name_cursor cursor for |
select 'delete from ' + name + ' DBCC CHECKIDENT ('+name+', RESEED,0)' from [sysobjects] where xtype='U' |
open name_cursor |
fetch next from name_cursor into @trun_name |
while @@FETCH_STATUS = 0 |
begin |
print @trun_name |
fetch next from name_cursor into @trun_name |
end |
close name_cursor |
deallocate name_cursor |
--exec sp_msforeachtable "truncate table ?" |
