What is conditional split?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

Which autogrowth database setting is good?

0 Answers  

---

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

---

What is the difference between update lock and exclusive lock?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

Define full outer join in sql server joins?

0 Answers  

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

What is a rollup clause?

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

What is de-normalization and when do you do it?

3 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  

---