Interested to Buy Any Domain ? << Click Here >> for more details...
how many types of store procedre in sqlserver 2000?
- 2 Answers
- 5772 Views
- ATI, I also Faced
- E-Mail Answers
Answer Posted / dinesh sharma
Their Are Two Type Of SP
1)System SP
2)dbo (DataBase Owner) mean User Defined SP
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What do you understand by mirroring?
How many types of subqueries are there in sql server?
What are the differences between char and nchar in ms sql server?
What are distinctive joins find as a part of sql?
Explain what is log shipping?
What is the difference between the 2 operating modes of database mirroring?
Tell me what is difference between view and materialized view?
Which table keeps the locking information?
Is it important for a database administrator to understand the operating system and file access?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What are the differences between stored procedure and the dynamic sql?
What is lock escalation? : sql server database administration
What is save transaction and save point?
What’s the use of custom fields in report?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
