摘要:
原文:http://www.cnblogs.com/gaochundong/p/3813252.html常用数据结构的时间复杂度Data StructureAddFindDeleteGetByIndexArray (T[])O(n)O(n)O(n)O(1)Linked list (LinkedLis... 阅读全文
摘要:
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... 阅读全文
摘要:
USE [Limo_DB]GO/****** Object: StoredProcedure [dbo].[SP_Biz_Approve_Import] Script Date: 09/06/2014 17:59:52 ******/SET ANSI_NULLS ONGOSET QUOTED... 阅读全文
摘要:
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 ... 阅读全文
摘要:
refer:http://blog.waynesheffield.com/wayne/archive/2012/02/comparing-inline-and-multistatement-table-valued-functions/Table-Valued Functions. What a w... 阅读全文
摘要:
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... 阅读全文
摘要:
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, ... 阅读全文
摘要:
结论:1、不管有木有出现异常,finally块中代码都会执行;2、当try和catch中有return时,finally仍然会执行;3、finally是在return后面的表达式运算后执行的(此时并没有返回运算后的值,而是先把要返回的值保存起来,管finally中的代码怎么样,返回的值都不会改变,任... 阅读全文
摘要:
$('#btnSearch').click(function () {$("#list").trigger("reloadGrid"); var customernumber = $("#txtCustomernumber").val(); var customername = $("#txtCustomername").val(); var usindicia = $("#txtUSIndicia").val(); var date = $("#txtCaptured 阅读全文
摘要:
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... 阅读全文