Can you give an example of Stored Procedure?
Answer Posted / guest
sp_helpdb , sp_who2, sp_renamedb are a set of system defined
stored procedures. We can also have user defined stored
procedures which can be called in similar way.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
When we should use and scope of @@identity?
Define master database?
What is delete query?
mention different types of relationships in the dbms?
What is sql server database?
What is set nocount on and what is set nocount off?
Explain an incremental backup?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is difference in performance between insert top (n) into table and using top with insert?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
do views contain data ?
Explain different types of Normalization.
How do I find the port number for sql server?
What is the usage of the sign function?