how many type of subquery?

2 Answers  

---

What is sql service broker?

0 Answers  

---

What is the purpose of update statistics and scope_identity() function?

0 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,

---

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

---

What is db stored procedure?

0 Answers  

---

What is a field in a table?

0 Answers  

---

What are the various Isolation levels?

2 Answers   HP,

---

What is the use of partition by in sql server?

0 Answers  

---

Explain about nested stored procedure?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

What is a recursive stored procedure in sql server?

0 Answers  

---