08 2014 档案

产品分类表
摘要：CREATE TABLE [dbo].[GoodsCategories]( [ID] [int] NOT NULL, [ClassName] [nvarchar](20) NOT NULL, [ParentID] [int] NOT NULL, [Depth] [int] NOT NULL, [Ro... 阅读全文
posted @ 2014-08-27 10:34 M i S s 阅读(330) 评论(0) 推荐(0) 编辑
无限极分类
摘要：CREATE PROCEDURE [dbo].[GoodsCategories_Insert]@parentId int, --父类Id@className nvarchar(50) --分类名称ASBEGIN SET NOCOUNT ON; --不返回计数（表示受 Transact-SQL 语句影... 阅读全文
posted @ 2014-08-25 09:42 M i S s 阅读(302) 评论(0) 推荐(0) 编辑
sql 2种递归
摘要：alter FUNCTION f_Cid(@ID int)RETURNS @t_Level TABLE(ID int,Level int)ASBEGINDECLARE @Level intSET @Level=1INSERT @t_Level SELECT @ID,@LevelWHILE @@ROW... 阅读全文
posted @ 2014-08-20 20:37 M i S s 阅读(176) 评论(0) 推荐(0) 编辑
sql2种分页
摘要：declare @time datetimedeclare @ms intset @time= getdate()select ID,name from (select row_number() over(order by ID) as rowNum,* from dbo.testb) as t ... 阅读全文
posted @ 2014-08-20 20:34 M i S s 阅读(94) 评论(0) 推荐(0) 编辑