how many types of store procedre in sqlserver 2000?
- 2 Answers
- 5327 Views
- ATI, I also Faced
- E-Mail Answers
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 |
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How do you delete duplicate records in sql server?
what is curser.
What is the datatype returned by count(*)
22 Answers 247Customer, Asian CERC,
What options are available to audit login activity? : sql server security
What is sql view?
How to get the query of a table in sql server?
What is a transaction and why is it important?
Can we shrink data file in sql server?
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?
When would you prefer to have a minimum number of indexes?
how to get max salary with employee number by using one select query and max function ??
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
