彦铭工作室[YMind Studio] - 网鸟IT技术QQ超级群：47700865

1. ODBC DSN
2. ODBC -- EasySoft ODBC Driver -- local machine
3. ODBC -- EasySoft ODBC Driver -- remote machine
4. ODBC -- Intersolv ODBC Driver -- local machine
5. ODBC -- Intersolv ODBC Driver -- remote machine

1. ODBC DSN
2. ODBC -- Sybase System 12 (12.5) ODBC Driver
3. ODBC -- Sybase System 11 ODBC Driver
4. ODBC -- Intersolv 3.10 ODBC Driver
5. ODBC -- SQL Anywhere
6. OleDb -- Sybase Adaptive Server Enterprise (ASE)
7. .NET DataProvider from Sybase

1. ODBC DSN
2. ODBC -- MyODBC Driver -- local database
3. ODBC -- MyODBC Driver -- remote database
4. ODBC -- MySQL ODBC 3.51 Driver
5. OleDb
6. .NET DataProvider from CoreLab

1. ODBC DSN
2. ODBC without DSN
3. OleDb -- Microsoft Driver
4. OleDb -- IBM Driver
5. .NET DataProvider from IBM

1. ODBC DSN
2. ODBC -- New Microsoft Driver
3. ODBC -- Old Microsoft Driver
4. ODBC -- Oracle Driver
5. OleDb -- Microsoft Driver
6. OleDb -- Oracle Driver -- Standard Connection
7. OleDb -- Oracle Driver -- Trusted Connection
8. .NET DataProvider from Microsoft -- Standard Connection
9. .NET DataProvider from Microsoft -- Trusted Connection
10. .NET DataProvider from Oracle -- Standard Connection
11. .NET DataProvider from Oracle -- Trusted Connection

1. ODBC DSN
2. ODBC -- Standard Security
3. ODBC -- Workgroup (System Database)
4. ODBC -- Exclusive Use
5. OleDb with MS Jet -- Standard Security
6. OleDb with MS Jet -- Workgroup (System Database)
7. OleDb with MS Jet -- With Password

1. .NET Data Provider -- Default Relative Path Standard Connection
2. .NET Data Provider -- Default Relative Path Trusted Connection
3. .NET Data Provider -- Custom Relative Path Standard Connection
4. .NET Data Provider -- Custom Relative Path Trusted Connection
5. .NET Data Provider -- Absolute Path Standard Connection
6. .NET Data Provider -- Absolute Path Trusted Connection

1. ODBC DSN
2. ODBC -- Standard Connection
3. ODBC -- Trusted Connection
4. OleDb -- Standard Connection
5. OleDb -- Trusted Connection
6. OleDb -- via IP Address
7. .NET DataProvider -- Standard Connection
8. .NET DataProvider -- Trusted Connection
9. .NET DataProvider -- via IP Address

通常我们是不需要在DELETE语句中使用“INNER JION”的。

一般情况下，我们会使用一系列的不带“INNER JION”的DELETE语句满足我们的工作需求。

在Sql Server中使用游标将行转换为列，用代码说话：

Declare @str as varchar(1000)  
Declare @TransposeStr as varchar(8000)  
 
Set @str = '' 
Set @TransposeStr = '' 
 
DECLARE cursorTranspose CURSOR FOR 
Select row from #tmpTable  
 
OPEN cursorTranspose  
FETCH NEXT FROM cursorTranspose INTO @str  
WHILE (@@FETCH_STATUS = 0)   
BEGIN    
   Set @TransposeStr = @TransposeStr + @str + ',' --Concatenation String   
   FETCH NEXT FROM cursorTranspose INTO @str  
END 
CLOSE cursorTranspose  
DEALLOCATE cursorTranspose