[SQL] TA_CARDPACK_ITEM & TA_CARDPACK_ACC Tables

Results 1 to 6 of 6
  1. 24-02-11 #1
    Acardia
    Valued Member Acardia is offline
    MemberRank
    Jan 2011 Join Date
    129Posts

    [SQL] TA_CARDPACK_ITEM & TA_CARDPACK_ACC Tables

    Heres All The Cards Minus The Consumable Ones

    Spoiler:
    USE [Pangya_S4_TH]
    GO
    /****** Object: Table [dbo].[TA_CARDPACK_ITEM] Script Date: 02/24/2011 18:49:27 ******/
    SET IDENTITY_INSERT [dbo].[TA_CARDPACK_ITEM] ON
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374784, 1, 1, 3, CAST(0.100 AS Numeric(8, 3)), N'Y', 3, CAST(0x9E9303BF AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374785, 1, 1, 6, CAST(0.099 AS Numeric(8, 3)), N'Y', 6, CAST(0x9E9303C1 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374788, 1, 1, 7, CAST(0.100 AS Numeric(8, 3)), N'Y', 7, CAST(0x9E9303C3 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374789, 1, 1, 8, CAST(0.099 AS Numeric(8, 3)), N'Y', 8, CAST(0x9E9303C5 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374790, 1, 1, 9, CAST(0.098 AS Numeric(8, 3)), N'Y', 9, CAST(0x9E9303DE AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374792, 1, 1, 10, CAST(0.100 AS Numeric(8, 3)), N'Y', 10, CAST(0x9E9303E1 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374796, 1, 1, 11, CAST(0.100 AS Numeric(8, 3)), N'Y', 11, CAST(0x9E9303E3 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374797, 1, 1, 12, CAST(0.099 AS Numeric(8, 3)), N'Y', 12, CAST(0x9E9303E4 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374800, 1, 1, 13, CAST(0.100 AS Numeric(8, 3)), N'Y', 13, CAST(0x9E9303E8 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374801, 1, 1, 14, CAST(0.099 AS Numeric(8, 3)), N'Y', 14, CAST(0x9E9303E9 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374802, 1, 1, 15, CAST(0.098 AS Numeric(8, 3)), N'Y', 15, CAST(0x9E9303EC AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374804, 1, 1, 16, CAST(0.100 AS Numeric(8, 3)), N'Y', 16, CAST(0x9E9303F0 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374805, 1, 1, 17, CAST(0.099 AS Numeric(8, 3)), N'Y', 17, CAST(0x9E9303F4 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374806, 1, 1, 18, CAST(0.098 AS Numeric(8, 3)), N'Y', 18, CAST(0x9E9303F5 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374808, 1, 1, 19, CAST(0.100 AS Numeric(8, 3)), N'Y', 19, CAST(0x9E9303FF AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374809, 1, 1, 20, CAST(0.099 AS Numeric(8, 3)), N'Y', 20, CAST(0x9E930409 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374810, 1, 1, 21, CAST(0.098 AS Numeric(8, 3)), N'Y', 21, CAST(0x9E930409 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374812, 1, 1, 22, CAST(0.100 AS Numeric(8, 3)), N'Y', 22, CAST(0x9E930411 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374813, 1, 1, 23, CAST(0.099 AS Numeric(8, 3)), N'Y', 23, CAST(0x9E930413 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569088, 1, 1, 24, CAST(0.100 AS Numeric(8, 3)), N'Y', 24, CAST(0x9E930422 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569089, 1, 1, 25, CAST(0.099 AS Numeric(8, 3)), N'Y', 25, CAST(0x9E930428 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569092, 1, 1, 26, CAST(0.100 AS Numeric(8, 3)), N'Y', 26, CAST(0x9E93042A AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569096, 1, 1, 27, CAST(0.099 AS Numeric(8, 3)), N'Y', 27, CAST(0x9E93043F AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569104, 1, 1, 28, CAST(0.100 AS Numeric(8, 3)), N'Y', 28, CAST(0x9E930442 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569105, 1, 1, 29, CAST(0.099 AS Numeric(8, 3)), N'Y', 29, CAST(0x9E930443 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569106, 1, 1, 30, CAST(0.098 AS Numeric(8, 3)), N'Y', 30, CAST(0x9E930444 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569108, 1, 1, 31, CAST(0.100 AS Numeric(8, 3)), N'Y', 31, CAST(0x9E930446 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569109, 1, 1, 32, CAST(0.099 AS Numeric(8, 3)), N'Y', 32, CAST(0x9E930448 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569112, 1, 1, 33, CAST(0.098 AS Numeric(8, 3)), N'Y', 33, CAST(0x9E930449 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569113, 1, 1, 34, CAST(0.097 AS Numeric(8, 3)), N'Y', 34, CAST(0x9E930449 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374787, 1, 1, 35, CAST(0.098 AS Numeric(8, 3)), N'Y', 35, CAST(0x9E93044E AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374791, 1, 1, 36, CAST(0.097 AS Numeric(8, 3)), N'Y', 36, CAST(0x9E93044F AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374793, 1, 1, 39, CAST(0.099 AS Numeric(8, 3)), N'Y', 39, CAST(0x9E930450 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374794, 1, 1, 40, CAST(0.098 AS Numeric(8, 3)), N'Y', 40, CAST(0x9E930452 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374814, 1, 1, 41, CAST(0.098 AS Numeric(8, 3)), N'Y', 41, CAST(0x9E930454 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374816, 1, 1, 42, CAST(0.100 AS Numeric(8, 3)), N'Y', 42, CAST(0x9E930467 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374817, 1, 1, 43, CAST(0.099 AS Numeric(8, 3)), N'Y', 43, CAST(0x9E930468 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374818, 1, 1, 44, CAST(0.100 AS Numeric(8, 3)), N'Y', 44, CAST(0x9E93046A AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374819, 1, 1, 45, CAST(0.099 AS Numeric(8, 3)), N'Y', 45, CAST(0x9E93046D AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374820, 1, 1, 46, CAST(0.100 AS Numeric(8, 3)), N'Y', 46, CAST(0x9E930470 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374821, 1, 1, 47, CAST(0.100 AS Numeric(8, 3)), N'Y', 47, CAST(0x9E930470 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374822, 1, 1, 48, CAST(0.100 AS Numeric(8, 3)), N'Y', 48, CAST(0x9E930471 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374823, 1, 1, 49, CAST(0.100 AS Numeric(8, 3)), N'Y', 49, CAST(0x9E930473 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569090, 1, 1, 51, CAST(0.098 AS Numeric(8, 3)), N'Y', 51, CAST(0x9E93047D AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569098, 1, 1, 52, CAST(0.097 AS Numeric(8, 3)), N'Y', 52, CAST(0x9E93047E AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569099, 1, 1, 53, CAST(0.100 AS Numeric(8, 3)), N'Y', 53, CAST(0x9E930480 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569100, 1, 1, 54, CAST(0.100 AS Numeric(8, 3)), N'Y', 54, CAST(0x9E930481 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569101, 1, 1, 55, CAST(0.099 AS Numeric(8, 3)), N'Y', 55, CAST(0x9E930482 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569110, 1, 1, 56, CAST(0.098 AS Numeric(8, 3)), N'Y', 56, CAST(0x9E930483 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569115, 1, 1, 57, CAST(0.100 AS Numeric(8, 3)), N'Y', 57, CAST(0x9E930484 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569116, 1, 1, 58, CAST(0.100 AS Numeric(8, 3)), N'Y', 58, CAST(0x9E930486 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569117, 1, 1, 59, CAST(0.100 AS Numeric(8, 3)), N'Y', 59, CAST(0x9E930488 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569118, 1, 1, 60, CAST(0.099 AS Numeric(8, 3)), N'Y', 60, CAST(0x9E930489 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569119, 1, 1, 61, CAST(0.100 AS Numeric(8, 3)), N'Y', 61, CAST(0x9E930489 AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569120, 1, 1, 62, CAST(0.099 AS Numeric(8, 3)), N'Y', 62, CAST(0x9E93048A AS SmallDateTime), 3)
    INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569121, 1, 1, 63, CAST(0.099 AS Numeric(8, 3)), N'Y', 63, CAST(0x9E93048B AS SmallDateTime), 3)
    SET IDENTITY_INSERT [dbo].[TA_CARDPACK_ITEM] OFF


    Spoiler:
    USE [Pangya_S4_TH]
    GO
    /****** Object: Table [dbo].[TA_CARDPACK_ACC] Script Date: 02/24/2011 18:55:15 ******/
    SET IDENTITY_INSERT [dbo].[TA_CARDPACK_ACC] ON
    INSERT [dbo].[TA_CARDPACK_ACC] ([PACK_TYPEID], [SEQ], [PACK_NM_KR], [PACK_NM_EN], [OUTQTY], [USE_YN], [IN_DATE]) VALUES (2092957696, 1, N'2092957696', NULL, 3, N'Y', CAST(0x9E930396 AS SmallDateTime))
    INSERT [dbo].[TA_CARDPACK_ACC] ([PACK_TYPEID], [SEQ], [PACK_NM_KR], [PACK_NM_EN], [OUTQTY], [USE_YN], [IN_DATE]) VALUES (2092957697, 5, N'2092957697', NULL, 1, N'Y', CAST(0x9E9303AA AS SmallDateTime))
    INSERT [dbo].[TA_CARDPACK_ACC] ([PACK_TYPEID], [SEQ], [PACK_NM_KR], [PACK_NM_EN], [OUTQTY], [USE_YN], [IN_DATE]) VALUES (2092957698, 4, N'2092957698', NULL, 1, N'Y', CAST(0x9E93039D AS SmallDateTime))
    INSERT [dbo].[TA_CARDPACK_ACC] ([PACK_TYPEID], [SEQ], [PACK_NM_KR], [PACK_NM_EN], [OUTQTY], [USE_YN], [IN_DATE]) VALUES (2092957699, 3, N'2092957699', NULL, 1, N'Y', CAST(0x9E93039D AS SmallDateTime))
    INSERT [dbo].[TA_CARDPACK_ACC] ([PACK_TYPEID], [SEQ], [PACK_NM_KR], [PACK_NM_EN], [OUTQTY], [USE_YN], [IN_DATE]) VALUES (2092957700, 2, N'2092957700', NULL, 3, N'Y', CAST(0x9E930397 AS SmallDateTime))
    SET IDENTITY_INSERT [dbo].[TA_CARDPACK_ACC] OFF
    Last edited by Acardia; 25-02-11 at 12:55 AM. Reason: fix
  2. Check out our sponsor
    [SQL] TA_CARDPACK_ITEM & TA_CARDPACK_ACC Tables
  3. 24-02-11 #2
    o800920
    Member o800920 is offline
    MemberRank
    Dec 2008 Join Date
    51Posts

    Re: TA_CARDPACK_ITEM Tables

    Good thanks very much
  4. 24-02-11 #3
    Tsukasa
    Deny everything. Tsukasa is offline
    MemberRank
    Jun 2005 Join Date
    Net SlumLocation
    558Posts

    Re: TA_CARDPACK_ITEM Tables

    Generate a query from this. Posting values like this is practically useless.
  5. 24-02-11 #4
    Acardia
    Valued Member Acardia is offline
    MemberRank
    Jan 2011 Join Date
    129Posts

    Re: TA_CARDPACK_ITEM Tables

    Quote Originally Posted by Tsukasa View Post
    Generate a query from this. Posting values like this is practically useless.
    i looked all over for how to Generate a query but couldnt find anything
  6. 24-02-11 #5
    Tsukasa
    Deny everything. Tsukasa is offline
    MemberRank
    Jun 2005 Join Date
    Net SlumLocation
    558Posts

    Re: TA_CARDPACK_ITEM Tables

    If you fancy a Management Studio solution, this works fine for INSERTs (see The Matt's answer), although it doesn't generate optional UPDATE statements (so it's kind of bleh). Navicat can do the same but also doesn't produce UPDATE statements (so it's kind of bleh too). Feel free to check the other answers given on StackOverflow to see which one suits you best.

    Ideally you'd do the handiwork and edit the resulting queries to optionally update existing rows (if present). It's more work - but this is the Releases forum (not DIY), so we should strive for the best quality possible. If you feel that's too much work, at least include conditional DELETE statements to make sure existing rows get dropped before being inserted anew. :)
    Last edited by Tsukasa; 24-02-11 at 11:34 PM.
  7. 25-02-11 #6
    Acardia
    Valued Member Acardia is offline
    MemberRank
    Jan 2011 Join Date
    129Posts

    Re: TA_CARDPACK_ITEM Tables

    Quote Originally Posted by Tsukasa View Post
    If you fancy a Management Studio solution, this works fine for INSERTs (see The Matt's answer), although it doesn't generate optional UPDATE statements (so it's kind of bleh). Navicat can do the same but also doesn't produce UPDATE statements (so it's kind of bleh too). Feel free to check the other answers given on StackOverflow to see which one suits you best.

    Ideally you'd do the handiwork and edit the resulting queries to optionally update existing rows (if present). It's more work - but this is the Releases forum (not DIY), so we should strive for the best quality possible. If you feel that's too much work, at least include conditional DELETE statements to make sure existing rows get dropped before being inserted anew. :)
    Thanks Tsukasa Im Updating Now


« Previous Thread | Next Thread »

Advertisement