in my sql database table 'dbo.TABLE1' i have column name are 1,2,3,4,5 as per my requirement. if i set column names as numeric its automatically set as [1],[2],[3],[4],[5].
all columns are nvarchar(5)
below is my table structure
ROW_NAME|[1]|[2]|[3]|[4]|[5]| --->
Column names (Row name, [1],[2],[3],[4],[5])
A | 1 | 2 | 3 | 4 | 5 | ---> Values
B | 0 | 2 | 0 | 4 | 5 | ---> Values
C | 1 | 0 | 0 | 0 | 5 | ---> Values
please observe column name and values are same except Row_Name.
by passing parameter values from frontend (asp.net) and using stored procedure i am updating my 'dbo.TABLE1'.
below is my stored procedure
---------------------------
CREATE PROCEDURE [dbo].[SP_UPDATE]
-- Add the parameters for the stored procedure here
(
@Row nvarchar(1), -- Here i Pass parameter value 'B'
@Column nvarchar(1), -- Here i pass parameter value '3'
@Status char -- Here i pass parameter value 'R'
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
IF(@Status='R')
BEGIN
UPDATE dbo.TABLE1 SET [@Column]=@Column WHERE Row_Name=@Row
END
ELSE IF(@Status='S')
BEGIN
UPDATE dbo.TABLE1 SET [@Column]=@Column WHERE Row_Name=@Row
END
END
i want out put as,
ROW_NAME|[1]|[2]|[3]|[4]|[5]| --->
Column names (Row name, [1],[2],[3],[4],[5])
A | 1 | 2 | 3 | 4 | 5 | ---> Values
B | 0 | 2 | 3 | 4 | 5 | ---> Values
C | 1 | 0 | 0 | 0 | 5 | ---> Values
if i pass @Column value 1 , @Row value B Then,
ROW_NAME|[1]|[2]|[3]|[4]|[5]| --->
Column names (Row name, [1],[2],[3],[4],[5])
A | 1 | 2 | 3 | 4 | 5 | ---> Values
B | 1 | 2 | 0 | 4 | 5 | ---> Values
C | 1 | 0 | 0 | 0 | 5 | ---> Values
i am getting error at [@Column]..
How to solve it
