Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sql2000
Its Possible, run the below code and have a look...
begin transaction
create table test (col1 int, col2 int)
insert into test values (1, 1)
insert into test values (1, 2)
insert into test values (1, 3)
insert into test values (2, 1)
delete from test where col1 = 2
alter table test
alter column col2 int not null
alter table test
add
constraint [pk_col2] primary key nonclustered(col2) on
[primary]
rollback transaction
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Differentiate between a local and a global temporary table?
Why would you call update statistics?
What is a document index?
Define right outer join in sql server joins?
What is primary key and example?
In what version of sql server were synonyms released?
Explain four layers of abstraction microsoft architectured?
How to enter unicode character string literals in ms sql server?
Explain indexing and what are the advantages of it?
Can you explain the disadvantages/limitation of the cursor?
what is a correlated sub-query? : Sql server database administration
What is the purpose of a table?
What is data source in connection string?
What is sql injection? How to protect against sql injection attack?
What is the process of indexing?
