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.
20 lines
372 B
20 lines
372 B
SELECT * FROM dbo.Dict_FeeItem
|
|
SELECT top 200 * FROM peis.dbo.FeeItem
|
|
|
|
--
|
|
TRUNCATE TABLE Dict_FeeItem
|
|
|
|
SET IDENTITY_INSERT dbo.Dict_FeeItem ON
|
|
|
|
INSERT INTO Dict_FeeItem(ID, FeeItemCode, SpellCode, Unit)
|
|
SELECT
|
|
A.Id,
|
|
A.HISCheckCode AS FeeItemCode,
|
|
A.PYM AS SpellCode,
|
|
A.UnitName AS Unit
|
|
FROM
|
|
peis.dbo.FeeItem A
|
|
|
|
SET IDENTITY_INSERT dbo.Dict_FeeItem OFF
|
|
|
|
|
|
|