Answer / supriya gupta

SQL Server is a relational database management system
(RDBMS) from Microsoft that's designed for the enterprise
environment. SQL Server runs on T-SQL (Transact -SQL), a set
of programming extensions from Sybase and Microsoft that
add several features to standard SQL, including transaction
control, exception and error handling, row processing, and
declared variables.

Your table has a large character field there are queries that use this field in their search clause what should you do?

1 Answers  

---

How m-m relationships are implemented?

2 Answers  

---

Explain the database you used in your final year project?

1 Answers   Wipro,

---

What are null values in ms sql server?

1 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

What is Left Outer Join?

2 Answers  

---

Explain the dirty pages?

1 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1 Answers   HCL, Wipro,

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

1 Answers  

---