What is the difference between Userdefined function and
stored procedure? Explain and give the example also
Answer Posted / ashish
Please check out the below link. I think it may be useful:
http://newtechnobuzzz.blogspot.in/2014/07/difference-between-user-defined-funtion.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how to maintain a fill factor in existing indexes?
How data can be copied from one table to another table?
Can you move the resources after pausing the node? : sql server database administration
How to set a database state to offline in ms sql server?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What are the types of joins in sql?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Why use view instead of a table?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is an example of a foreign key?
Explain about Normalization?
What is row_number function?
How to create an index on an existing table in ms sql server?
How do you trace the traffic hitting a sql server?
What is the query and subquery?