Answer / sreejith s t

Default means giving some default value to column . If we
are not inserting any value to that column , default value
will be inserted .

Default cant be bound to identity and
timestamp columns .

What is transaction server auto commit?

1 Answers  

---

How can sql injection be stopped? : sql server security

1 Answers  

---

Can you name some of the dml commands in sql?

1 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

What are transactions in sql?

1 Answers  

---

What is sql injection? How to protect against sql injection attack?

1 Answers  

---

In what three ways is the return statement used in a stored procedure?

1 Answers  

---

What are the advantages of using cte?

1 Answers  

---

How do I setup a sql server database?

1 Answers  

---

How can you know if the row fetched from cursor is still valid in underlying table?

1 Answers  

---

Call by value and call by reference in procedure and function, with NOCOPY.

1 Answers   Nagarro,

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---