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)