06-01-2018, 10:17 AM | #1 |
Registered User
Join Date: Mar 2018
Posts: 341
|
What is the usage of SQL functions?
SQL functions are used for following purpose:
To perform calculations on data. To modify individual data items. To manipulate the output. To format dates and numbers. To convert data types.
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. |
09-03-2019, 01:34 AM | #2 |
Registered User
Join Date: Feb 2018
Posts: 462
|
SQL functions are used extensively in databases to manipulate and process data. All SQL systems have built-in as well as user-defined SQL functions. SQL functions can act on each individual row of data or on multiple rows of data grouped on the values of a field (or fields) in the table.
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. |
08-12-2020, 07:42 AM | #3 |
Registered User
Join Date: Dec 2017
Posts: 43
|
MySQL function is a stored program that can be called when required and passed parameters to get a value in return. You can create your own functions, but there are many built-in functions provided you can use off the shelves.
You can use the functions in SQL statements or as queries in MySQL. Alternatively, they can also be used within a MySQL programming environment. You can check: https://hoststud.com/new/resources/c...must-know.647/ |
02-11-2021, 03:09 AM | #4 |
Registered User
Join Date: Jan 2018
Location: us
Posts: 127
|
MySQL can’t even touch MS SQLServer's performance and power, especially with a properly set up multi-tiered, multi-server, multi-node, multi-cluster, and high availability setup. Also, with MS SQLserver you are already paying for SSIS, SSRS, and SSAS which are the best ETL tools, the easiest to use reporting tools, and by far the only tabular or multi-dimensional (cube) development framework that should ever be discussed.
|
02-12-2021, 01:38 AM | #5 |
Registered User
Join Date: Jan 2018
Location: us
Posts: 127
|
One more thing to add is to give a try to that sql server blog full of the articles mainly focused on SQL Server database and Microsoft stack technologies. It provides the most useful info and can help you succeed. Hope it can help
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SQL Database Recovery | WilliamTravis | Search Engine Optimization | 0 | 01-14-2016 12:23 AM |
Windows Hosting on IIS 8 Server with Free SQL 2012 Database | thewebhosting | Web Promotion | 1 | 04-04-2013 08:53 AM |
SQL Server and PHP | williamcastro22 | PHP / mySQL | 16 | 06-04-2012 02:14 AM |