sample76.sql

100多个SQL小程序,包含游标,基本增删改查,希望多你有用

/* 文件名称: Sample76.sql */
USE pubs

SELECT 姓名 = au_fname + ' ' + au_lname, 
       州名 = CASE state
                WHEN 'CA' THEN 'California'
                WHEN 'KS' THEN 'Kansas'
                WHEN 'TN' THEN 'Tennessee'
                WHEN 'OR' THEN 'Oregon'
                WHEN 'MI' THEN 'Michigan'
                WHEN 'IN' THEN 'Indiana'
                WHEN 'MD' THEN 'Maryland'
                WHEN 'UT' THEN 'Utah'
             END
FROM authors
ORDER BY au_lname