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


Please Help Members By Posting Answers For Below Questions

How to edit table in sql server 2017?

488


Explain the difference between function and stored procedure?

493


What is dknf in normalization form?

539


How to round a numeric value to a specific precision?

550


What are the advantages of policy management?

560






What is checkpoint in sql server?

588


What is the difference between seek predicate and predicate?

561


Do you know what guidelines should be followed to help minimize deadlocks?

515


What are acid properties of transaction?

523


Explain isolation levels that sql server supports?

548


How to change a login name in ms sql server?

542


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

524


What are the new features of sql server 2012 reporting service?

82


explain different levels of normalization? : Sql server database administration

505


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1482