12 2011 档案

摘要:create table #temp(ids int identity(1,1), 日期 nvarchar(10))declare @beginDate datetimedeclare @endDate datetimeset @beginDate = '2009-06-01' set @endDate = '2009-06-10'declare @i intset @i = 0while @i <=datediff(DD,@beginDate,@endDate)begininsert into #tempselect convert(nvarchar(1 阅读全文
posted @ 2011-12-28 14:59 荣景智工 阅读(297) 评论(0) 推荐(0)
摘要:<select id="s6" multiple="multiple"> <asp:Repeater ID="rpl_dept" runat="server" onitemdatabound="rpl_dept_ItemDataBound"> <ItemTemplate> <optgroup label="<%#Eval("Name") %>"> <asp:Repeater ID=" 阅读全文
posted @ 2011-12-27 15:53 荣景智工 阅读(5112) 评论(0) 推荐(1)
摘要:View Code CREATE PROCEDURE addusermodule @ModuleId_Array varChar(2000), @UserId int AS DECLARE @PointerPrev int DECLARE @PointerCurr int DECLARE @TId int Set @PointerPrev=1 set @PointerCurr=1 begin transaction Set NoCount ON delete from tests where userid=... 阅读全文
posted @ 2011-12-27 10:02 荣景智工 阅读(1005) 评论(1) 推荐(0)