示例5-3.sql

来自「SQL Server 业已成为最为流行的几大数据库之一」· SQL 代码 · 共 15 行

USE Northwind
GO

DECLARE @lAccountName AS VARCHAR(20)
DECLARE @lPassword AS VARCHAR(10)
DECLARE @lAccountType AS UserDefinedType
DECLARE @lEML AS VARCHAR(20)

SELECT @lAccountName=AccountName,@lPassword=Password,
		@lAccountType=AccountType,@lEML=EML
FROM Account
PRINT @lAccountName +'   '+@lPassword+'    '+CONVERT(VARCHAR(20),@lAccountType)+'   '+CONVERT(VARCHAR(20),@lEML)
+'    帐号类型代码：'+Convert(varchar(20),@lAccountType.MangeTypeID)