Skip to navigation
Mssql store procedure with a dynamicly generated sql string
28.11.16
ALTER PROCEDURE [dbo].[zz_update_categories] @category varchar(max) ,@F21_av0_section varchar(max) ,@col varchar(max) ,@value varchar(max) AS DECLARE @str nvarchar(max) SET @str = CONCAT('UPDATE [SL].[dbo].[zz_categories] SET ', @col, ' = ''', @value, ''' WHERE category = ''', @category, ''' AND F21_av0_section = ''', @F21_av0_section, '''') EXEC sp_executesql @str RETURN 1
http://www.sommarskog.se/dynamic_sql.html
Reply
Anonymous
Information Epoch 1714837627
Using text data files.
Home
Notebook
Contact us
