if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What is @@error in sql?

0 Answers  

---

How to concatenate two character strings together?

0 Answers  

---

---

Do you know the isolation level that sql server support?

0 Answers  

---

What is etl - extraction, transformation, and loading?

0 Answers  

---

What is de-normalization and when do you do it?

3 Answers  

---

List out the difference between union and union all in sql server?

0 Answers  

---

What will be the maximum number of indexes per table?

0 Answers  

---

What is the use of group by clause?

0 Answers  

---

What are system databases into sql server (2005/2008) : sql server database administration

0 Answers  

---