Define cross join in sql server joins?

0 Answers  

---

Explain what is the difference between union and union all?

0 Answers  

---

What are the four main query statements?

7 Answers   Wipro,

---

Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

---

What is after dml trigger?

0 Answers  

---

What is b tree index?

0 Answers  

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---

What do you mean by collation recursive stored procedure?

0 Answers  

---