PL/SQLÓαê×ܽá
Óα꣺ָÏò´¦ÀíSQLÓï¾äµÄ»·¾³ÇøÓòµÄÖ¸Õë»ò¾ä±ú
-----|-1 ¾²Ì¬Óαê
|---1.1 ÒþʽÓαê
| ´¦Àí£ºINSERT,DELETE,UPDATE¼°·µ»ØÒ»ÐеÄSELECTÓï¾ä
| ²Ù×÷£ºÓÉPL/SQL×Ô¶¯¶¨Òå²¢Íê³É´ò¿ªÓë¹Ø±Õ¶¯×÷
| ÊôÐÔ£º%FOUND,%NOTFOUND,%ISOPEN,%ROWCOUNT
|---1.2 ÏÔʾÓαê
| ´¦Àí£º·µ»Ø¶àÐеÄSELECTÓï¾ä
| ²Ù×÷£º1.2.1 ÏÔÊ¾ÍÆ½øÑ»·
| --ÉùÃ÷Óαê
| --´ò¿ªÓαê
| --ÍÆ½øÓαê
| --¹Ø±ÕÓαê
| 1.2.2 ×Ô¶¯ÍƽøÑ»·
|
Ïà¹ØÎĵµ£º
USE [sfaecrm]
GO
/****** ¶ÔÏó: StoredProcedure [dbo].[proc_insert] ½Å±¾ÈÕÆÚ: 05/29/2009 06:16:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[proc_insert] (@tablename varchar(256))
as
begin
set ......
SQLµÄ»ù±¾¶ÔÏóÖ÷ÒªÓг£Á¿£¬±íʾ·û£¬·Ö¸ô·û£¬±£Áô¹Ø¼ü×Ö¡£
1¡¢³£Á¿
³£Á¿ÊÇÒ»¸ö°üº¬ÎÄ×ÖÓëÊý×Ö£¬Ê®Áù½øÖÆ»òÊý×Ö³£Á¿¡£Ò»¸ö×Ö·û´®³£Á¿°üº¬µ¥ÒýºÅ('')»òË«ÒýºÅ("")×Ö·û¼¯ÖеÄÒ»¸ö»ò¶à¸ö×Ö·û¡£
Èç¹ûÏëÔÚµ¥ÒýºÅ·Ö¸ôµÄ×Ö·û´®ÖÐÓõ½µ¥¶ÀµÄÒýºÅ£¬¿ÉÒÔÔÚÕâ¸ö×Ö·ûÖÐÓû§Á¬ÐøµÄµ¥ÒýºÅ£¨¼´ÓÃÁ ......
SQLÓï¾äÏÈǰдµÄʱºò£¬ºÜÈÝÒ×°ÑÒ»Ð©ÌØÊâµÄÓ÷¨Íü¼Ç£¬ÎÒÌØ´ËÕûÀíÁËÒ»ÏÂSQLÓï¾ä²Ù×÷¡£
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssq ......
ÎÒÀí½âµÄSQL Server 2005¾µÏñÅäÖÃʵ¼ÊÉϾÍÊÇÓÉÈý¸ö·þÎñÆ÷£¨Ò²¿ÉÒÔÊÇͬһ·þÎñÆ÷µÄÈý¸ö SQL ʵÀý£©×é³ÉµÄÒ»¸ö±£Ö¤Êý¾ÝµÄ»·¾³£¬·Ö±ðÊÇ£ºÖ÷·þÎñÆ÷¡¢´Ó·þÎñÆ÷¡¢¼ûÖ¤·þÎñÆ÷¡£
Ö÷·þÎñÆ÷£ºÊý¾Ý´æ·ÅµÄµØ·½
´Ó·þÎñÆ÷£ºÊý¾Ý±¸·ÝµÄµØ·½£¨¼´£ºÖ÷·þÎñÆ÷µÄ¾µÏñ£©
¼ûÖ¤·þÎñÆ÷£º¶¯Ì¬µ÷ÅäÖ÷/´Ó·þÎñÆ÷µÄµÚÈý·½·þÎñÆ÷
»·¾³½éÉÜ
Ê×ÏȽé ......