摘要：以NorthWind为例: (1)两次排序CREATE PROC dbo.GetCategories@PageSize int,@PageNum intASDECLARE @Ignore intDECLARE @LastID intIF @PageNum > 1 BEGIN SET @Ignore = @PageSize * ( @PageNum -1 ) SET ROWCOUNT @I... 阅读全文
DBML存储过程返回值
2009-08-31 15:45 by 蜡笔小旧, 357 阅读, 1 推荐, 收藏,
摘要： [Function(Name="dbo.Search")] public int Search([Parameter(Name="KeyWord", DbType="NVarChar(100)")] string keyWord, [Parameter(Name="PageSize", DbTyp... 阅读全文
行变列
2009-08-25 11:15 by 蜡笔小旧, 157 阅读, 0 推荐, 收藏,
摘要：ALTER FUNCTION dbo.GetFullTextJoinStringAmount( @ObjId UNIQUEIDENTIFIER, @condition NVARCHAR(100))RETURNS VARCHAR(1000)ASBEGIN DECLARE @a VARCHAR(1000) SELECT @a = ISNULL(@a+',','') + CAST(Amount AS ... 阅读全文
ienumerable ienumerator
2009-08-18 13:41 by 蜡笔小旧, 139 阅读, 0 推荐, 收藏,
摘要：http://www.xue5.com/itedu/200802/105266.html http://www.cnblogs.com/illele/archive/2008/04/21/1164696.html http://codebetter.com/blogs/david.hayden/archive/2005/03/08/59419.aspx http://blog.colinma... 阅读全文
Simple NameValueCollection
2009-08-17 12:57 by 蜡笔小旧, 134 阅读, 0 推荐, 收藏,
摘要：public class SimpleNameValueCollection { private Hashtable m_entriesTable; public SimpleNameValueCollection() { m_entriesTable = new Hashtable(); } public void Add(string key, string value) { ArrayLis... 阅读全文
RDLC - 默认的RDLC文档
2009-08-13 19:08 by 蜡笔小旧, 475 阅读, 0 推荐, 收藏,
摘要：<?xml version="1.0" encoding="utf-8"?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.mic... 阅读全文
Foreach。Collection was modified; enumeration operation may not execute."的错误。
2009-07-29 14:33 by 蜡笔小旧, 974 阅读, 0 推荐, 收藏,
摘要：Foreach … IN 不能修改集合内容 用for就OK了。 阅读全文
ms sql server 2000 GRANT EXECUTE on database to Roles
2009-07-28 11:40 by 蜡笔小旧, 953 阅读, 0 推荐, 收藏,
摘要：今天想把当前数据库所有执行存储的权限给一个角色 ,于是写 GRANT EXECUTE on D TO PPRoles结果是有语法错误，开联机丛书，貌似只能on单个存储过程statement是被授予权限的语句。语句列表可以包括： CREATE DATABASECREATE DEFAULTCREATE FUNCTIONCREATE PROCEDURECREATE RULECREATE TABLECRE... 阅读全文
浙公网安备 33010602011771号