建立同义词
CREATE SYNONYM [dbo].[table1] FOR [HIS].[dbo].[ZGDMK] CREATE SYNONYM [dbo].[table2] FOR [HIS].[dbo].[BRDMK]
insert into select第二张表必须存在
INSERT INTO Table2(ID,INPATIENT) select top 10 '000',JLXH from Table1 --table2这张表必须存在
建立同义词
CREATE SYNONYM [dbo].[table1] FOR [HIS].[dbo].[ZGDMK] CREATE SYNONYM [dbo].[table2] FOR [HIS].[dbo].[BRDMK]
insert into select第二张表必须存在
INSERT INTO Table2(ID,INPATIENT) select top 10 '000',JLXH from Table1 --table2这张表必须存在
-------------------------------------------------
保持专注,只做一件事,做好这件事!@
-------------------------------------------------