Transact-SQL 常用語法

系統預存程序

EXEC sp_help
EXEC sp_helptext

SELECT

SELECT * FROM TableName;

UPDATE

UPDATE TableName SET ColumnName = REPLACE(ColumnName, 'FlyStudioX', '翔太工坊') WHERE ColumnName LIKE '%FlyStudioX%';

條件式產生SQL

DECLARE @SQL NVarchar(MAX)

SET @SQL = 'SELECT * FROM '

IF @SpecificAirliner <> ''
    BEGIN
        SET @SQL = @SQL + 'Flight LEFT JOIN Airliner ON Flight.FlightID = Airliner.FlightID'
    END
ELSE
    BEGIN
        SET @SQL = @SQL + 'Flight'
    END

PRINT(@SQL)
EXEC(@SQL)