<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html><head><title></title><meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1"><meta name=ProgId content=VisualStudio.HTML><meta
using System;namespace CSDesingPattern{ class Singleton { private static Singleton mInstance; private int x = 0; private Singleton(){} public static Singleton GetObject() { if (mInstance == null) mInstance = new Singleton(); return
SELECT 表名=case when a.colorder=1 then d.name else '' end, 欄位序號=a.colorder, 欄位名=a.name, 標識=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end, 主鍵=case when exists(SELECT 1 FROM sysobjects where xtype='PK' and name in ( SELECT
由於寫一個代碼自動產生工具,需要找一些讀系統資料字典的資訊,以前有個寫一個很不錯的,SELECT 表名=case when a.colorder=1 then d.name else '' end, 欄位序號=a.colorder, 欄位名=a.name, 標識=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end, 主鍵=case when exists(SELECT 1 FROM sysobjec
操作符“^”大家在基本理論都學習過他的意思,就是“異或”,但在實際編程中卻很少用到。最近我用了發現它有幾個驚人的功人。"&"是與的意思!第一:取反,比較你在資料庫裡有1一個情況,0表示另一種情況,這時在SQL server 2000 裡我們可以設計資料類型為BIT,我寫一條更新語句,把原來是0變為1,把1變為0, UPDATE table set FLAG = FLAG ^ 2 當然也可以CASE等其它方法,但是上面的方法是最簡單的,速度最快的。
It appears that Speed Download‘s broswer plugin is to blame. Quit completely out of Safari.Go to(Shift+Command+G) /Library/Internet Plug-Ins directory and locate the file SpeedDownload Browser Plugin.plugin and move it out of that folder.Restart
How to fix Xcode 4.3 Organizer CrashAfter downloading the new Xcode (4.3.2) I couldn’t get into the organizer’s Device Manager. Xcode crashed whenever I tried. It turns out that I had a few untrusted certificates in my keychain. This seems to be a
以後我們做多條件查詢,一種是排列結合,另一種是動態拼接SQL如:我們要有兩個條件,一個日期@addDate,一個是@name第一種寫法是if (@addDate is not null) and (@name <> '')select * from table where addDate = @addDate and name = @nameelse if (@addDate is not null) and (@name ='')select * from table where