You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 lines
543 B
25 lines
543 B
11 months ago
|
SELECT TOP 20 * FROM dbo.Dict_Conclusion
|
||
|
|
SELECT TOP 20 * FROM PEIS.DBO.Conclusion
|
||
|
|
|
||
|
|
TRUNCATE TABLE Dict_Conclusion
|
||
|
|
SET IDENTITY_INSERT dbo.Dict_Conclusion ON
|
||
|
|
|
||
|
|
INSERT INTO Dict_Conclusion
|
||
|
|
(ID, ConclusionName, SpellCode, Description, Instructions, Suggestion, Advice, DietaryGuidance, Sex )
|
||
|
|
|
||
|
|
SELECT
|
||
|
|
Id,
|
||
|
|
NAME AS ConclusionName,
|
||
|
|
PYM AS SpellCode,
|
||
|
|
Description,
|
||
|
|
Instructions,
|
||
|
|
Suggestion ,
|
||
|
|
Advice,
|
||
|
|
DietaryGuidance,
|
||
|
|
DiseasesGender AS SEX
|
||
|
|
FROM
|
||
|
|
PEIS.DBO.Conclusion
|
||
|
|
WHERE
|
||
|
|
StopOperDate IS NULL
|
||
|
|
|
||
|
|
SET IDENTITY_INSERT dbo.Dict_Conclusion OFF
|