Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
48 Points
41 Posts
Feb 24, 2012 08:48 AM|LINK
I am changing the stored procedure parameter as int and table column as int
So, in this case set @tsql1 = 'update TEST1 set [' + @SName1 + '] = '''+ @Sval +''' where RespId= ''' + @RespId + ''''
changes to
set @tsql1 = 'update TEST1 set [' + @SName1 + '] = '''+ @Sval +''' where RespId= ' + @RespId + ''
is this right?
abhinavsaxen...
Member
48 Points
41 Posts
Re: SQL Procedure
Feb 24, 2012 08:48 AM|LINK
I am changing the stored procedure parameter as int and table column as int
So, in this case set @tsql1 = 'update TEST1 set [' + @SName1 + '] = '''+ @Sval +''' where RespId= ''' + @RespId + ''''
changes to
set @tsql1 = 'update TEST1 set [' + @SName1 + '] = '''+ @Sval +''' where RespId= ' + @RespId + ''
is this right?