variable in SQL Alter statement

[kewlcoder]

Hi,

can i give a SQL command like this in VB

"alter table sal_Structure add @str1 int NULL"

here str1 is a string in VB so i have given it as @str1

please tell me if it is possible to use a string or a vriable for altering a given table

in both SQL and VB

thank you
Kewlcoder

in SQL i tried something like this kindly help me
I am new to SQL Programming

CREATE FUNCTION all_add()
returns bit
AS
DECLARE @itm VARCHAR(20)
DECLARE @succ bit
select @itm = all_code from all_Mas
where all_new = 1
ALTER TABLE sal_Structure ADD @itm VARCHAR(10)
GO

 

[amrita418]

Replace the alter stmt with an the code below:

exec('ALTER TABLE sal_Structure ADD ' + @itm + ' VARCHAR(10)')

Regards,
AA