What do you mean by recursive stored procedure?

0 Answers  

---

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

---

What is it unwise to create wide clustered index keys?

0 Answers  

---

What is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

---

Explain magic tables in sql server?

0 Answers  

---

What is the latest version of microsoft sql server?

0 Answers  

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What are the system database in sql server 2008?

0 Answers  

---

Where is localdb stored?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---