Add Column in Table

Question

Hi I want to add column through function in table by sqlserver please define how to add column?

dalachha Solanki · Answer

now it's ok ..

pradip vaghani · Answer

function call like this.... EXEC dbo.AddColumn @TableName = 'users' -- nvarchar(max) @Columnname = 'city' -- nvarchar(max) @Datatype = 'varchar(20)' -- nvarchar(max)

dalachha Solanki · Answer

Msg 557 Level 16 State 2 Line 1 Only functions and some extended stored procedures can be executed from within a function.

pradip vaghani · Answer

create FUNCTION AddColumn ( @TableName NVARCHAR(max) @Columnname NVARCHAR(max) @Datatype NVARCHAR(max) ) RETURNs int AS begin DECLARE @Status int SET @Status=1 DECLARE @Sql NVARCHAR(max) SET @Sql = 'ALTER TABLE '+ @TableName +' ADD '+@Columnname+' '+@Datatype exec sp_executeSql @Sql RETURN @Status END