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,

---

How can change procedure in sql server?

0 Answers  

---

Can you move the resources after pausing the node? : sql server database administration

0 Answers  

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

---

What is a trigger and its types?

0 Answers  

---

What are a scheduled jobs?

0 Answers  

---

When we should use @@error?

0 Answers  

---

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 Answers  

---

what is extended StoreProcedure ?

3 Answers   Satyam,

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

Define full outer join in sql server joins?

0 Answers  

---