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
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is the current pricing model of SQL Azure?
Define full outer join?
How to use order by with union operators in ms sql server?
What is service broker?
Explain the different types of backups available in sql server? : sql server database administration
What is auditing in sql server?
What is resultset concur_updatable?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
How to perform backup for certificates in sql server? : sql server security
Can you leave a union at any time?
What is the difference between varchar and varchar(max) datatypes?
How to Check if table exists in sql server?
What is your recommendation for a query running very slow? : sql server database administration
What is shared lock?