1.数据库批量插入

INSERT INTO [APPDB_YJ].[dbo].[tb_ShowLiuliangzt]
           ([vc_Title]
           ,[vc_content]
           ,[vc_Url]
           ,[i_Order]
           ,[i_Llztid]
           ,[i_Uid]
           ,[dt_Datatime]
           ,[dt_Stratime]
           ,[dt_Endtime]
           ,[i_Tid]
           ,[vc_Img])
     select
           '赤海渔具招商网'
           ,''
           ,'http://www.9555.tv'
           ,'9999'
           ,i_id
           ,i_uid
           ,dt_datetime
           ,dt_datetime
           ,dt_datetime
           ,0
           ,'~/UpLoadFile/First//Img/zhaozhu.jpg'
           from tb_liuliangzt where i_pid=0
GO