how many types of store procedre in sqlserver 2000?
Answers were Sorted based on User's Feedback
Answer / prashanthi g
Types of StoredProcedures
|Is This Answer Correct ?||4 Yes||1 No|
Answer / dinesh sharma
Their Are Two Type Of SP
2)dbo (DataBase Owner) mean User Defined SP
|Is This Answer Correct ?||4 Yes||2 No|
What is Online Index Rebuild Operation?
Explain what is it unwise to create wide clustered index keys?
What is difference between getdate and sysdatetime in sql server 2008?
How to avoid cursors?
What are the different authentication modes in sql server? How can it be changed?
Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).
Are null values the same as that of zero or a blank space?
How you provide security to cube? : sql server analysis services, ssas
What are secondary xml indexes?
How can we rewrite sub-queries into simple select statements or with joins?
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
Explain the new features of SQL server 2000?