Go Back   Site Owners Forums - Webmaster Forums > Web Programming > Programming General > PHP / mySQL

Notices


Reply
 
Thread Tools Rate Thread Display Modes
Old 06-01-2018, 10:17 AM   #1
Pavan Techn
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.
Pavan Techn is offline   Reply With Quote

Old 09-03-2019, 01:34 AM   #2
smith1
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.
smith1 is offline   Reply With Quote
Old 08-12-2020, 07:42 AM   #3
Kumkum
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/
Kumkum is offline   Reply With Quote
Old 02-11-2021, 03:09 AM   #4
FrankLee
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.
FrankLee is offline   Reply With Quote
Old 02-12-2021, 01:38 AM   #5
FrankLee
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
FrankLee is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

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


All times are GMT -7. The time now is 04:58 AM.


Powered by vBulletin Copyright © 2020 vBulletin Solutions, Inc.