增
CREATE PROCEDURE [dbo].[Add_Admin]
(
@UserName nvarchar(50),
@Password nvarchar(50),
@LastLoginIP nvarchar(50),
@LastLoginTime Datetime
)
AS
INSERT INTO
Admin
(
UserName,
Password,
LastLoginIP,
LastLoginTime
)
Values
(
@UserName,
@Password,
@LastLoginIP,
@LastLoginTime
)
RETURN @@IdentityGO删
CREATE PROCEDURE [dbo].[Delete_Admin]
(
@ID int
)
AS
DELETE Admin WHERE ID=@IDGO改
CREATE PROCEDURE [dbo].[Update_Admin]
(
@ID int,
@UserName nvarchar(50),
@Password nvarchar(50),
@LastLoginIP nvarchar(50),
@LastLoginTime Datetime
)
AS
UPDATE
Admin
SET
UserName =@UserName ,
Password=@Password,
LastLoginIP=@LastLoginIP,
LastLoginTime=@LastLoginTime
WHERE
ID=@IDGO查
CREATE procedure Get_Product
(@startIndex int,
@endIndex int,
@docount bit)
as
set nocount on
if(@docount=1)
select count(*) AS Counts from Product
else
begin
declare @indextable table(id int identity(1,1),nid int)
set rowcount @endIndex
insert into @indextable(nid) select ID from Product order by ID desc
select * from Product O,@indextable t where O.ID=t.nid
and t.id between @startIndex and @endIndex order by t.id
end
set nocount offGO
CREATE PROCEDURE [dbo].[Add_Admin]
(
@UserName nvarchar(50),
@Password nvarchar(50),
@LastLoginIP nvarchar(50),
@LastLoginTime Datetime
)
AS
INSERT INTO
Admin
(
UserName,
Password,
LastLoginIP,
LastLoginTime
)
Values
(
@UserName,
@Password,
@LastLoginIP,
@LastLoginTime
)
RETURN @@IdentityGO删
CREATE PROCEDURE [dbo].[Delete_Admin]
(
@ID int
)
AS
DELETE Admin WHERE ID=@IDGO改
CREATE PROCEDURE [dbo].[Update_Admin]
(
@ID int,
@UserName nvarchar(50),
@Password nvarchar(50),
@LastLoginIP nvarchar(50),
@LastLoginTime Datetime
)
AS
UPDATE
Admin
SET
UserName =@UserName ,
Password=@Password,
LastLoginIP=@LastLoginIP,
LastLoginTime=@LastLoginTime
WHERE
ID=@IDGO查
CREATE procedure Get_Product
(@startIndex int,
@endIndex int,
@docount bit)
as
set nocount on
if(@docount=1)
select count(*) AS Counts from Product
else
begin
declare @indextable table(id int identity(1,1),nid int)
set rowcount @endIndex
insert into @indextable(nid) select ID from Product order by ID desc
select * from Product O,@indextable t where O.ID=t.nid
and t.id between @startIndex and @endIndex order by t.id
end
set nocount offGO
解决方案 »
- File.Delete(deletfile) 说有别的进程占用,无法删除
- @import指令和using指令的关系
- 我在Panel上放了好个个图片,能不能把这个Panel上的图片做为一个图片保存到本地?
- ASP.NET 页面在弹出信息框时,如何不刷新页面呢? B/s程序!
- vs2005中的MENU能做出仿QQ的WEB菜单吗?
- [求助] radiobuttonlist 中的javascript
- 急求日期控件
- .NET中的神密武器,在线等
- DataDropList如何绑定XML
- asp.net导出excel 显示只读 报错该文件破坏程度太大,不能进行修复
- 【100分求助】验证码字符歪曲并连接在一起,但不重叠
- 动态生成文本框控件后 调用js的日历控件 显示在页面上
当 SET NOCOUNT 为 OFF 时,返回计数。 如果存储过程中包含的一些语句并不返回许多实际的数据,则该设置由于大量减少了网络流量,因此可显著提高性能。
比如创建表语句是
create table table1(id int identity,t varchar(500))
表的第一列是id,它是int型的,并且是自增的,也就是你向表中插入数据的时候,不用给id列赋值,id列会自己复制。
当你的table记录>100条时会show top 100 record SET ROWCOUNT 与 TOP 的不同之处在于: SET ROWCOUNT 限制适用对 ORDER BY 取值后在结果集中生成行。如果指定了 ORDER BY,SELECT 语句将在从某个已根据指定的 ORDER BY 分类进行了排序的值集中选择 n 行后终止。
TOP 子句适用于指定了该子句的单个 SELECT 语句。在执行另一个 SET ROWCOUNT 语句之前,SET ROWCOUNT 会一直有效,例如执行 SET ROWCOUNT 0 将会关闭此选项。