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 cursor in ms sql server?

0 Answers  

---

event classes in sql server

2 Answers   Accenture, AFE,

---

Differentiate between a having clause and a where clause.

0 Answers  

---

Do you know what is replace and stuff function in sql server?

0 Answers  

---

How do you Implement SSIS Packages in your Project?

0 Answers  

---

How to create and drop temp table in sql server?

0 Answers  

---

What is logshipping and its purpose?

0 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

How to find the source of a table in sql server?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

How to create a store procedure with encryption?

0 Answers  

---