What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / srinivas
Stored procedures are a set of actions already written and
stored inside the database for acheiving a particular task
where as functions are general database objects which are
used for general purpose programming
| Is This Answer Correct ? | 46 Yes | 27 No |
Post New Answer View All Answers
can a database be shrunk with users active? : Sql server administration
How can I get data from a database on another server?
Where do you find the default Index fill factor and how to change it?
Explain the creation and execution of a user-defined function in the sql server?
How can I check that whether automatic statistic update is enabled or not?
Can we add an identity column to decimal datatype?
What are the properties of the transactions?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Explain about the command-line tool SQLCMD?
what types of replication are supported in sql server? : Sql server database administration
What are constraints?
Give a example to search fr a string in all stored procedure in sql server.
How do you improve the performance of a SQL Azure Database?
Where in ms sql server is ’100’ equal to ‘0’?
Tell me what is log shipping?