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

What is the usage of the sign function?

1075

---

What is normalization? Describe its different types.

1082

---

What is sub-query in sql server? Explain its properties.

1071

---

How to enter date and time literals in ms sql server?

989

---

What is the contrast amongst drop and truncate?

1024

---

How to rebuild all indexes on a single table?

1037

---

What is difference between rollback immediate and with no_wait during alter database?

1061

---

What are the steps you can take to avoid “deadlocks”?

953

---

What is the difference between a primary key and a unique key? Are they the same?

1055

---

What is the sql profiler?

927

---

What are different types of schemas?

924

---

What is indexing a document?

1016

---

What are the requirements for sql server 2016?

870

---

What are the components of sql server service broker?

990

---

What is the difference between mysql and mysqli?

1163

---