Answer Posted / vijayabhaskarreddy

wen we are performing DML operations into table . amagic
table created in the memory.
inserted magic table
deleted magic table
update magic table

What do you understand by intent locks?

1003

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1038

---

Why use view instead of a table?

949

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1383

---

How to generate create function script on an existing function?

1109

---

How to execute the cursor queries with "open" statements?

1176

---

Explain comment on transactions?

976

---

How do I start sql server agent automatically?

965

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1743

---

What is the recovery model? List the types of recovery model available in sql server?

900

---

How real and float literal values are rounded?

1153

---

How to create a trigger for insert only?

1034

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2336

---

Define right outer join in sql server joins?

1040

---

What are different types of join?

1306

---