如果你在写procedure时要根据特定变量的值动态创建table(表名是全部或部分特定变量的值)。例如:
declare @tablename char(10)
//if some statement
set @tablename=test
你想用变量@tablename的值作为表名创建一个新表,那么用create table @tablename (test char(8))语句在SQL server 2k中执行就会遇到问题,
解决(接上例):
//如果表不存在则创建
IF not EXISTS (SELECT name FROM sysobjects
WHERE name =@tablename AND type = U)
begin
set@createtable=create table + @tablename+ (myname char(2))
exec(@createtable)
end
declare @tablename char(10)
//if some statement
set @tablename=test
你想用变量@tablename的值作为表名创建一个新表,那么用create table @tablename (test char(8))语句在SQL server 2k中执行就会遇到问题,
解决(接上例):
//如果表不存在则创建
IF not EXISTS (SELECT name FROM sysobjects
WHERE name =@tablename AND type = U)
begin
set@createtable=create table + @tablename+ (myname char(2))
exec(@createtable)
end