SQL Server数据库中FOR XML AUTO的使用详解续
发布时间：2025-11-03 23:49:13 来源：技术快报 作者：数据库
复制CREATE TABLE Person( ID INT IDENTITY(1,数使用1) NOT NULL, Name NVARCHAR(20) NOT NULL DEFAULT(), Age INT DEFAULT(0) NOT NULL, Sex BIT DEFAULT(0) NOT NULL ) --DROP TABLE [Order] CREATE TABLE [Order]( ID INT IDENTITY(1,1) PRIMARY KEY, PersonID INT DEFAULT(0) NOT NULL, TotalPrice DECIMAL DEFAULT(0) NOT NULL ) CREATE TABLE Product( ID INT IDENTITY(1,1) PRIMARY KEY, Price DECIMAL(8,2) DEFAULT(0.00) NOT NULL, Img NVARCHAR(50) DEFAULT() NOT NULL ) CREATE TABLE OrderDetail( ID INT IDENTITY(1,1) PRIMARY KEY, OrderID INT DEFAULT(0) NOT NULL, ProductID INT DEFAULT(0) NOT NULL, Price DECIMAL(8,2) DEFAULT(0.00) NOT NULL ) INSERT INTO Person(Name,Age,Sex) SELECT 张三,28,1 UNION ALL SELECT 李四,28,1 UNION ALL SELECT 王五,28,1 INSERT INTO [Order](PersonID,TotalPrice) SELECT 1,100.0 UNION ALL SELECT 1,111.0 UNION ALL SELECT 2,112.0 UNION ALL SELECT 3,98.0 UNION ALL SELECT 3,150.49 UNION ALL SELECT 3,58 INSERT INTO Product(Price,Img) SELECT 101.0,1.png UNION ALL SELECT 102.0,2.png UNION ALL SELECT 103.0,3.png UNION ALL SELECT 104.0,4.png UNION ALL SELECT 105.0,5.png INSERT INTO OrderDetail(OrderID,ProductID,Price) SELECT TOP 3 3,ID,Price FROM Product SELECT * FROM Person SELECT * FROM [Order] SELECT * FROM Product SELECT * FROM OrderDetail Person ID Name Age Sex ----------- -------------------- ----------- ----- 1 张三 28 1 2 李四 28 1 3 王五 28 1 (3 行受影响) [Order] ID PersonID TotalPrice ----------- ----------- --------------------------------------- 1 1 100 2 1 111 3 2 112 4 3 98 5 3 150 6 3 58 (6 行受影响) Product ID Price Img ----------- --------------------------------------- -------------------------------------------------- 1 101.00 1.png 2 102.00 2.png 3 103.00 3.png 4 104.00 4.png 5 105.00 5.png (5 行受影响) OrderDetail ID OrderID ProductID Price ----------- ----------- ----------- --------------------------------------- 1 1 1 101.00 2 1 2 102.00 3 1 3 103.00 4 1 4 104.00 5 1 5 105.00 6 2 1 101.00 7 2 2 102.00 8 2 3 103.00 9 3 1 101.00 10 3 2 102.00 11 3 3 103.00 (11 行受影响) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.
源码下载源码库IT资讯网IT技术网企商汇服务器租用益华科技亿华云香港云服务器益华科技极客码头IT资讯网亿华智慧云益强科技思维库益强IT技术网亿华云计算云智核益强科技码力社亿华云亿华智造技术快报编程之道科技前瞻益强数据堂益华IT技术论坛亿华科技码上建站汇智坊极客编程云站无忧智能时代亿华互联益强资讯优选亿华灵动运维纵横益华科技多维IT资讯益强编程堂益强前沿资讯创站工坊益强智未来
- Copyright © 2025 Powered by SQL Server数据库中FOR XML AUTO的使用详解续,技术快报 滇ICP备2023006006号-46sitemap