Answer / nsatyabrat7

yes, we can,,create a child sp inside a parent sp...

Answer / satyabrat

yes, we can create ..

Answer / saddam

I dont know whether we can create an child SP inside an Parent SP. But according to me, whenever the parent SP is called then the child SP will be getting created recursively
which should not happen.

An Child SP can be called in an parent SP but it should not get created.

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---

What is checkpoint process in the sql server?

0 Answers  

---

Explain about merge replications?

0 Answers  

---

What is an index. What are the types?

0 Answers  

---

What is for xml in sql server?

0 Answers  

---

What are dml (data manipulation language) statements in ms sql server?

0 Answers  

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

What is unique key constraint?

0 Answers  

---

What is a virtual table in sql?

0 Answers  

---

What is self join in sql server joins?

0 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

Does a server store data?

0 Answers  

---