Mention the command used to rename the database.

0 Answers  

---

What is the difference between a stored procedure and a user defined function?

0 Answers  

---

What is subquery explain with example?

0 Answers  

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

How to count groups returned with the group by clause in ms sql server?

0 Answers  

---

---

what is victor class

0 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

What is the security principal at the database level that represents your session?

0 Answers  

---

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

---

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 are primary keys and foreign keys?

3 Answers  

---