Answer Posted / yvbchowdary

yes u can delete the default constraint. First find out the
constraint name for the default and then execute the
following quey

alter table <table-name> drop constraint <constraint-name>

What are four major operators that can be used to combine conditions on a where clause?

983

---

How to make a column nullable?

1033

---

What is nonclustered index with included columns ?

905

---

What information is maintained within the msdb database?

924

---

When to use null data driven subscription?

196

---

How can you append an identity column to a temporary table?

872

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

961

---

Can we add a cpu to sql server?

954

---

How to compare the top two records using sql?

1263

---

Why should we go for stored procedures? Why not direct queries?

1024

---

Why main is user defined function?

945

---

Explain the first normal form(1nf)?

966

---

How do you handle datasets larger than 50 gb?

162

---

How to create new tables with "create table" statements in ms sql server?

997

---

Where do we use trace frag?

967

---