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 |
Which tcp/ip port does the sql server run on? How can it be changed?
explain how to create a new schema in a database? : Sql server database administration
How to list all login names on the ms sql server?
From where can you change the default port?
What is normalization 1nf 2nf 3nf?
How do you create a data source?
Difference between rowid and rownum in SQL?
How to fetch the next row from a cursor with a "fetch" statement?
What is use of except clause? How it differs from not in clause?
How to Execute an Operating System Command From Within SQL Server ?
What is default port number for sql server 2000?
How to delete a database in ms sql server?
Oracle (3253)
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)