摘要: 原文:http://www.cnblogs.com/gaochundong/p/3813252.html常用数据结构的时间复杂度Data StructureAddFindDeleteGetByIndexArray (T[])O(n)O(n)O(n)O(1)Linked list (LinkedLis... 阅读全文
posted @ 2015-05-30 13:01 Cathy Lee 阅读(228) 评论(0) 推荐(0) 编辑
摘要: 1. Use a query string, which appends information onto the URL of the target page. You can use a query string when using a HyperLink control to build n... 阅读全文
posted @ 2015-05-29 13:30 Cathy Lee 阅读(162) 评论(0) 推荐(0) 编辑
摘要: USE [Limo_DB]GO/****** Object: StoredProcedure [dbo].[SP_Biz_Approve_Import] Script Date: 09/06/2014 17:59:52 ******/SET ANSI_NULLS ONGOSET QUOTED... 阅读全文
posted @ 2014-09-08 17:53 Cathy Lee 阅读(195) 评论(0) 推荐(0) 编辑
摘要: refer:http://databases.aspfaq.com/general/why-do-some-sql-strings-have-an-n-prefix.htmlYou may have seen Transact-SQL code that passes strings around ... 阅读全文
posted @ 2014-09-01 17:13 Cathy Lee 阅读(262) 评论(0) 推荐(0) 编辑
摘要: refer:http://blog.waynesheffield.com/wayne/archive/2012/02/comparing-inline-and-multistatement-table-valued-functions/Table-Valued Functions. What a w... 阅读全文
posted @ 2014-08-31 19:36 Cathy Lee 阅读(5556) 评论(0) 推荐(0) 编辑
摘要: refer from InsideMiscrsoft SQL Server 2008: T-SQL Programming.You should be aware that invoking scalar UDFs in queries has a high cost when you provid... 阅读全文
posted @ 2014-08-31 17:57 Cathy Lee 阅读(247) 评论(0) 推荐(0) 编辑
摘要: refer from :http://explainextended.com/2009/07/16/inner-join-vs-cross-apply/INNER JOINis the most used construct inSQL: it joins two tables together, ... 阅读全文
posted @ 2014-08-31 17:42 Cathy Lee 阅读(276) 评论(0) 推荐(0) 编辑
摘要: 结论:1、不管有木有出现异常,finally块中代码都会执行;2、当try和catch中有return时,finally仍然会执行;3、finally是在return后面的表达式运算后执行的(此时并没有返回运算后的值,而是先把要返回的值保存起来,管finally中的代码怎么样,返回的值都不会改变,任... 阅读全文
posted @ 2014-06-03 10:13 Cathy Lee 阅读(213) 评论(0) 推荐(0) 编辑
摘要: $('#btnSearch').click(function () {$("#list").trigger("reloadGrid"); var customernumber = $("#txtCustomernumber").val(); var customername = $("#txtCustomername").val(); var usindicia = $("#txtUSIndicia").val(); var date = $("#txtCaptured 阅读全文
posted @ 2014-04-01 13:12 Cathy Lee 阅读(117) 评论(0) 推荐(0) 编辑
摘要: USE [DB]GO/****** Object: UserDefinedFunction [dbo].[Func_DateFormat] Script Date: 03/31/2014 18:08:47 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER function [dbo].[Func_DateFormat](@Date datetime, @Format varchar(50))returns varchar(11)asbegin declare @Month varchar(3) declare @Mont... 阅读全文
posted @ 2014-03-31 18:10 Cathy Lee 阅读(273) 评论(0) 推荐(0) 编辑