<pre><code>
if exists(select * from sys.objects where name='Proc_Loction_GetPageList')
begin
drop proc Proc_Loction_GetPageList
end
go
create proc Proc_Loction_GetPageList(@currentPage int, @sizePage int,@total int out)
as
begin
set @total=(select count(Id) from [dbo].[Procut_TaxSpecies])--得到数据总条数
select top (@sizePage) * from (select row_number() over(order by Id) as rowNumber,* from [dbo].[Procut_TaxSpecies])
as t where t.rowNumber>@sizePage*(@currentPage-1);
end
--执行存储过程
select * from
[dbo].[Procut_Taxation]
select * from [dbo].[Procut_TaxSpecies]
declare @total int
exec Proc_Loction_GetPageList 3,3,@total output
print @total
--在vs中执行这个存储过程，并获取存储过程的输出参数
--[csharp] view plain copy 在CODE上查看代码片派生到我的代码片
public class HomeController : Controller
{
public ActionResult Index()
{
string conStr = ConfigurationManager.ConnectionStrings["salesConStr"].ConnectionString;
SqlParameter totalPara = new SqlParameter("@total", SqlDbType.Int); //用于接收存储过程的输出参数（获取数据的总条数）
totalPara.Direction = ParameterDirection.Output; //声明这个参数是一个输出参数
using (SqlConnection conn = new SqlConnection(conStr))
{
string sqlStr = "Proc_Loction_GetPageList"; //Proc_Loction_GetPageList是存储过程名称
SqlCommand cmd = new SqlCommand(sqlStr, conn);
cmd.CommandType = CommandType.StoredProcedure; //指明我这里要执行的是存储过程
SqlParameter[] para=new SqlParameter[]
{
new SqlParameter("@currentPage", 3),//当前页
new SqlParameter("@sizePage", 10) //页大小
};
cmd.Parameters.AddRange(para); //将参数加入到cmd命令中
cmd.Parameters.Add(totalPara);
conn.Open(); //打开与数据库的连接
SqlDataReader reader = cmd.ExecuteReader();
List<location> list = new List<location>();
while (reader.Read()) //逐行读取数据
{
location obj = new location()
{
locId = Convert.ToInt32(reader["locId"]),
locName = reader["locName"].ToString(),
parentId = Convert.ToInt32(reader["parentId"]),
};
list.Add(obj);
}
}
var total = totalPara.Value; //获取输出参数（获取数据的总条数）
return View();
}
}
http://blog.csdn.net/fanbin168/article/details/41366291
</pre></code>
http://blog.csdn.net/fanbin168/article/details/42795691
Here is an example of AppleScript: tell application "Foo" beep end tell
