Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jijo
Three types
1) Scalar
A scalar user defined function returns one of the scalar
data type .text,ntext,etc
2) inline table Value
An inline table value function return a table data type
3) multi -statement table value function
A multi -statement table value function return a table and
is also an exceptional alternative to a view as the function
can support multiple t-sql statements to build the final result
| Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
what kind of lan types do you know? : Sql server database administration
How to list all tables in the database using odbc_tables()?
What happens if you add a new index to large table?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How to insert a new row into a table with "insert into" statements in ms sql server?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How to create a new table in a given schema?
What are the different types of upgrades that can be performed in sql server?
What are triggers? How do you invoke a trigger on demand?
What is the maximum number of index per table?
what are database files and filegroups? : Sql server database administration
What is the contrast between sql and pl/sql?
How to Update from select query in sql server?
What is an etl file?
Explain Capacity planning to create a database? and how to monitor it?
