CREATE PROCEDURE dbo.filenameSelectCommand
(
@a varchar(20),
@b varchar(20)
)
AS
SET NOCOUNT ON;
SELECT test.*
FROM test
WHERE (@a = @b)
GO
但是实际上where后面用@x=@y是不行的
请问怎么解决
(
@a varchar(20),
@b varchar(20)
)
AS
SET NOCOUNT ON;
SELECT test.*
FROM test
WHERE (@a = @b)
GO
但是实际上where后面用@x=@y是不行的
请问怎么解决
(
@a varchar(20),
@b varchar(20)
)
AS
declare @sql varchar(8000)
set @sql='
SELECT test.*
FROM test
WHERE ('+@a+' ='+ @b+')'
exec (@sql)
@a与@b是传进来的参数
你的sql语句中Where后面改下