Want to add column in table in dynamic query
Database
2
Posts
2
Posters
0
Views
1
Watching
-
I want to add a column in a table using dynamic query. e.g set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[SP_InsertColumnToAudience] @ColumnName varchar(50) as set nocount on declare @qry varchar(250) begin set @qry='alter table tblAudience add aaa1aa varchar(100) NULL' exec @qry end but it gives error........ any sugession........
Do good and have good.
-
I want to add a column in a table using dynamic query. e.g set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[SP_InsertColumnToAudience] @ColumnName varchar(50) as set nocount on declare @qry varchar(250) begin set @qry='alter table tblAudience add aaa1aa varchar(100) NULL' exec @qry end but it gives error........ any sugession........
Do good and have good.
Try:
exec(@qry)