where 前要有空格.呵呵。CREATE PROCEDURE LawLogin @tblName varchar(50), @col1 varchar(50) ASdeclare @sql varchar(200)set @sql='select '+ @col1+' from '+@tblName +' where '+@col1+'=''a'''exec(@sql)GO
这是存储过程。 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 行: '=' 附近有语法错误。还是出错呀
这是存储过程。 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
CREATE PROCEDURE LawLogin
@tblName varchar(50),
AS
declare @sql varchar(200)
@sql='delete from ' + @tblname
exec (@sql)
GO
@tblName varchar(50),
AS
exec ('delete from '+@tblName)
GO
愉快的登山者 ⊙
◢◣◢◣◢◣
@tblName varchar(50),
AS
begin
declare @var varchar(100)set @var = 'delete from ' + "'@tblname'"exec(@var)
end
@tblName varchar(50),
AS
exec ('delete from '+@tblName)
GO
愉快的登山者 ⊙
◢◣◢◣◢◣
@tblName varchar(50),
AS
exec ('delete from '+@tblName)
GO
CREATE PROCEDURE LawLogin
@tblName varchar(50),
@col1
AS
select @col1 from @tblName
GO
@tblName varchar(50),
AS
exec('delete from '+@tblName)
GO
@tblName varchar(50),
@col1 varchar(50)
AS
delcare @sql varchar(200)
@sql='select '+ @col1+' from '+@tblName +'where '+@col1+'=a'
exec(@sql)
GO
这里=号出错了,如何解决了。。a 是字符常量。
@sql='select '+ @col1+' from '+@tblName +' where '+ @col1+'=''a'' '
@tblName varchar(50),
@col1 varchar(50)
ASdeclare @sql varchar(200)set @sql='select '+ @col1+' from '+@tblName +'where '+@col1+'=''a'''exec(@sql)GO
@tblName varchar(50),
@col1 varchar(50)
ASdeclare @sql varchar(200)set @sql='select '+ @col1+' from '+@tblName +' where '+@col1+'=''a'''exec(@sql)GO
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 行: '=' 附近有语法错误。还是出错呀
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