adspace


how many types of store procedre in sqlserver 2000?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is acid mean in sql server?

1244


What is clustered index

1085


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1132


How to connect php with different port numbers?

1185


How do I find query history in sql server?

1022


List the ways in which dynamic sql can be executed?

1085


Explain “row_number()” in sql server with an example?

1077


How to convert numeric expression data types using the cast() function?

1146


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1022


What are the properties of the transaction?

1071


What are the source of constraints?

1008


What is normalization and what are the advantages of it?

1054


What is self contained sub query?

1138


Is it possible to have clustered index on separate drive from original table location?

1039


What is sql or structured query language?

1226