ALTER TABLE UserInfo DROP CONSTRAINT  DF__UserInfo__YJ_Win__2AC04CAA ALTER TABLE UserInfo   DROP COLUMN YJ_WinNum GO

USE [hsh_db_2013_11_18] GO

DECLARE @return_value int

EXEC @return_value = [dbo].[p_SelectByPage]   @SelectList = N'*',   @TableSource = N'v_UserNotice',   @SearchCondition = N'isdel=0 and IsRead=0 and IsSys=1 ',   @OrderExpression = N'AddTime desc',   @PageIndex = 1,   @PageSize = 10

SELECT 'Return Value' = @return_value GO

posted on 2014-07-23 10:29  微笑点燃希望  阅读(152)  评论(0编辑  收藏  举报
font=white