7-13.sql

来自「sql2000工程实践一书的代码 可以直接调试」· SQL 代码 · 共 10 行

USE pubs
USE pubs
GO
DECLARE @state char(2)
SET @state = 'UT'
SELECT RTRIM(au_fname) + ' ' + RTRIM(au_lname) AS Name, state
FROM authors
WHERE state = @state
GO