[FONT="Tahoma"][COLOR="LemonChiffon"][SIZE="2"]
Alles anzeigen
Joa, so sieht sie aus :0[/SIZE][/COLOR][/FONT]
TwiLight;150574 schrieb:
Das bedeutet eigentlich, dass in deiner Prozedur der Parameter nicht festgelegt wurde, oder einen anderen Namen hat.
So sollte es aussehen.Alles anzeigenQuellcode
- CREATE PROC [dbo].[LOG_USER_CNT_STR]
- @iserverindex CHAR(2),
- @im_channel int,
- @im_01 INT = 0,
- @im_02 INT = 0,
- @im_03 INT = 0,
- @im_04 INT = 0,
- @im_05 INT = 0,
- @im_06 INT = 0,
- @im_07 INT = 0,
- @im_08 INT = 0,
- @im_09 INT = 0,
- @im_10 INT = 0,
- @im_11 INT = 0,
- @im_12 INT = 0,
- @im_13 INT = 0,
- @im_14 INT = 0,
- @im_15 INT = 0,
- @im_16 INT = 0,
- @im_17 INT = 0,
- @im_18 INT = 0,
- @im_19 INT = 0,
- @im_20 INT = 0
- /***********************************************************************************
- ***********************************************************************************
- ***********************************************************************************
- ***********************************************************************************
- LOG_USER_CNT_STR 스토어드
- 작성자 : 최석준
- 작성일 : 2003.12.19
- ***********************************************************************************
- ***********************************************************************************
- ***********************************************************************************
- ***********************************************************************************/
- AS
- set nocount on
- DECLARE @os_date CHAR(14),@onumber INT
- SELECT @os_date = CONVERT(CHAR(8),GETDATE(),112)
- + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
- + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
- + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,GETDATE())),2)
- SELECT @onumber = @im_01 + @im_02 + @im_03 + @im_04 + @im_05
- + @im_06 + @im_07 + @im_08 + @im_09 + @im_10
- + @im_11 + @im_12 + @im_13 + @im_14 + @im_15
- + @im_16 + @im_17 + @im_18 + @im_19 + @im_20
- INSERT LOG_USER_CNT_TBL
- (
- serverindex,
- s_date,
- m_channel,
- number,
- m_01,
- m_02,
- m_03,
- m_04,
- m_05,
- m_06,
- m_07,
- m_08,
- m_09,
- m_10,
- m_11,
- m_12,
- m_13,
- m_14,
- m_15,
- m_16,
- m_17,
- m_18,
- m_19,
- m_20
- )
- VALUES
- (
- @iserverindex,
- @os_date,
- @im_channel,
- @onumber,
- @im_01,
- @im_02,
- @im_03,
- @im_04,
- @im_05,
- @im_06,
- @im_07,
- @im_08,
- @im_09,
- @im_10,
- @im_11,
- @im_12,
- @im_13,
- @im_14,
- @im_15,
- @im_16,
- @im_17,
- @im_18,
- @im_19,
- @im_20
- )
- RETURN
- set nocount off
Quellcode
- USE [LOGGING_01_DBF]
- GO
- /****** Objekt: StoredProcedure [dbo].[LOG_USER_CNT_STR] Skriptdatum: 06/28/2010 04:14:53 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER PROC [dbo].[LOG_USER_CNT_STR]
- @iserverindex CHAR(2),
- @im_channel int,
- @im_01 INT = 0,
- @im_02 INT = 0,
- @im_03 INT = 0,
- @im_04 INT = 0,
- @im_05 INT = 0,
- @im_06 INT = 0,
- @im_07 INT = 0,
- @im_08 INT = 0,
- @im_09 INT = 0,
- @im_10 INT = 0,
- @im_11 INT = 0,
- @im_12 INT = 0,
- @im_13 INT = 0,
- @im_14 INT = 0,
- @im_15 INT = 0,
- @im_16 INT = 0,
- @im_17 INT = 0,
- @im_18 INT = 0,
- @im_19 INT = 0,
- @im_20 INT = 0
- /***********************************************************************************
- ***********************************************************************************
- ***********************************************************************************
- ***********************************************************************************
- LOG_USER_CNT_STR 스토어드
- 작성자 : 최석준
- 작성일 : 2003.12.19
- ***********************************************************************************
- ***********************************************************************************
- ***********************************************************************************
- ***********************************************************************************/
- AS
- set nocount on
- DECLARE @os_date CHAR(14),@onumber INT
- SELECT @os_date = CONVERT(CHAR(8),GETDATE(),112)
- + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
- + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
- + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,GETDATE())),2)
- SELECT @onumber = @im_01 + @im_02 + @im_03 + @im_04 + @im_05
- + @im_06 + @im_07 + @im_08 + @im_09 + @im_10
- + @im_11 + @im_12 + @im_13 + @im_14 + @im_15
- + @im_16 + @im_17 + @im_18 + @im_19 + @im_20
- INSERT LOG_USER_CNT_TBL
- (
- serverindex,
- s_date,
- number,
- m_channel,
- m_01,
- m_02,
- m_03,
- m_04,
- m_05,
- m_06,
- m_07,
- m_08,
- m_09,
- m_10,
- m_11,
- m_12,
- m_13,
- m_14,
- m_15,
- m_16,
- m_17,
- m_18,
- m_19,
- m_20
- )
- VALUES
- (
- @iserverindex,
- @os_date,
- @onumber,
- @im_channel,
- @im_01,
- @im_02,
- @im_03,
- @im_04,
- @im_05,
- @im_06,
- @im_07,
- @im_08,
- @im_09,
- @im_10,
- @im_11,
- @im_12,
- @im_13,
- @im_14,
- @im_15,
- @im_16,
- @im_17,
- @im_18,
- @im_19,
- @im_20
- )
- RETURN
- set nocount off
Joa, so sieht sie aus :0[/SIZE][/COLOR][/FONT]