34,590
社区成员
发帖
与我相关
我的任务
分享
USE tempdb
GO
IF OBJECT_ID('user_data') IS NOT NULL DROP TABLE user_data
GO
CREATE TABLE user_data(
userId INT IDENTITY(1,1) PRIMARY KEY,
userName NVARCHAR(20),
userType INT
)
GO
INSERT INTO user_data(userName,userType) VALUES('小明',1);
INSERT INTO user_data(userName,userType) VALUES('小华',2);
INSERT INTO user_data(userName,userType) VALUES('大牛',3);
SELECT * FROM user_data AS u
INNER JOIN (VALUES(1,'工人'),(2,'农民'),(3,'知识分子')) AS L(userType,userTypeDesc)
ON u.userType=L.userType
--2008 新语法
select c from (values(1),(1)) as d(c);
--2005 代替写法
SELECT c FROM (
SELECT 1 AS c
UNION ALL
SELECT 1
) AS d