What is the difference between stored procedure and functions?

Question Posted / mohiddin@786

0 Answers
1137 Views
MCN Solutions, I also Faced
E-Mail Answers

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

More SQL Server Interview Questions

Explain powershell included in sql server 2008?

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers Cognizant,

How to drop an existing table?

0 Answers

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers Aviva,

How would we use distinct statement? What is its use?

0 Answers

What is best institute to Learn DotNET And SQL in chennai?

0 Answers

What is the purpose of indexing?

0 Answers

What is a bit datatype?

0 Answers

How get current date in SQL server 2000

4 Answers Cap Gemini, Polaris,

Which are the olap features?