Answer Posted / s. elaiyaraja

Default is the column value used in the sql.

if you set default value in the columns when creating the
table then the insertion part if you are not passing the
value to this column the the default value will set for
this column.

For example varchar columns are defined as null value for
default value.

What are different types of collation sensitivity?

940

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1063

---

How you can get a list of all the table constraints in a database? : Sql server administration

947

---

How do I view views in sql server?

934

---

How do you create an execution plan?

882

---

1 01 101 01010

2001

---

How to manipulate data from one table to another table ?

904

---

Can we write ddl in trigger?

861

---

How to provide values to user defined function parameters?

965

---

What are the different types of triggers in SQL SERVER?

1047

---

how to take backup bcp out for a column in table in sql server?

2040

---

Explain intellisense for query editing

975

---

What are subqueries in sql server? Explain its properties.

964

---

Differentiate between delete and truncate.

994

---

Write a query to find 5th highest amount paid from the customer table.

879

---