Can you use the alter table command on a table variable? I am trying to
convert rows from a resultset into columns of a table. I can get it to work
using a temp table, just though it would be faster with a table variable.
TIA
Bill
by bill.c.kin » Sat, 03 May 2003 23:29:38
TIA
Bill
by Aaron Bertrand - MV » Sat, 03 May 2003 23:47:47
No, from http://support.microsoft.com/?kbid=305977:Quote:> Can you use the alter table command on a table variable?
"The table definition cannot be changed after the initial DECLARE
statement."
Not necessarily. You should try both with your usage, structure and data.Quote:> just though it would be faster with a table variable.
by bill.c.kin » Sat, 03 May 2003 23:52:50
Quote:> > Can you use the alter table command on a table variable?
> No, from http://support.microsoft.com/?kbid=305977:
> "The table definition cannot be changed after the initial DECLARE
> statement."
> > just though it would be faster with a table variable.
> Not necessarily. You should try both with your usage, structure and data.
> That way you can make an educated choice for your exact scenario.
I need syntax and example help.
I need to do an Alter table so I can add/modify a default value to a column
in a table.
I don't know why but i can't seem to get it right....
Thanks!
Eric
2. How to store and retrieve a metafile in an Oracle database ?
4. How to set a blank space and a divider in an external value list?
7. Alter Table help needed please.
8. Retrieve Indexed Records from within a Stored Procdeure
10. Alter table help
11. Help with Alter Table Alter Column