To cut a very long story short I wa

[mikehilly]

To cut a very long story short I want to use varibles in an Alter command in an SP i.e
ALTER TABLE @tableName ALTER COLUMN @fieldName datetime
but it gives me a syntax error. Is there any way around it or should I start hand cranking database mods now.

Regards

Mike

 

[ColinM]

You want to use what is called dynamic sql
i.e. something like this

DECLARE @Table VARCHAR(100)
DECLARE @Column VARCHAR(100)
DECLARE @SQL VARCHAR(8000)

SET @Table = 'mytable'
SET @Column = 'mycolumn'

SET @SQL = 'Alter table ' + @Table + ' ALTER COLUMN ' + @Column + ' datetime'

PRINT @SQL
EXEC(@SQL)