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
What is “asynchronous” communication in sql server service broker?
What are the common performance issues in sql server?
What new changes are being made in SQL Server?
Do you have any idea about the tcl commands?
How do I trace a query in sql server?
How to sort the query output with order by clauses in ms sql server?
What is a dbms wizard?
What is auditing in sql server?
What is RMS migrations?
Who is the owner of a schema in ms sql server?
What are partitioned views and distributed partitioned views?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
How can we remove orphan records from a table?
Do you think BCNF is better than 2NF & 3NF? Why?
What is efficiency data?
