219 lines
3.8 KiB
Transact-SQL
219 lines
3.8 KiB
Transact-SQL
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
|