Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What is pessimistic concurrency?

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

What is extended stored procedures?

0 Answers  

---

what is a mixed extent? : Sql server administration

0 Answers  

---

How do I find sql server instance name?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

What is difference between joins and subqueries?

0 Answers  

---

What is normalization 1nf 2nf 3nf?

0 Answers  

---