如何实现动态sql清空数据库表
数据库 basedata
table:tblwodefinition 中字段 :MasterTableName 下: a b c ....
------解决方案--------------------
declare @sql varchar(1000)
declare @tbl varchar(200)
declare hyc cursor
local
for select name from sysobjects where objectproperty(object_id(name), 'IsUserTable ')=1
open hyc
while @@fetch_status=0
begin
fetch next from hyc into @tbl
set @sql= 'drop table ' + @tbl
exec(@sql)
end
close hyc
deallocate hyc