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
what are the important architecture components of SSRS?
What do you understand by recursive stored procedure?
What is the difference between set and select?
What is the use of sign function?
What are the Advantages of using CTE in sql server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
explain different types of cursors? : Sql server database administration
In what sequence sql statement is processed?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How many columns can exist together per table?
What are the differences between triggers and stored procedures?
Do you know concepts and capabilities of sql server?
What is normalization? What number of normalization shapes are there?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What is row-level compre?