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

0 Answers  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

Explain where clause?

0 Answers  

---

How do you create type- insensitive operator?

0 Answers   EXL,

---

What are the advantages of using cte?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

How to modify an existing stored procedure in ms sql server?

0 Answers  

---

What number sorts of privileges are accessible in sql?

0 Answers  

---

What is the difference between Procedure and Function

4 Answers   Accenture, Nagarro, TCS,

---

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---