Differentiate between sql temp table vs table variable?

0 Answers  

---

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 Answers  

---

Define inner join in sql server joins?

0 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

What is table-valued sub query?

0 Answers  

---

How do you Implement SSIS Packages in your Project?

0 Answers  

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

What is the recommended total size of your memory optimized tables?

0 Answers  

---

Where can you add custom error messages to sql server?

0 Answers  

---