|
发表于 2019-5-23 10:00:32
|
显示全部楼层
本帖最后由 xx_player 于 2019-5-23 10:01 编辑
嗯,还行,不过,你是SQL表呀。怎么用这种方式这么建呢。应该用TSQL语法
CREATE TABLE students /*表名*/
(
name nvarchar(20), /*学生名*/
hobby1 tinyint, /*爱好1-0无 1唱歌 */
hobby2 tinyint, /*爱好2-0无 2跳舞 */
hobby3 tinyint /*爱好3-0无 3打篮球*/
)
CREATE TABLE dictionary /*爱好字典*/
(
seq tinyint, /*爱好序号 0无 1唱歌2跳舞3打篮球4..5...等等 */
describe nvarchar(30), /*爱好名称*/
CONSTRAINT PK_seq PRIMARY KEY CLUSTERED (seq)
)
查询学生AAA
select name as 姓名,
(select describe from dictionary,students where name='AAA' and hobby1=seq) as 爱好1,
(select describe from dictionary,students where name='AAA' and hobby2=seq) as 爱好2,
(select describe from dictionary,students where name='AAA' and hobby3=seq) as 爱好3
from students
where name='AAA'
结果
姓名 爱好1 爱好2 爱好3
1 AAA 唱歌 跳舞 打球
测试环境 MSSQL
这些东西都快忘完了。
|
|