T-SQL 語言基礎與資料類型 4

T-SQL

4

Transact-SQL(T-SQL) SQL Server SQL Server

01

.NETVB

ASP SQL Server SQL Server Management Studio

02

sqlcmd... T-SQL SQL Server

03

T-SQL

T-SQL

04

4-1 T-SQL 05

T-SQL ... T-SQL

06

4-1-1? 07

(comment) T-SQL

T-SQL

SQL Server

--

4-1

-- Northwind f USE Northwind GO

-- dbo.Customers f

116

SQL Server 2008 T-SQL

SELECT Country,CustomerID,CompanyName,ContactName FROM dbo.Customers ORDER BY Country DESC -- f

01

4-1j

02

/* ... */ -

-

03

(/*) (*/)

/* */

C

4-1

4-2

05

/* */

SELECT ProductID,ProductName,UnitPrice,UnitsInStock FROM dbo.Products

06

4-2j /**/

07

SSMS

sqlcmd GO

T-SQL

USE Northwind GO

SELECT * FROM dbo.Customers

/* Employee

GO

d GO */

SELECT * FROM dbo.Products

GO

4-3j /**/

SSMS /*

113d15d1d3 '*/'f

117

 4-3 GO /* */

01 GO

02 4-1-2?

(identifiers)SQL Server

03

(

...)

04

05

tbA

KeyCol Description

06 CREATE TABLE tbA(

KeyCol INT PRIMARY KEY,

Description nvarchar(80)

07

)

T-SQL

PRIMARY KEY sp_help

tbA tbA SQL Server PK__tbA__

D7CB9CCC0A9D95DB

4-1-2-1

T-SQL

sp_dbcmptlevel SQL Server Management Studio

90 (SQL Server 2005 2008 )

SQL Server ( ) ( )

118

SQL Server 2008 T-SQL

? Unicode Standard 3.2 Unicode a z

01

A Z

? @ # ( _ )

02

SQL Server

? @

03

? T-SQL @

4-1

@@

? #

05

? ## # ##

06

07

? Unicode Standard 3.2

? Basic Latin ()

T-SQL

? @$# ( _ )

T-SQL

4-1-2-2

SQL Server T-SQL ( "" ) ( [ ] )

CREATE TABLE #t... CREATE PROC #p... tempdb

119

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download