rajender goud m


{ City } hyderabad
< Country > india
* Profession * sql server dba
User No # 54375
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 31
Users Marked my Answers as Wrong # 3
Questions / { rajender goud m }
Questions Answers Category Views Company eMail




Answers / { rajender goud m }

Question { C1 India, 19013 }

Difference between Function and Stored Procedure?


Answer

The difference mejor between procedure and function is that
function must return value. that should be only single and
function can pass any no. parameter but come out only one
value only using return statement.

procedure can pass any parameter and came out any no. of
values there no any RETURN word.

Is This Answer Correct ?    4 Yes 1 No

Question { Bank Of America, 9617 }

How many nested transaction can possible in sql server?


Answer

There is a limit of 32 on the maximum nested levels on both
SQL Server 2000 and 2005

Is This Answer Correct ?    27 Yes 2 No