Explain microsoft sql server functions?

0 Answers  

---

What is sql injection and why is it a problem? : sql server security

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

What is mean by dml?

0 Answers  

---

What is difference between line feed ( ) and carriage return ( )?

0 Answers  

---

What is schemabinding a view?

0 Answers  

---

Can we delete data from a view?

0 Answers  

---

What are sparse columns?

0 Answers  

---

List the data types available in mssql?

0 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

---