Explain primary key, foreign key and unique key?

0 Answers  

---

How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  

---

Which virtual table does a trigger use?

8 Answers   TCS,

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

How to make a column nullable?

0 Answers  

---

What is the use of builtinadministrators group in sql server? : sql server security

0 Answers  

---

How to list all schemas in a database?

0 Answers  

---

What are date and time data types in ms sql server?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

How would you choose between a clustered and a non-clustered index?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

How do I find the port number for sql server?

0 Answers  

---