我想通过存储过程实现，表名做为参数传进去，不知道如何解决！急！

[eagle_hb]

CREATE PROCEDURE LawLogin
@tblName varchar(50),
AS
delete from @tblName
GO
就像上面这样，可是delete from @tblName 有错误，不知道大家有没有好的方法

[愉快的登山者]

CREATE PROCEDURE LawLogin
@tblName varchar(50),
AS
exec ('delete from '+@tblName_
GO


愉快的登山者

⊙
◢◣◢◣◢◣

[LiaoCheng]

CREATE PROCEDURE LawLogin
@tblName varchar(50),
AS
declare @sql varchar(200)
@sql='delete from ' + @tblname
exec (@sql)
GO

[愉快的登山者]

CREATE PROCEDURE LawLogin
@tblName varchar(50),
AS
exec ('delete from '+@tblName)
GO


愉快的登山者

⊙
◢◣◢◣◢◣

[dddd8888]

CREATE PROCEDURE LawLogin
@tblName varchar(50),
AS
begin
declare @var varchar(100)

set @var = 'delete from ' + "'@tblname'"

exec(@var)
end

[愉快的登山者]

CREATE PROCEDURE LawLogin
@tblName varchar(50),
AS
exec ('delete from '+@tblName)
GO


愉快的登山者

⊙
◢◣◢◣◢◣

[haozhiyuan2003]

CREATE PROCEDURE LawLogin
@tblName varchar(50),
AS
exec ('delete from '+@tblName)
GO

[eagle_hb]

谢谢大家如果像以下这样呢？？？
CREATE PROCEDURE LawLogin
@tblName varchar(50),
@col1
AS
select @col1 from @tblName
GO

[hjb111]

CREATE PROCEDURE LawLogin
@tblName varchar(50),
AS
exec('delete from '+@tblName)
GO

[eagle_hb]

CREATE PROCEDURE LawLogin
@tblName varchar(50),
@col1 varchar(50)
AS
delcare @sql varchar(200)
@sql='select '+ @col1+' from '+@tblName +'where '+@col1+'=a'
exec(@sql)
GO
这里=号出错了，如何解决了。。a 是字符常量。

[eagle_hb]

UP,解决马上散分！！！

[liukaiii]

@sql='select '+ @col1+' from '+@tblName +'where '+@col1+'=''a'' '

[eagle_hb]

'=' 附近有语法错误。还是不行呀

[eagle_hb]

UP!!

[xhwly]

可能是where 前面沒有空格
@sql='select '+ @col1+' from '+@tblName +' where '+ @col1+'=''a'' '

[yangvxin1]

CREATE PROCEDURE LawLogin
@tblName varchar(50),
@col1 varchar(50)
AS

declare @sql varchar(200)

set @sql='select '+ @col1+' from '+@tblName +'where '+@col1+'=''a'''

exec(@sql)

GO

[yangvxin1]

where 前要有空格.呵呵。

CREATE PROCEDURE LawLogin
@tblName varchar(50),
@col1 varchar(50)
AS

declare @sql varchar(200)

set @sql='select '+ @col1+' from '+@tblName +' where '+@col1+'=''a'''

exec(@sql)

GO

[eagle_hb]

这是存储过程。
CREATE PROCEDURE test
@tblName varchar(50),
@col1 varchar(50)
AS
declare @sql varchar(200)

set @sql='select '+ @col1+' from '+@tblName +'where '+@col1+'=''a'''

exec(@sql)
GO
表结构如下：表名tbl,
col1
----
a
b
c
d

执行exec test 'tbl','col1'
我通过查找出来总是说:
服务器: 消息 170，级别 15，状态 1，行 2
第 2 行: '=' 附近有语法错误。

还是出错呀。。。。。。

[eagle_hb]

UP一下。

[wuqiuzhi]

这是存储过程。
CREATE PROCEDURE test
@tblName varchar(50),
@col1 varchar(50)
AS
declare @sql varchar(200)

set @sql='select '+ @col1+' from '+@tblName +'/*※此处加上一个空格试一下※*/ where '+@col1+'=''a'''

exec(@sql)
GO

[eagle_hb]

好了，真的很感谢大家，散分了。！