Changes between Version 10 and Version 11 of jazz/13-12-21

Timestamp:

Dec 21, 2013, 9:02:02 PM (11 years ago)

Author:

jazz

Comment:

--

jazz/13-12-21

@@ -75 +75 @@
 CREATE LOGIN [LoginName] WITH PASSWORD = 'SomePassword' ;
 }}}
+ * <參考> [http://technet.microsoft.com/en-us/library/ms178630.aspx sp_changedbowner (Transact-SQL)] - 修改資料庫的預設擁有者
+{{{
+use [DatabaseName]; EXEC sp_changedbowner [LoginName];
+}}}
+ * <參考> 
+{{{
+ALTER LOGIN [LoginName] WITH DEFAULT_DATABASE = [DatabaseName]
+}}}
+ * <參考> [http://msdn.microsoft.com/en-us/library/ms188365.aspx BULK INSERT (Transact-SQL)] - 將 CSV 文字檔匯入到資料表
+{{{
+BULK INSERT NYSE_DAILY FROM 'c:\NYSE_daily.txt' WITH ( FIELDTERMINATOR ='\t', ROWTERMINATOR ='\n' );
+}}}