Answer Posted / m.s.patil
Thre are mainly three types of functions in SQl server 2005.
1.) Scalar function
2.) Inline table valued function
3.) Multi statement table valued function
| Is This Answer Correct ? | 29 Yes | 5 No |
Post New Answer View All Answers
How can I check that whether automatic statistic update is enabled or not?
Where do you find the default Index fill factor and how to change it?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What are xml indexes?
What is index fragmentation in ms sql server?
Write a SQL query in order to merge two different columns into single column?
What are the differences between union, intersect, and minus operators?
What is bit data type? What's the information that can be stored inside a bit column?
Is BCNF better than 2NF & 3NF? Why?
what are database files and filegroups? : Sql server database administration
What are difference between Cluster index and Non-Cluster index?
What is openxml in sql server?
Explain primary key, foreign key and unique key?
Define cursor locking
How will you find out if there are expensive SQL statements running or not?