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 points to remember while using the fillfactor argument?

960

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2057

---

Write a SQL query in order to merge two different columns into single column?

1028

---

Can you index views?

891

---

What is the advantage of sql server?

1025

---

What are transactions in sql?

1049

---

What are the new security features added in sql server 2012? : sql server security

1009

---

What is a partitioned view?

978

---

How to loop through result set objects using odbc_fetch_row()?

962

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2330

---

Can sql servers linked to other servers?

1028

---

What are the built in functions in sql server?

965

---

Do you think BCNF is better than 2NF & 3NF? Why?

1269

---

What is forward - only cursors / read only cursor?

1080

---

What are filegroups in sql server?

1053

---