删除指定表的数据
摘要:--删除所有指定表中的数据 declare @sqlcmd varchar(8000) set @sqlcmd = '' select @sqlcmd = @sqlcmd + 'delete from ' + name+ char(10) from sysobjects where type='U' and name like 'A%' p...
阅读全文
posted @ 2007-11-20 15:15
posted @ 2007-11-20 15:15