




相关代码:
CREATE TABLE [dbo].[rq](
[rq] [datetime] NULL,
[rq1] [varchar](50) NULL
) ON [PRIMARY]
update [baogs_fz].[dbo].[rq] set rq1=CONVERT(varchar(100),rq, 23);
SELECT TOP 1000 *
FROM [baogs_fz].[dbo].[rq] ;
update [baogs_fz].[dbo].[rq] set rq=rq1 ;