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 the difference between cartesian product and cross join?

0 Answers  

---

How is foreign key related to primary key?

0 Answers  

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

What is the correct order of the logical query processing phases?

0 Answers  

---

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

---

What is the difference between having and where clause?

4 Answers  

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---

What is the filtered index?

0 Answers  

---

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  

---

Which joins are sql server default?

0 Answers  

---