原来的代码是这样的,现在要写成存储过程,该怎样写呢,本人对存储过程不了解: string sql = "SELECT a.ID, a.Name,b.class,b.date from [Class] a left join [Student] b on a.classID =b.classID";
DataSet ds = SqlHelper.ExecuteAdapter(SqlHelper.Conn, CommandType.Text, sql, null);
DataSet ds = SqlHelper.ExecuteAdapter(SqlHelper.Conn, CommandType.Text, sql, null);
AS
SELECT a.ID, a.Name,b.class,b.date
from [Class] a left join [Student] b on a.classID =b.classID
AS
BEGIN
SELECT a.ID, a.Name,b.class,b.date
from [Class] a left join [Student] b
on a.classID =b.classID
END
as
SELECT a.ID, a.Name,b.class,b.date from [Class] a left join [Student] b on a.classID =b.classID
GO
--调用
exec up_select
CREATE PROC Test
AS
BEGIN
SELECT a.ID, a.Name,b.class,b.date
from [Class] a left join [Student] b
on a.classID =b.classID
END
string sql = "exec Test";
DataSet ds = SqlHelper.ExecuteAdapter(SqlHelper.Conn, CommandType.Text, sql, null);
AS
BEGIN
SELECT a.ID, a.Name,b.class,b.date
from [Class] a left join [Student] b
on a.classID =b.classID
END
.net
string sql = "exec Test";
DataSet ds = SqlHelper.ExecuteAdapter(SqlHelper.Conn, CommandType.Text, sql, null);