declare @tablename varchar(20)
set @tableName='yourtablename'
if exists (select * from sysobjects where name = 'yourtablename')
drop table @tableName
go
CREATE TABLE @tableName (CALLIDX BIGINT,AIIDX BIGINT)
如何执行?
...全文
1005打赏收藏
求动态SQL语句
--此动态SQL,怎么写? declare @tablename varchar(20) set @tableName='yourtablename' if exists (select * from sysobjects where name = 'yourtablename') drop table @tableName go CREATE TABLE @tableName (CALLIDX BIGINT,AIIDX BIGINT) 如何执行?
--try
declare @tablename varchar(20),@s varchar(8000)
set @tablename='yourtablename'
set @s=' if exists (select * from sysobjects where xtype=''u'' and status>=0 and name = '''+@tablename+''')'+char(13)
set @s=@s+' drop table '+@tablename+' '+char(13)
set @s=@s+' CREATE TABLE '+@tablename+'(CALLIDX BIGINT,AIIDX BIGINT)'
exec(@s)