What are the differences between stored procedure and
functions in SQL Server 2000?

Answer Posted / sandeep

Function retun value while storeprocedure nor return value

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the advantages of merge replication?

522


How will you make an attribute not process? : sql server analysis services, ssas

594


How do you handle datasets larger than 50 gb?

140


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

616


How can you insert null values in a column while inserting the data?

728






How to change the system date and time from SQL Plus Terminal ?

691


What is a partition key?

528


Explain error handling in ssis?

579


What are the different types of Indexes available in SQL Server?

527


What are the different acid properties?

635


Explain about nested stored procedure?

608


What types of replication are supported in sql server?

578


What is molap and its advantage? : sql server analysis services, ssas

556


What is PROJECTION Operation?

617


What is difference between createstatement and preparedstatement?

567