摘要： http://www.cppblog.com/chefZ/archive/2008/12/05/68679.aspx http://www.bianceng.cn/Programming/net/201102/24226_7.htm 阅读全文

摘要： 复杂查询 阅读全文

摘要： http://msdn.microsoft.com/en-us/magazine/cc300760.aspx 阅读全文

摘要： http://www.ofb.net/~niniane/resume_howto.html http://ofb.net/~niniane/resume.html 阅读全文

摘要： --drop trigger Admin_Backup_Objects ON DATABASE --drop table AdministratorLogcreate table AdministratorLog(databasename sysname, eventtype sysname,objectname sysname, objecttype sysname, sqlcommand nv... 阅读全文

摘要： 1NF:Requiring existence of "the key"2NF:non-key attributes be dependent on "the whole key"3NF:non-key attributes be dependent on "nothing but the key" 阅读全文

摘要： Use static initilization to implement thread safe singleton. public sealed class SingleTon { #region Singleton static readonly SingleTon instance = new SingleTon(); static string path; private static... 阅读全文

摘要： K:\setup.exe /ACTION=install /SkipRules=VSShellInstalledRule 阅读全文

摘要： SELECT L.request_session_id AS SPID, DB_NAME(L.resource_database_id) AS DatabaseName, O.Name AS LockedObjectName, P.object_id AS LockedObjectId, L.resource_type AS LockedResource, L.request_mode A... 阅读全文

摘要： if( OBJECT_ID('tempdb..#t1') is not null) drop table #t1 create table #t1 (id int ) begin tran begin try insert into #t1(id) values(1) print '1' raiserror('1 error',16,1) print '11' commit print '111'... 阅读全文