Answer Posted / dinesh sharma
In Sql Server Function are Like S.P Mean Batch of SQL
command. But Function Must Return Single Value
In SQL Server Four Type Of Function
1)Table-Valued Function:Return Datatable
2)Scaler Valued Function:return Single value
3)Aggreated Funtion:Return Aggreatged Result set
4)System Funtion:used by system like Rowset etc.
| Is This Answer Correct ? | 8 Yes | 13 No |
Post New Answer View All Answers
Does table partitioning improve performance?
What is recompile sql server?
How many replicas are maintained for each SQL Azure database?
What is BCP? When does it used in sql server 2012?
what is an index? : Sql server database administration
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How to add more data to the testing table in ms sql server?
How network traffic be reduced by using the stored procedure?
Does partitioning improve performance sql server?
How to get a list of all tables with "sys.tables" view in ms sql server?
What is the difference between insensitive and scroll cursor?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is the optimization being performed in oracle and SQL Server?
How to recompile stored procedure at run time?
What is compound operators?
