Answer / dba

You cannot define stored procedures (SP) or user-define
functions (UDF) in a nested fashion. However, you can
execute SPs and UDFs inside of stored procedures. The
nesting is limited to 32 levels deep (A calls B, which calls
C, etc). So if a recursive call is used (A calls A), you
must have some method of stopping before 32 levels is exceeded.

You can call SPs and UDFs from inside of a UDF, but this
ability is quite limited. If a SP has any side effect, it
cannot be called. So, the SP cannot be used to return any
values to the function.

what changed between the previous version of sql server and the current version? : Sql server database administration

0 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

Can you tell me about the concept of ER diagrams?

0 Answers  

---

What is clr ddl trigger?

0 Answers  

---

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

How to know whether our backup is succesfully taken?

1 Answers  

---

Can a table be created inside a trigger?

0 Answers  

---