This maybe a stupid questions, but I need to ask.......
I am trying to use a string builder to alter, update a table in sql server 2000. On sql server this statement works:
ALTER TABLE lessons ADD oldId int DEFAULT(0)
GO
However, when I insert that into my string builder It gives me this error:
Incorrect syntax near 'GO'.
If I take out the GO, this is the error:
Invalid column name 'oldId'. Invalid column name 'oldId'. Invalid column name 'oldId'. Invalid column name 'oldId'.
Any help????
I am trying to use a string builder to alter, update a table in sql server 2000. On sql server this statement works:
ALTER TABLE lessons ADD oldId int DEFAULT(0)
GO
However, when I insert that into my string builder It gives me this error:
Incorrect syntax near 'GO'.
If I take out the GO, this is the error:
Invalid column name 'oldId'. Invalid column name 'oldId'. Invalid column name 'oldId'. Invalid column name 'oldId'.
Any help????