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

ͨ¹ýSQL Server Agent·½Ê½ÊµÏÖÊý¾Ý¿â×Ô¶¯±¸·Ý£¡

--ÓÃJOB. 
--SQL SERVER2000ΪÀý 
ÆóÒµ¹ÜÀíÆ÷—>Êý¾Ý¿â·þÎñÆ÷—>¹ÜÀíĿ¼—>SQL SERVER´úÀí—>×÷Òµ—>ÓÒ¼ü Ñ¡—>н¨ 
³£¹æÑ¡ÏîÒ³—>ÊäÈë×÷ÒµÃû³Æ—>Ñ¡ÖÐËùÓÐÕß¡£ 
²½ÖèÑ¡ÏîÒ³—>н¨—>ÊäÈë²½ÖèÃû—>ÀàÐÍ TSQL½Å±¾—>Ñ¡ÔñÐèÒªÖ´ÐеÄÊý¾Ý¿â—>ÔÚÃüÁî¿òÀïÊäÈëÄãµÄSQL ½Å±¾£º
È磺Backup Database tedmdb To Disk='D:/test.bak'
Äã¿ÉÒÔµã×óϽǵġ¾·ÖÎö¡¿°´Å¥£¬·ÖÎöÒ»ÏÂÓï·¨£¬·ÖÎöÎÞÎ󣬰´È·¶¨¡£ 
µ÷¶ÈÑ¡ÏîÒ³—>н¨µ÷¶È—>ÊäÈëµ÷¶ÈÃû³Æ—>µ÷¶ÈÀàÐÍ Äã¿ÉÒÔÑ¡ÔñÒ²¿ÉÒÔµãÓÒϽǵġ¾¸ü¸Ä¡¿°´Å¥½øÐиü¸Ä£¬È·¶¨¡£ 
ÈÎÎñÀ¸ SQL SERVER·þÎñÆ÷µÄСͼ±ê Ë«»÷ ·þÎñ Ñ¡ÖÐ SQL SERVER AGENT,µã¡¾¿ªÊ¼/¼ÌÐø¡¿£¬Ñ¡Öе±Æô¶¯OSʱ£¬×Ô¶¯Æô¶¯·þÎñ£¬¾Í¿ÉÒÔÁË¡£ 
µ½Ä㶨µÄÄǸöʱ¼äµã£¬SQL SERVER»á×Ô¶¯È¥Ö´ÐÐÄãµÄ½Å±¾µÄ¡£ 
Èç¹ûÐèÒªÉú³É½Å±¾µÄ»°£¬ÆóÒµ¹ÜÀíÆ÷—>Êý¾Ý¿â·þÎñÆ÷—>¹ÜÀíĿ¼—>SQL SERVER´úÀí—>×÷Òµ—>ÓÒ¼üÄã¸ÕÍê³ÉµÄ×÷Òµ—>ËùÓÐÈÎÎñ 
—>Éú³ÉSQL½Å±¾£¬¼´¿ÉÉú³ÉÄãÐèÒªµÄ½Å±¾¡£
´úÂ룺
 -- Script generated on 2009-10-16 14:56
-- By: sa
-- Server: (LOCAL)
BEGIN TRANSACTION           
  DECLARE @JobID BINARY(16) 
  DECLARE @ReturnCode INT   
  SELECT @ReturnCode = 0    
IF (SELECT COUNT(*) from msdb.dbo.syscategories WHERE name = N'Database Maintenance') < 1
  EXECUTE msdb.dbo.sp_add_category @name = N'Database Maintenance'
  -- Delete the job with the same name (if it exists)
  SELECT @JobID = job_id    
  from   msdb.dbo.sysjobs   
  WHERE (name = N'db_auto_backup_test')      
  IF (@JobID IS NOT NULL)   
  BEGIN 
  -- Check if the job is a multi-server job 
  IF (EXISTS (SELECT  *
       


Ïà¹ØÎĵµ£º

JSPʵÀýÈý¡¢sql·ÖÒ³(1)

index.jsp
<%@ page language="java" import="java.sql.*" import="java.lang.*" import="java.util.*" pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%!
& ......

SQL2005ºÍ(Excel |access)Ö®¼äµÄÊý¾Ýµ¼Èëµ¼³ö


Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º    
  
  
--Excel---->SQL2005  µ¼È룺    
  
  
select * into useinfo from O ......

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´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......

ʹÓÃSQLServerÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾ä

Èç¹ûÄã¾­³£Óöµ½ÏÂÃæµÄÎÊÌ⣬Äã¾ÍÒª¿¼ÂÇʹÓÃSQL ServerµÄÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾äÁË£º
SQL³õѧÕß¡£
¾­³£Íü¼Ç³£ÓõÄDML»òÊÇDDL SQL Óï¾ä¡£
ÔÚ¶àÈË¿ª·¢Î¬»¤µÄSQLÖУ¬Ã¿¸öÈ˶¼ÓÐ×Ô¼ºµÄSQLϰ¹ß£¬Ã»ÓÐÒ»Ì×ͳһµÄ¹æ·¶¡£
ÔÚSQL Server Management StudioÖУ¬ÒѾ­¸ø´ó¼ÒÌṩÁ˺ܶೣÓõÄÏÖ³ÉSQL¹æ·¶Ä£°å¡£
SQL Server Management ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ