Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-07 : 13:34:53
|
Praveen writes "1.How do you add or remove the column property IDENTITY for a particular column in a table with TSQL statement(not in Entreprise Manager).
e.g. ALTER TABLE TABLEX
ALTER COLUMNX INTRGER IDENTITY
is worng statement.
----------------------------------------------
2. How can I add a new column in desired sequence to an existing table, without effecting data, USING TSQL statements.
(I want to add a new column in the first position, not in the last)
-----------------------------------------------
Both above task are possible by Entreprise Manager.
Please sned me reply as soon as possible.
thanks
Praveen" |
|
|
|
|
|
Transact SQL