Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

---

What is difference between createstatement and preparedstatement?

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

What is normalization 1nf 2nf 3nf?

0 Answers  

---

How do you create a data source?

0 Answers  

---

Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

---

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

0 Answers  

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

Explain data warehousing in sql server?

0 Answers  

---

Why would you call update statistics?

0 Answers  

---