What is mean by dml?

0 Answers  

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---

internal language used in sql server 2000?

2 Answers  

---

How many types of subqueries are there in sql server?

0 Answers  

---

Explain go command in sql server?

0 Answers  

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

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

0 Answers  

---

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---

Explain powershell included in sql server 2008?

0 Answers  

---

When would you prefer to have a minimum number of indexes?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---