CREATE PROCEDURE [dbo].[up_save_keymap] @auth_id [uniqueidentifier], @key01 int, @key02 int, @key03 int, @key04 int, @key05 int, @key06 int, @key07 int, @key08 int, @key09 int, @key10 int, @key11 int, @key12 int, @key13 int, @key14 int, @key15 int, @key16 int, @key17 int, @key18 int, @key19 int, @key20 int, @key21 int, @key22 int, @key23 int, @key24 int, @key25 int, @key26 int, @key27 int, @key28 int, @key29 int, @key30 int, @key31 int, @key32 int, @key33 int, @key34 int, @key35 int, @key36 int, @key37 int, @key38 int, @key39 int, @key40 int, @key41 int, @key42 int, @key43 int, @key44 int, @key45 int, @key46 int, @key47 int, @key48 int, @key49 int, @key50 int, @key51 int, @key52 int, @key53 int, @key54 int, @key55 int, @key56 int, @key57 int, @key58 int, @key59 int, @key60 int, @key61 int, @key62 int, @key63 int, @key64 int, @key65 int, @key66 int, @key67 int, @key68 int, @key69 int, @key70 int, @key71 int, @key72 int, @key73 int, @key74 int, @key75 int, @key76 int, @key77 int, @key78 int, @key79 int, @key80 int, @key81 int, @key82 int, @key83 int, @key84 int, @key85 int, @key86 int, @key87 int, @key88 int, @key89 int, @key90 int, @key91 int, @key92 int, @key93 int, @key94 int, @key95 int, @key96 int, @key97 int, @key98 int, @key99 int as begin set nocount on update KeyMapTable Set [key01] = @key01 ,[key02] = @key02 ,[key03] = @key03 ,[key04] = @key04 ,[key05] = @key05 ,[key06] = @key06 ,[key07] = @key07 ,[key08] = @key08 ,[key09] = @key09 ,[key10] = @key10 ,[key11] = @key11 ,[key12] = @key12 ,[key13] = @key13 ,[key14] = @key14 ,[key15] = @key15 ,[key16] = @key16 ,[key17] = @key17 ,[key18] = @key18 ,[key19] = @key19 ,[key20] = @key20 ,[key21] = @key21 ,[key22] = @key22 ,[key23] = @key23 ,[key24] = @key24 ,[key25] = @key25 ,[key26] = @key26 ,[key27] = @key27 ,[key28] = @key28 ,[key29] = @key29 ,[key30] = @key30 ,[key31] = @key31 ,[key32] = @key32 ,[key33] = @key33 ,[key34] = @key34 ,[key35] = @key35 ,[key36] = @key36 ,[key37] = @key37 ,[key38] = @key38 ,[key39] = @key39 ,[key40] = @key40 ,[key41] = @key41 ,[key42] = @key42 ,[key43] = @key43 ,[key44] = @key44 ,[key45] = @key45 ,[key46] = @key46 ,[key47] = @key47 ,[key48] = @key48 ,[key49] = @key49 ,[key50] = @key50 ,[key51] = @key51 ,[key52] = @key52 ,[key53] = @key53 ,[key54] = @key54 ,[key55] = @key55 ,[key56] = @key56 ,[key57] = @key57 ,[key58] = @key58 ,[key59] = @key59 ,[key60] = @key60 ,[key61] = @key61 ,[key62] = @key62 ,[key63] = @key63 ,[key64] = @key64 ,[key65] = @key65 ,[key66] = @key66 ,[key67] = @key67 ,[key68] = @key68 ,[key69] = @key69 ,[key70] = @key70 ,[key71] = @key71 ,[key72] = @key72 ,[key73] = @key73 ,[key74] = @key74 ,[key75] = @key75 ,[key76] = @key76 ,[key77] = @key77 ,[key78] = @key78 ,[key79] = @key79 ,[key80] = @key80 ,[key81] = @key81 ,[key82] = @key82 ,[key83] = @key83 ,[key84] = @key84 ,[key85] = @key85 ,[key86] = @key86 ,[key87] = @key87 ,[key88] = @key88 ,[key89] = @key89 ,[key90] = @key90 ,[key91] = @key91 ,[key92] = @key92 ,[key93] = @key93 ,[key94] = @key94 ,[key95] = @key95 ,[key96] = @key96 ,[key97] = @key97 ,[key98] = @key98 ,[key99] = @key99 from KeyMapTable where AuthID = @auth_id end