1. SQL Server 2000 Restore pre-requirement:
(1)You need to backup the following database : master , msdb and your own databases.
(2)sa's default database must be in database master.
(3)The new server's installed directory must be as the same as original one.
(4)New Server's version and server pack must be the same.
- Oct 04 Sat 2008 21:24
-
SQL 2000 Complete Restore Manual
- Jan 02 Wed 2008 14:37
-
SQL EIS的架構程序
透過SQL EIS，您可以完成簡易好用BI。
SQL建立程序如下：
1.在SQL連結伺服器，透過ODBC或是原生資料庫的驅動程式與來源資料建立連結。並設定每日將資料轉換進SQL Server，以加速後面資料計算與整合之效率。若有須要，可對這些轉進來的原始資料作索引。
2.透過SQL case when的語法進行ETL(Extract, Transformation, and Loading)。
3.依據使用者需求，透過T-SQL寫出使用者需要的欄位，並將結果透過select ....into table 或是create view的方式產生一個Table 或是 View。
- Dec 25 Tue 2007 15:55
-
可透過Socket執行Informix 4GL程式(Client端)
/* fpont 12/99 */
/* pont.net */
/* tcpClient.c */
#include
#include
- Dec 25 Tue 2007 15:46
-
可透過Socket執行Informix 4GL程式(Server端)
/* fpont 1/00 */
/* pont.net */
/* tcpServer.c */
#include
#include
- Dec 25 Tue 2007 15:38
-
取出所選資料中之第3筆資料
select
[前三次Remark]=
(
select '('+dbo.fyymmdd(fse_comment_date)+')'+CHAR(10)+'●'+fse_comment from
(select p1.*,
- Nov 25 Sun 2007 23:12
-
INFORMIX TRIGGER SAMPLE
N/A
- Nov 24 Sat 2007 17:00
-
好用的EXCEL圖表製作教學網站
Peltier Technical Services, Inc.
http://peltiertech.com/Excel/Charts/index.html
●Speedometer Chart
http://peltiertech.com/Excel/Charts/SpeedometerXP.html
- Nov 21 Wed 2007 22:49
-
How To Fix xp_sendmail
(1)use sp_dropextendedproc 'xp_sendmail' to drop xp_sendmail
(2)copy a new sqlmap70.dll from SQL Setup Disk replace where it was in your
SQL installation DISK
(3)use sp_addextendedproc 'xp_sendmail', 'C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\sqlmap70.dll' (assuming our new sqlmap70.dll was there)
- Nov 20 Tue 2007 17:30
-
Starting SQL Server in Single-User Mode
Under certain circumstances, you may need to start an instance of Microsoft® SQL Server™ in single-user mode using the startup option -m. For example, you may want to change server configuration options or recover a damaged master database or other system database. Both actions require starting an instance of SQL Server in single-user mode.
When you start an instance of SQL Server in single-user mode:
Only one user can connect to the server.
The CHECKPOINT process is not executed. By default, it is executed automatically at startup.
The sp_configure system stored procedure allow updates option is enabled. By default, the allow updates option is disabled.
- Nov 20 Tue 2007 17:21
-
Import data from SQL Server into Excel
這篇文章受密碼保護，請輸入密碼後查看內容。
- Nov 20 Tue 2007 17:17
-
TIPTOP資料庫匯出與匯入程序
這篇文章受密碼保護，請輸入密碼後查看內容。