林小蔚的異想空間
一個由理性與感性交織與衝擊出的思想與異想時間與空間
熱門文章
SQL 宣告變數 設定變數
DECLARE @ID AS INT DECLARE @LastCust AS VARCHAR(50) DECLARE @LastReceiveTime AS DATETIME SET @ThisCust = ''
SQL 分組 分類 計算個數
SELECT DISTINCT GroupField1, COUNT(*) AS CountField FROM SourceTableName GROUP BY GroupField1 HAVING COUNT(*) > 1 ORDER BY CountField
SQL 分組排名
----以相同GroupField為組，依據SortField排序，並給予排名RANK SELECT RANK() OVER (PARTITION BY SourceTableName.GroupField ORDER BY SourceTableName1.SortField1...
DataTable DataView DataGrid中一些容易混淆的概念
DataTable,DataView和DataGrid中一些容易混淆的概念 一、DataTable DataTable表示內存中數據的一個表，它完全是在內存中的一個獨立存在，包含了這張表的全部信息。DataTable可以是從通過連接從數據庫中讀取出來形成的一個表，一旦將內容讀到D...
SQL 字串相加
StrA + StrB
DataTable DataView Print 列印
vb.net Private Sub PrintTableOrView(ByVal dv As DataView, ByVal label As String) Dim sw As System.IO.StringWriter Dim output As Stri...
SQL 迴圈
--宣告Cursor的資料來源Table DECLARE vendor_cursor CURSOR FOR SELECT Field1, Field2, Field3 FROM SourceTableName WHERE Field4 IN ( SELECT DISTINCT ...
SQL 字串index
IF PATINDEX('%' + @pattern + '%', @Expression) = 0 找不到 IF PATINDEX('%' + @pattern + '%', @Expression) = 1 字串...
網路簡介與指令
網路簡介與指令
IIS Recycle AppPool List AppPool
IIS 6 iisapp /a DefaultAppPool /r c:\windows\system32\iisapp.vbs /a YourPoolName /r cscript.exe c:\windows\system32\iisapp.vbs /a YourPoolNa...
星期四, 12月 25, 2008
如果您具備有效的憑證伺服器，如何為 SQL Server 2000 啟用 SSL 加密
如果您具備有效的憑證伺服器，如何為 SQL Server 2000 啟用 SSL 加密
How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console
How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console
Use SSL to Secure Communication with SQL Server 2000 — IT技术 - 赛迪网
Use SSL to Secure Communication with SQL Server 2000 — IT技术 - 赛迪网
How To - Use IPSec to Provide Secure Communication Between Two Servers
How To - Use IPSec to Provide Secure Communication Between Two Servers
How To: Use IPSec for Filtering Ports and Authentication
How To: Use IPSec for Filtering Ports and Authentication
How To: Encrypt Configuration Sections in ASP.NET 2.0 Using RSA
How To: Encrypt Configuration Sections in ASP.NET 2.0 Using RSA
How To: Encrypt Configuration Sections in ASP.NET 2.0 Using DPAPI
How To: Encrypt Configuration Sections in ASP.NET 2.0 Using DPAPI
How To: Connect to SQL Server Using Windows Authentication in ASP.NET 2.0
How To: Connect to SQL Server Using Windows Authentication in ASP.NET 2.0
How To: Connect to SQL Server Using SQL Authentication in ASP.NET 2.0
How To: Connect to SQL Server Using SQL Authentication in ASP.NET 2.0
較新的文章
較舊的文章
首頁
訂閱：
文章 (Atom)
