34,838
社区成员




INSERT INTO TABLEA(AID, BID, COLUMNA, SSQS, SSQZ)
SELECT 1, 'XXID', '010000', CAST(39415 as datetime), CAST(39445 as datetime) FROM TABLEB
INSERT INTO TABLEA(AID, BID, COLUMNA, SSQS, SSQZ) SELECT 1, 'XXID', '010000', CAST(39415 as datetime), CAST(39445 as datetime) FROM TABLEB
create table #TABLEA
(
AID int,
BID int,
COLUMNA varchar(20),
SSQS datetime,
SSQZ datetime
)
INSERT INTO #TABLEA("AID", "BID", "COLUMNA", "SSQS", "SSQZ")
SELECT 1, 3, '010000', CAST(39415 as datetime), CAST(39445 as datetime)
go
INSERT INTO #TABLEA("AID", "BID", "COLUMNA", "SSQS", "SSQZ")
SELECT 1, 1, '010000', CONVERT(datetime, '2007-12-01T00:00:00', 126), CONVERT(datetime, '2007-12-31T00:00:00', 126)
go
INSERT INTO #TABLEA("AID", "BID", "COLUMNA", "SSQS", "SSQZ")
SELECT 1, 2, '010000', CONVERT(datetime, '20071201', 112), CONVERT(datetime, '20071231', 112)
go
select * from #TABLEA
drop table #TABLEA
--------------------------
(所影响的行数为 1 行)
(所影响的行数为 1 行)
(所影响的行数为 1 行)
(所影响的行数为 3 行)
AID BID COLUMNA SSQS SSQZ
1 3 010000 2007-12-01 00:00:00.000 2007-12-31 00:00:00.000
1 1 010000 2007-12-01 00:00:00.000 2007-12-31 00:00:00.000
1 2 010000 2007-12-01 00:00:00.000 2007-12-31 00:00:00.000
select dt1=CAST(39415 as datetime)
,dt2=CONVERT(datetime, '20071201', 112)
,dt3=CONVERT(datetime, '2007-12-01T00:00:00', 126)
/*
dt1 dt2 dt3
----------------------- ----------------------- -----------------------
2007-12-01 00:00:00.000 2007-12-01 00:00:00.000 2007-12-01 00:00:00.000
(1 row(s) affected)
*/
select CAST(39415 as datetime), CAST(39445 as datetime)
/*
----------------------- -----------------------
2007-12-01 00:00:00.000 2007-12-31 00:00:00.000
(1 row(s) affected)
*/