Differences between functions and stored procedures?
Answer Posted / gautam
function does have update or delete statment.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are xml indexes?
Why the trigger fires multiple times in single login?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
what information is maintained within the msdb database? : Sql server administration
Explain the properties of sub-query in sql server?
How many types of functions are there in sql server?
How do I create an extended event in sql server?
What is an indexing strategy?
what data regions are and what are the different data regions?
Differentiate between delete and truncate.
What is the purpose of the model database?
How do I determine how many instances of sql server are installed on a computer?
What is SQL Azure Federations?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Distinguish between commit and rollback?