Define cross join in sql server joins?

0 Answers  

---

where do you use Isolations?give me some exmpale?

1 Answers  

---

What triggers long term care?

0 Answers  

---

What are the advantages of using a stored procedure?

0 Answers  

---

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

---

How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  

---

Explain what is meant by replication of database?

0 Answers   Cap Gemini,

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  

---

what is package and it uses and how can u call a package

0 Answers   Satyam,

---

What are cursors and when they are useful?

0 Answers  

---