What is the difference between stored procedure and functions?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

optimization techinques

0 Answers   Wipro,


What is store procedure?

0 Answers  


How to receive output values from stored procedures?

0 Answers  


How to download and install microsoft .net framework version 2.0?

0 Answers  


‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  






Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,


hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  


How to connect php with different port numbers?

0 Answers  


Where do we use trace frag?

0 Answers  


What is the purpose of sql profiler in sql server?

0 Answers  


what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  


Categories