Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃ×Ô¶¨ÒåµÄSQL½Å±¾´´½¨SQL ServerÊý¾Ý¿â°²×°Àý×Ó

Creating a Sample Installation that Creates a SQL Server Database by Running Customized SQL Script
InstallShield 2009
 ÓÃ×Ô¶¨ÒåµÄSQL½Å±¾´´½¨SQL ServerÊý¾Ý¿â°²×°Àý×Ó
Project 씀This information applies to the following project types: ´ËÐÅÏ¢ÊÇÓÃÓÚÏÂÃæµÄÏîÄ¿ÀàÐÍ
• Basic MSI
• InstallScript MSI
The following procedure demonstrates how to create an installation that creates a SQL Server database through customized SQL script.
ÏÂÃæµÄ¹ý³ÌչʾÁËÈçºÎÓÃ×Ô¶¨ÒåµÄSQL½Å±¾´´½¨SQL ServerÊý¾Ý¿â°²×°
Task ÈÎÎñ
To create an installation that creates a SQL Server database on the target machine by running customized SQL script:
1. Create a new Basic MSI or InstallScript MSI project.н¨Ò»¸ö»ù±¾MSI°²×°½Å±¾MSI¹¤³Ì¡£
2. In the View List under Behavior and Logic, click Property Manager.ÔÚÊÓͼÁбíϵÄÐÐΪºÍÂß¼­£¬µãÊôÐÔ¹ÜÀí¡£
3. Create a new property that has the following name:н¨ÊôÐÔÃû³ÆΪIS_SQLSERVER_DATABASE2
IS_SQLSERVER_DATABASE2
4. In the View List under Server Configuration, click SQL Scripts.ÔÚÊÓͼÁбíϵķþÎñÆ÷ÅäÖÃÖУ¬µãSQL ½Å±¾¡£
5. Add and configure a new SQL connection:
¼ÓÈëºÍÅäÖÃеÄSQLÁ¬½Ó£»
a. Right-click the SQL Scripts explorer and click New SQL Connection. InstallShield adds a new connection with the name NewConnection1 as the default name.
b. In the SQL Scripts explorer, click the NewConnection1 item, and then click the General tab.
c. In the Default Target Server Name (optional) box, type TESTSQLSERVER.
d. Clear the Create Catalog If Absent check box.
e. In the Connect using area, select the Server authentication using the Login ID and password below option.
f. In the Login ID box, type sa. Leave the Password box blank.
g. Click the Requirements tab.
h. Ensure that the Microsoft SQL Server check box is selected and the MySQL and Oracle check boxes are cleared.
6. Add and configure a new SQL script for NewConnection1:
ΪNewConnnection1¼ÓÈëºÍÅäÖ


Ïà¹ØÎĵµ£º

JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,Oracle

import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
  
public static void main(String[] args)throws Exception {
  
   Connection conn=null;
  
       //====Á¬½ÓACCESSÊý¾Ý¿â ......

SQLSERVER SQLÐÔÄÜÓÅ»¯

1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......

sqlÓï¾äÓÅ»¯

²Ù×÷·ûÓÅ»¯
IN ²Ù×÷·û
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ׶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£
µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵ģº
    Êý¾Ý¿âÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ÔÙ²éѯÍâ²ãµÄ±í¼Ç¼£¬Èç¹ûת»»³É¹¦ÔòÖ±½Ó²ÉÓöà¸ö±íµÄÁ¬½Ó·½Ê½²éѯ¡£Óɴ˿ɼû ......

SQL ÐÐÁл¥×ª

--ÐÐÁл¥×ª
/******************************************************************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ׶®
ÕûÀíÈË£ºÖйú·ç(Roy)
ÈÕÆÚ:2008.06.06
***************************************************************** ......

PB 11.5Á¬½ÓMS SQL Server 2005 Express

//ÔÚÓ¦ÓóÌÐòOpen ʼþ´úÂëÖÐ
idle(600)
openbakflag=1
///////////////////////¶ÁÈ¡ÅäÖÃÎļþÊý¾Ý¿âÁ¬½ÓÉèÖÃ///////////////////////
string server,datname,datuser,datpsw
server=ProfileString ( "yy.ini","yygl","server", "" )
datname=ProfileString ( "yy.ini","yygl","datname", "" )
datuser=ProfileStrin ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ