Answer Posted / jayanth
Functions always returns a value where as sp performs bath execution
functions can be used along with select statement and where clause where as functions cannot be used with update insert delete statements in which sp cannot be used with select and DML events
functions cannot be used with try catch block where as sp can use try catch block
functions are of two types system functions and user defined functions where as sp's are four types mostly
sp with parameters
sp without parameters
sp with out parameters
sp with return values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is log shipping?
What are the advantages of stored procedure in sql server?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What method is used by the Command classes to execute SQL statements that return single values?
Different types of keys in SQL?
How to add a new dsn with the odbc driver for sql server?
Explain features and concepts of analysis services?
Explain the different types of joins?
What is meant by referential integrity?
how to create “alternate row colour”?
Which are ddl commands?
What are partitioned views and distributed partitioned views?
When is the use of update_statistics command?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
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?