When would you use the stored procedures or functions?
No Answer is Posted For this Question
Be the First to Post Answer
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
What the class forname () does?
Explain view in sql server?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
How to provide Security for package?
Explain what is dbcc?
What are the character string functions supported by sql server 2005?
what is the difference between procedure and function.
Can you explain some of the DTS problems?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
what are default? Is there a column to which a default cant be bound?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)