存储过程
USE [Lean]
GO
/****** Object: StoredProcedure [dbo].[AddToDayResult] Script Date: 10/11/2011 13:16:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[AddToDayResult]
@ICCode char(10),
@AtdDate char(8),
@TimeS int,
@TimeE int,
@TimeO int,
@Time1 int,
@Time2 int,
@MachineCode char(1)
as
BEGIN
select a.ICCode,
(select top 1 Date from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode) as 'AtdDate',
(select top 1 Time from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode and Time between 745 and 815) as 'TimeS',
(select top 1 Time from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode and Time between 1710 and 1725) as 'TimeE',
(select top 1 Time from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode and Time between 1915 and 1925) as 'TimeO',
(select top 1 Time from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode and Time between 815 and 1210) as 'Time1',
(select top 1 Time from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode and Time between 1300 and 1710) as 'Time2',
(select top 1 MachineCode from [Lean].[dbo].[Atd_DataReceive] where ICCode = a.ICCode) as 'MachineCode'
from (select ICCode from [Lean].[dbo].[Atd_DataReceive] group by ICCode) as a
END
我想调用上面的存储过程 把a放入结果集 然后存入新的数据表New 或者是直接存入New,没接触过存储过程,请问各位大神应该怎么写啊,新手急急急,这问题困扰我好几天了
USE [Lean]
GO
/****** Object: StoredProcedure [dbo].[AddToDayResult] Script Date: 10/11/2011 13:16:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[AddToDayResult]
@ICCode char(10),
@AtdDate char(8),
@TimeS int,
@TimeE int,
@TimeO int,
@Time1 int,
@Time2 int,
@MachineCode char(1)
as
BEGIN
select a.ICCode,
(select top 1 Date from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode) as 'AtdDate',
(select top 1 Time from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode and Time between 745 and 815) as 'TimeS',
(select top 1 Time from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode and Time between 1710 and 1725) as 'TimeE',
(select top 1 Time from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode and Time between 1915 and 1925) as 'TimeO',
(select top 1 Time from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode and Time between 815 and 1210) as 'Time1',
(select top 1 Time from [Lean].[dbo].[Atd_DataReceive] where ICCode=a.ICCode and Time between 1300 and 1710) as 'Time2',
(select top 1 MachineCode from [Lean].[dbo].[Atd_DataReceive] where ICCode = a.ICCode) as 'MachineCode'
from (select ICCode from [Lean].[dbo].[Atd_DataReceive] group by ICCode) as a
END
我想调用上面的存储过程 把a放入结果集 然后存入新的数据表New 或者是直接存入New,没接触过存储过程,请问各位大神应该怎么写啊,新手急急急,这问题困扰我好几天了
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
cmd.CommandText = "存储过程名称"; cmd.Parameters.Add("@file ", SqlDbType.VarChar).Value = "d:\\test.mp3";
cmd.Parameters.Add("@size", SqlDbType.Int).Value = 256; cn.Open();
cmd.ExecuteNonQuery();
cn.Close();你只要会模仿,就能正确调用你的存储过程了