HELP !!! 这个存储过程到底错在哪里？？？？？？
CREATE PROCEDURE ctmptable @cname char(20) AS
declare @tname char(20)
set @tname='tempt'+@cname
CREATE TABLE dbo.@tname (
[tfid] [int] IDENTITY (1, 1) NOT NULL ,
[lid] [int] NOT NULL ,
[lxm] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sfsp] [bit] NOT NULL
) ON [PRIMARY]
GO
问题点数：20、回复次数：9Top
1 楼jxl816（三两）回复于 2003-01-10 17:11:08 得分 5
CREATE PROCEDURE ctmptable @cname char(20) AS
declare @tname char(20)
set @tname='tempt'+@cname
CREATE TABLE dbo.tname (
[tfid] [int] IDENTITY (1, 1) NOT NULL ,
[lid] [int] NOT NULL ,
[lxm] [nchar] (20) NOT NULL ,
[sfsp] [bit] NOT NULL
) ON [PRIMARY]
GO
建立表时不可用变量，不过可用运态语名生成表Top
2 楼jxl816（三两）回复于 2003-01-10 17:11:23 得分 0
建立表时不可用变量，不过可用运态语句生成表Top
3 楼hjhing（winding）回复于 2003-01-10 17:12:19 得分 5
CREATE PROCEDURE ctmptable @cname char(20) AS
declare @tname char(20)
set @tname='tempt'+@cname
declare @str varchar(2000)
set @str='CREATE TABLE dbo.'+@tname+' (
[tfid] [int] IDENTITY (1, 1) NOT NULL ,
[lid] [int] NOT NULL ,
[lxm] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sfsp] [bit] NOT NULL
) ON [PRIMARY] '
---print @str
exec(@str)Top
4 楼happydreamer（www.sz.js.cn,www.gyxk.com）回复于 2003-01-10 17:17:40 得分 0
create table 不能直接用变量Top
5 楼tj_dns（愉快的登山者）回复于 2003-01-10 17:18:28 得分 5
CREATE PROCEDURE ctmptable @cname char(20) AS
declare @tname char(20)
set @tname='tempt'+@cname
declare @sql varchar(300)
set @sql = 'CREATE TABLE dbo.'+@tname+' ('+
'[tfid] [int] IDENTITY (1, 1) NOT NULL ,'+
'[lid] [int] NOT NULL ,'+
'[lxm] [nchar] (20) NOT NULL ,'+
'[sfsp] [bit] NOT NULL'+
') ON [PRIMARY]'
exec (@sql)Top
6 楼sgx（sgx）回复于 2003-01-10 17:24:17 得分 0
俺想将tfid设为主键应该怎么办??Top
7 楼KnowLittle（人傻不要紧，只要肯学习。）回复于 2003-01-10 18:43:47 得分 5
ALTER TABLE [dbo].[Table] WITH NOCHECK ADD
CONSTRAINT [PK_Table] PRIMARY KEY CLUSTERED
(
[tfId]
) ON [PRIMARY]
GO
Top
8 楼sgx（sgx）回复于 2003-01-11 12:38:22 得分 0
多谢各位
给分 ！！！
Top
