mssql´æ´¢¹ý³ÌÓï·¨Ïê½â£¨±¸Íü£©
Óï·¨
CREATE PROC[ EDURE ] [ owner. ] procedure_name [ ; number ]
[ { @parameter data_type }
[ VARYING ] [ = default ] [ OUTPUT ]
] [ ,...n ]
[ WITH
{ RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ]
[ FOR REPLICATION ]
AS sql_statement [ ...n ]
²ÎÊý
owner
ÓµÓд洢¹ý³ÌµÄÓû§ ID µÄÃû³Æ¡£owner ±ØÐëÊǵ±Ç°Óû§µÄÃû³Æ»òµ±Ç°Óû§ËùÊôµÄ½ÇÉ«µÄÃû³Æ¡£
procedure_name
д洢¹ý³ÌµÄÃû³Æ¡£¹ý³ÌÃû±ØÐë·ûºÏ±êʶ·û¹æÔò£¬ÇÒ¶ÔÓÚÊý¾Ý¿â¼°ÆäËùÓÐÕß±ØÐëΨһ¡£
;number
ÊÇ¿ÉÑ¡µÄÕûÊý£¬ÓÃÀ´¶ÔͬÃûµÄ¹ý³Ì·Ö×飬ÒÔ±ãÓÃÒ»Ìõ DROP PROCEDURE Óï¾ä¼´¿É½«Í¬×éµÄ¹ý³ÌÒ»Æð³ýÈ¥¡£ÀýÈ磬ÃûΪ orders µÄÓ¦ÓóÌÐòʹÓõĹý³Ì¿ÉÒÔÃüÃûΪorderproc;1¡¢orderproc;2 µÈ¡£DROP PROCEDURE orderproc Óï¾ä½«³ýÈ¥Õû¸ö×é¡£Èç¹ûÃû³ÆÖаüº¬¶¨½ç±êʶ·û£¬ÔòÊý×Ö²»Ó¦°üº¬ÔÚ±êʶ·ûÖУ¬Ö»Ó¦ÔÚ procedure_name Ç°ºóʹÓÃÊʵ±µÄ¶¨½ç·û¡£
@parameter
¹ý³ÌÖеIJÎÊý¡£ÔÚ CREATE PROCEDURE Óï¾äÖпÉÒÔÉùÃ÷Ò»¸ö»ò¶à¸ö²ÎÊý¡£Óû§±ØÐëÔÚÖ´Ðйý³ÌʱÌṩÿ¸öËùÉùÃ÷²ÎÊýµÄÖµ£¨³ý·Ç¶¨ÒåÁ˸òÎÊýµÄĬÈÏÖµ£¬»òÕ߸ÃÖµÉèÖÃΪµÈÓÚÁíÒ»¸ö²ÎÊý£©¡£´æ´¢¹ý³Ì×î¶à¿ÉÒÔÓÐ 2.100 ¸ö²ÎÊý¡£
ʹÓà @ ·ûºÅ×÷ΪµÚÒ»¸ö×Ö·ûÀ´Ö¸¶¨²ÎÊýÃû³Æ¡£²ÎÊýÃû³Æ±ØÐë·ûºÏ±êʶ·ûµÄ¹æÔò¡£Ã¿¸ö¹ý³ÌµÄ²ÎÊý½öÓÃÓڸùý³Ì±¾Éí£»ÏàͬµÄ²ÎÊýÃû³Æ¿ÉÒÔÓÃÔÚÆäËü¹ý³ÌÖС£Ä¬ÈÏÇé¿öÏ£¬²ÎÊýÖ»ÄÜ´úÌæ³£Á¿£¬¶ø²»ÄÜÓÃÓÚ´úÌæ±íÃû¡¢ÁÐÃû»òÆäËüÊý¾Ý¿â¶ÔÏóµÄÃû³Æ¡£
data_type
²ÎÊýµÄÊý¾ÝÀàÐÍ¡£³ý table Ö®ÍâµÄÆäËûËùÓÐÊý¾ÝÀàÐ;ù¿ÉÒÔÓÃ×÷´æ´¢¹ý³ÌµÄ²ÎÊý¡£µ«ÊÇ£¬cursor Êý¾ÝÀàÐÍÖ»ÄÜÓÃÓÚ OUTPUT ²ÎÊý¡£Èç¹ûÖ¸¶¨ cursor Êý¾ÝÀàÐÍ£¬Ôò»¹±ØÐëÖ¸¶¨ VARYING ºÍ OUTPUT ¹Ø¼ü×Ö¡£¶ÔÓÚ¿ÉÒÔÊÇ cursor Êý¾ÝÀàÐ͵ÄÊä³ö²ÎÊý£¬Ã»ÓÐ×î´óÊýÄ¿µÄÏÞÖÆ¡£
VARYING
Ö¸¶¨×÷ΪÊä³ö²ÎÊýÖ§³ÖµÄ½á¹û¼¯£¨ÓÉ´æ´¢¹ý³Ì¶¯Ì¬¹¹Ô죬ÄÚÈÝ¿ÉÒԱ仯£©¡£½öÊÊÓÃÓÚÓαê²ÎÊý¡£
default
 
Ïà¹ØÎĵµ£º
aspÏνÓMssqlµÄ°ì·¨¼°³£¼ûµÄ²î´í
//µÚÒ»ÖÖд·¨£º
MM_conn_STRING = "Driver={SQL Server};server=(local);uid=sa;pwd=;database=infs;"
Set conn = Server.Createobject("ADODB.Connection")
conn.open MM_conn_STRING
SET RS=SERVER.CreateObject("ADOBD.recordset")
SQL="SELECT * from TABLE ORDER BY ID DESC"
R ......
1¡¢SQL2000ÖÐÒ»±íÓÐÒ»ÈÕÆÚÐÍ×Ö¶ÎBirthDay£¬¼Ç¼³öÉúÈÕÆÚ£¬ÏëÿÄêÔÚ±¾ÈÕÉúÈÕÇ°15Ì죬½«Æä¹ýÂ˳öÀ´£¬ÔõôдWhereÌõ¼þ£¿£º
select out_date from sales_out_head_tab where (DATEDIFF(day,DATEADD(year ,year(getdate())-year(out_date) ,out_date )
,getdate()) BETWEEN -15 and 0 ) order by out_date ......
ODBCÊý¾ÝÔ´¿É·ÖΪ“ϵͳÐÍ”ºÍ“ÎļþÐÍ”£¬ËûÃǵÄÇø±ðÔÚÓړϵͳÐÍ”ÊÇÁ¬½ÓÊý¾Ý¿âµÄÐÅÏ¢½¨Á¢Ôړϵͳע²á±í”À“ÎļþÐÍ”ÔòÊÇÒÔdsnÎļþÐÎʽ´æ´¢ÔÚODBCÔ´µÄĿ¼ÏÂÃæ
Ò»¡¢½¨Á¢ODBCÊý¾ÝÔ´µÄ·½·¨£º
¿ØÖÆÃæ°å - ¹ÜÀí¹¤¾ß - Êý¾ÝÔ´£¨ODBC£©
´ò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¬È»ºóÒ ......
»ù±¾ÔÀí
FreeTDSΪLinuxϵͳÌṩÁËTDSÐÒéµÄ¿ªÔ´¿Í»§¶Ë¡£ÓÉÓÚMS SQLºÍSybaseʹÓõÄÇ¡ÊÇTDSÐÒ飬ËùÒÔÔÚLinuxÖпÉÒÔÓÃFreeTDSÁ¬½ÓMS SQL¡£
ÎÒÃÇ¿ÉÒÔÀûÓÃOpenOffice.Org Base¼°Linux ODBCʵÏÖ¿ÉÊÓ»¯µÄÊý¾Ý¿â²é¿´·½Ê½¡£·½±ã¸öÈËÓû§Ê¹ÓÃLinuxÔ¶³Ì¹ÜÀí×Ô¼ºµÄÊý¾Ý¿âϵͳ¡£
ÃüÁîÐз½Ê½Ê¹Ó÷½·¨¼ò½é
°²×°FreeTDSºÍsqsh
Ê×ÏÈ° ......
ÏÂÃæÊÇORACLEÐÐÁÐת»»Í¨Óô洢¹ý³Ì£º
1¡¢
Function Fun_Split_Str(p_Str Varchar2, p_Division Varchar2, p_Seq Int)
Return Varchar2 Is
v_First Int;
v_Last Int;
Begin
If p_Seq < 1 Then
&nbs ......