how many types of store procedre in sqlserver 2000?
Answers were Sorted based on User's Feedback
Answer / prashanthi g
Types of StoredProcedures
1.Userdefined StoredProcedures
2.SystemDefined storedprocedure
3.Temporary
4.Remote
5.Extended
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
What is Check point? Explain in Brief what it will do?
What is a group function explain with an example?
What is sql server query analyzer?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is acid db?
What is table value parameters (tvp)?
If i am handling 150 servers then how to check the active jobs of all the servers?
Do you know how to send email from database?
What is the use of placing primary key and foreign key constrains on columns.
what is the difference between Delete and Truncate command in SQL
How will u find the query which is running in some other machine
4 Answers CarrizalSoft Technologies, IBM,
What are triggers? How do you invoke a trigger on demand?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)