Interested to Buy Any Domain ? << Click Here >> for more details...
how many types of store procedre in sqlserver 2000?
- 2 Answers
- 5775 Views
- ATI, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are Spatial data types in SQL Server 2008
What is store procedure? When do you use?
How to see the event list of an existing trigger using sys.trigger_events?
What are the lambda triggers?
What is @@error in sql?
What is tempdb in sql server?
What are rest-style architecture's?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is data compression?
Explain the phases a transaction has to undergo?
Why is sql server log file full?
Explain the cursor lock types?
Can We Use Data-grids For Our Report In Ssrs?
What is the maximum number of index per table?
