62,074
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE t_order(f_id INT IDENTITY(1, 1) PRIMARY KEY ,f_name VARCHAR(1) DEFAULT NULL )
INSERT dbo.t_order( f_name )
SELECT NULL
UNION ALL
SELECT NULL--随便插两条数据
CREATE TABLE t_numberList (f_id INT IDENTITY(1,1) PRIMARY KEY,f_orderID INT,f_number CHAR(11))
CREATE TABLE #tb(f_number CHAR(11))--创建临时表,先把数据导到这里
BULK Insert #tb from 'c:\number.txt' WITH (FIELDTERMINATOR= ',',ROWTERMINATOR= '\n');
INSERT dbo.t_numberList( f_orderID, f_number )
SELECT (SELECT MAX(f_id)+1 FROM dbo.t_order) AS f_orderID,f_number FROM #tb;
SELECT * FROM dbo.t_numberList
DROP TABLE #tb,dbo.t_order,dbo.t_numberList
/*
f_id f_orderID f_number
----------- ----------- -----------
1 3 13511111111
2 3 13522222222
3 3 13533333333
4 3 13544444444
(4 行受影响)
*/