Hi,
I have a problem creating Stored Procedure in MS SQL
I am using a variable which is not understood by the query. My code is as below.
CREATE PROCEDURE [Get_Test]
@iUserID varchar(10),
@sUsername varchar(50) output
AS
Declare @sSql nvarchar(2000), @User varchar(50)
Declare @sColumn varchar(20)
Declare @sTable varchar(50), @sReturnColumn varchar(20)
SET @sColumn = "mem_id"
SET @sTable = "members"
SET @sReturnColumn = "mem_username"
SELECT @User = @sReturnColumn FROM @sTable WHERE @sColumn = @iUserID
GO
I get an Error 137: Must declare variable @sTable. Can anybody help me out in this. Thanks to anyone who responds.
Bhavesh
I have a problem creating Stored Procedure in MS SQL
I am using a variable which is not understood by the query. My code is as below.
CREATE PROCEDURE [Get_Test]
@iUserID varchar(10),
@sUsername varchar(50) output
AS
Declare @sSql nvarchar(2000), @User varchar(50)
Declare @sColumn varchar(20)
Declare @sTable varchar(50), @sReturnColumn varchar(20)
SET @sColumn = "mem_id"
SET @sTable = "members"
SET @sReturnColumn = "mem_username"
SELECT @User = @sReturnColumn FROM @sTable WHERE @sColumn = @iUserID
GO
I get an Error 137: Must declare variable @sTable. Can anybody help me out in this. Thanks to anyone who responds.
Bhavesh