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
 
Ïà¹ØÎĵµ£º
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 ......
create function dbo.regexReplace
(
@source varchar(5000), --Ô×Ö·û´®
@regexp varchar(1000), - ......
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[temp_Table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[temp_Table]
GO
CREATE TABLE [dbo].[temp_Table] (
[id]&n ......
--1. ´´½¨±í£¬Ìí¼Ó²âÊÔÊý¾Ý
CREATE TABLE tb(id int, [value] varchar(10))
INSERT tb SELECT 1, 'aa'
UNION ALL SELECT 1, 'bb'
UNION ALL SELECT 2, 'aaa'
UNION ALL SELECT 2, 'bbb'
UNION ALL SELECT 2, 'ccc'
--SELECT * from tb
/**//*
id value
----------- ----------
1 aa
1 bb
2 aaa
......
»ù±¾ÔÀí
FreeTDSΪLinuxϵͳÌṩÁËTDSÐÒéµÄ¿ªÔ´¿Í»§¶Ë¡£ÓÉÓÚMS SQLºÍSybaseʹÓõÄÇ¡ÊÇTDSÐÒ飬ËùÒÔÔÚLinuxÖпÉÒÔÓÃFreeTDSÁ¬½ÓMS SQL¡£
ÎÒÃÇ¿ÉÒÔÀûÓÃOpenOffice.Org Base¼°Linux ODBCʵÏÖ¿ÉÊÓ»¯µÄÊý¾Ý¿â²é¿´·½Ê½¡£·½±ã¸öÈËÓû§Ê¹ÓÃLinuxÔ¶³Ì¹ÜÀí×Ô¼ºµÄÊý¾Ý¿âϵͳ¡£
ÃüÁîÐз½Ê½Ê¹Ó÷½·¨¼ò½é
°²×°FreeTDSºÍsqsh
Ê×ÏÈ° ......