2 具體內(nèi)容
2.1 使用范圍
SQL Server(2008開始) ;Azure SQL數(shù)據(jù)庫(kù);Azure SQL數(shù)據(jù)倉(cāng)庫(kù);并行數(shù)據(jù)倉(cāng)庫(kù)
2.2 語(yǔ)法
是SQL Server數(shù)據(jù)庫(kù)引擎評(píng)估以獲取單個(gè)數(shù)據(jù)值的符號(hào)和運(yùn)算符的組合。簡(jiǎn)單表達(dá)式可以是單個(gè)常量,變量,列或標(biāo)量函數(shù)。運(yùn)算符可用于將兩個(gè)或多個(gè)簡(jiǎn)單表達(dá)式連接到一個(gè)復(fù)雜的表達(dá)式中。
-- Syntax for SQL Server and Azure SQL Database { constant | scalar_function | [ table_name. ] column | variable | ( expression ) | ( scalar_subquery ) | { unary_operator } expression | expression { binary_operator } expression | ranking_windowed_function | aggregate_windowed_function } -- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse -- Expression in a SELECT statement <expression> ::= { constant | scalar_function | column | variable | ( expression ) | { unary_operator } expression | expression { binary_operator } expression } [ COLLATE Windows_collation_name ] -- Scalar Expression in a DECLARE, SET, IF…ELSE, or WHILE statement <scalar_expression> ::= { constant | scalar_function | variable | ( expression ) | (scalar_subquery ) | { unary_operator } expression | expression { binary_operator } expression } [ COLLATE { Windows_collation_name ]
本文題目:詳解SqlServer表達(dá)式(expression)-創(chuàng)新互聯(lián)
網(wǎng)站地址:http://www.chinadenli.net/article42/doephc.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供網(wǎng)站導(dǎo)航、軟件開發(fā)、微信公眾號(hào)、建站公司、商城網(wǎng)站、ChatGPT
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)
猜你還喜歡下面的內(nèi)容