types of Store procedure in Sqlserver2000?
Answers were Sorted based on User's Feedback
Answer / prabhakar
system stored procedures,
user defined stored procedures
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / vishesh tomar
There are three types of Stored Procedure in sql server
1. User Defined
2. System Defined
2. Temprary Stored Procedure
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / javed khan
There are different types of store procedure in sql server
2000 some of these store procedure are as folm.
1. user defined store procedure
2. Systems Store Procedure
3. Extended Store Procedure
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain the difference between sqlcommand object and command behavior object?
How can we load multiple tables in a dataset?
Differentiate between Dataset and Recordset.
How you will set the datarelation between two columns?
ADO and ADO.NET differences?
What is Data view?
What is the purpose of using adodb?
What is difference between datatable and dataset?
Which architecture does Datasets follow?
what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?
What we do with the object of ado.net dataset after using it?
What we do with the object of ado.net dataset after using it?Can we dispose it or can we set it nothing?Is it must or not?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)