Answer Posted / rakesh
function always return value, and procedure not Return the value.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Can select statements be used on views in ms sql server?
What is difference between table aliases and column aliases? Do they affect performance?
How to delete multiple rows with one delete statement in ms sql server?
What are different backups available in sql server?
How to invoke a trigger on demand?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is a mutating table error and how can you get around it?
What to check if a User database is locked?
What is the default server name for sql server?
Write a SQL query to delete a table?
How to create a trigger for insert only?
Why can there be only one clustered index and not more than one?
How can you find out which stored procedures are recompiling?
What is the new security features added in sql server 2016? : sql server security