SQL INSERT INTO 语句

批量插入

INSERT INTO dbo.doraInfo
  (
	, LinkID
	, add_time
	, add_userID
	, add_userName
  )
  
SELECT
     LEFT(NEWID(), 18) AS LinkID
	, convert(varchar,getdate(),23) AS add_time
	, 999 AS  add_userID
	,  '' AS add_userName
FROM HsptNetDB.dbo.YaoMing

Update

UPDATE a  
   SET a.字段 = b.字段 
FROM tab_a  a, tab_b b   
WHERE a.id = b.id

查询当前数据库的表，在另一个数据库中的表     引用方式： 数据库名.dbo.表名

SELECT * FROM Test
WHERE KMNo IN (SELECT KMNo FROM DBName.dbo.tabName)

 

Update tbMain
   SET dtCount = tbDetail.cnt_tdID
FROM tabMain tbMain
join 
   (SELECT mnID, Count(dtID) as cnt_dtID FROM tabDetail Group by mnID) 
 tab_Detail on tab_Detail.mnID = tbMain.ID
WHERE tabMain.ID = 58

insert into select 和select into from 的区别

 

1. 插入一行,  要求表  scorebak 必须存在 　　

insert into scorebak select * from socre where neza='neza'

 

 2. 也是插入一行,  要求表 scorebak  不存在

 

select * into scorebak from score where neza='neza'