rameshchandra.a (7/11/2008)
4.What are temperory tables.(perfermence wise cursors r Temperory Tables which are better)If a WHILE loop is involved, then each will suck as bad as the other
5.What is CTE(Common Table Expression) in Sql Server.
It helps people who don't know how to write T-SQL. 😛
8.Diff between Stored Procedures and Stored Functions.
One is real, the other is not... they're called "User Defined Functions"...😉
10.Types of Cursors.
Two types... good maintenance cursors that control setbased processes written by a DBA... and bad. :hehe:
--Jeff Moden
Change is inevitable... Change for the better is not.