Answer Posted / ramesh.l.v

SELECT SERVERPROPERTY('PRODUCTLEVEL')

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1076

---

Explain optimistic and pessimistic concurrency?

1037

---

Is the primary key column of a table an index in ms sql server?

1005

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1941

---

Describe different Processing Modes offered by SSRS?

256

---

How to receive output values from stored procedures?

1237

---

What is a result set object returned by odbc_exec()?

1079

---

Explain what are magic tables in sql server?

1047

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1032

---

What is a bit datatype?

1022

---

How to drop an existing schema in ms sql server?

1147

---

What is the difference between Clustered and Non-Clustered Index?

1105

---

What are types of subqueries?

1135

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1054

---

How to delete a database in ms sql server?

1322

---