What is the difference between functions and stored procedures?


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

Post New Answer

More SQL Server Interview Questions

Explain features and concepts of analysis services?

0 Answers  


How do I view a trc file?

0 Answers  


your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  


What does normalization do to data?

0 Answers  


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

0 Answers  






Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers   United Healthcare,


Explain hostprotectionattribute in sql server 2005?

0 Answers  


Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,


Does index speed up select statements?

0 Answers  


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  


Explain what is the function of sql server agent windows service?

0 Answers  


How to Check if table exists in sql server?

0 Answers  


Categories