AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Sqlproformssql8/30/2023 ![]() ![]() ![]() ![]() Get help from Microsoft Q & Aįor online help, see the Microsoft Q & A Transact-SQL Forum.String Functions: ASCII CHAR_LENGTH CHARACTER_LENGTH CONCAT CONCAT_WS FIELD FIND_IN_SET FORMAT INSERT INSTR LCASE LEFT LENGTH LOCATE LOWER LPAD LTRIM MID POSITION REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SPACE STRCMP SUBSTR SUBSTRING SUBSTRING_INDEX TRIM UCASE UPPER Numeric Functions: ABS ACOS ASIN ATAN ATAN2 AVG CEIL CEILING COS COT COUNT DEGREES DIV EXP FLOOR GREATEST LEAST LN LOG LOG10 LOG2 MAX MIN MOD PI POW POWER RADIANS RAND ROUND SIGN SIN SQRT SUM TAN TRUNCATE Date Functions: ADDDATE ADDTIME CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATE DATEDIFF DATE_ADD DATE_FORMAT DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT FROM_DAYS HOUR LAST_DAY LOCALTIME LOCALTIMESTAMP MAKEDATE MAKETIME MICROSECOND MINUTE MONTH MONTHNAME NOW PERIOD_ADD PERIOD_DIFF QUARTER SECOND SEC_TO_TIME STR_TO_DATE SUBDATE SUBTIME SYSDATE TIME TIME_FORMAT TIME_TO_SEC TIMEDIFF TIMESTAMP TO_DAYS WEEK WEEKDAY WEEKOFYEAR YEAR YEARWEEK Advanced Functions: BIN BINARY CASE CAST COALESCE CONNECTION_ID CONV CONVERT CURRENT_USER DATABASE IF IFNULL ISNULL LAST_INSERT_ID NULLIF SESSION_USER SYSTEM_USER USER VERSION SQL Server Functions In this case, other Applies to sections are inserted into the appropriate argument descriptions in the body of the article. In some cases, the article is used by a product or service, but all of the arguments aren't supported. Near the top of each article, is a section that indicates which products and services support subject of the article.įor example, this article applies to all versions, and has the following label.Īpplies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)Īnother example, the following label indicates an article that applies only to Azure Synapse Analytics and Parallel Data Warehouse.Īpplies to: Azure Synapse Analytics Analytics Platform System (PDW) The T-SQL reference articles encompass multiple versions of SQL Server, starting with 2008, and the other Azure SQL services. To find the system tables, views, functions, and procedures, see these links, which are in the Using relational databases section of the SQL documentation. You can also type a T-SQL key word in the Management Studio Query Editor window, and press F1. To find T-SQL articles, use search at the top right of this page, or use the table of contents on the left side of the page. Locate the Transact-SQL reference articles ![]() Some of the Microsoft tools that issue T-SQL commands are: T-SQL compliance with the SQL standardįor detailed technical documents about how certain standards are implemented in SQL Server, see the Microsoft SQL Server Standards Support documentation. All tools and applications that communicate with a SQL Server database do so by sending T-SQL commands. T-SQL is central to using Microsoft SQL products and services. This article gives the basics about how to find and use the Microsoft Transact-SQL (T-SQL) reference articles. Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL Endpoint in Microsoft Fabric Warehouse in Microsoft Fabric ![]()
0 Comments
Read More
Leave a Reply. |