I would like to pass the name of a table in my update query. It goes something like :
set @.Table = 'TableA'
UPDATE
@.Table
SET
Company_id = @.Company_id
However I get a syntax error when I try to pass the table name like this.Try this
Declare
@.Table nvarchar(25)
, @.sql nvarchar(500)
, @.Company_id nvarchar(15)
Set @.Table = 'TableA'
Set @.Company_id = 'MyCompany'
Set @.sql = 'Update ' + @.Table + ' Set Company_id = ''' + @.Company_id + ''''
Print @.sql
--Exec sp_executesql @.sql
This will show you what the statement would look like if you hard coded it.
Then uncomment out this line "Exec sp_executesql @.sql" and the statement will execute.
later,
mkal
No comments:
Post a Comment