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
 
Ïà¹ØÎĵµ£º
Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Çóƽ¾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇƽ¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚƽ¾ùÖµ¸ ......
create function dbo.regexReplace
(
@source varchar(5000), --Ô×Ö·û´®
@regexp varchar(1000), - ......
-- ÈÎÒâ½øÖÆת»»Îª10½øÖÆ
-- Àý 0FA ת»»Îª 16½øÖÆ select dbo.f_BinaryToInt('0123456789ABCDEF', '0FA')
CREATE function dbo.f_BinaryToInt(@BinaryFormate varchar(100), @num varchar(200))
--@BinaryFormate Ϊ×Ô¶¨ÒåµÄ½øÖƸñʽ
--@num ΪҪת»»³É10½øÖƵÄ×Ô¶¨ ......
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="Default" value="Default" />
</appSettings>
<connectionStrings>
<add name="Default" connectionString="Data Source=192.168.1.197;User ID ......
set statistics profile on
set statistics io on
set statistics time on
select top 1 * from et_order order by pkid desc
½á¹ûÈçÏ£º
SQL Server ·ÖÎöºÍ±àÒëʱ¼ä:
CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
SQL Server Ö´ÐÐʱ¼ä:
CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
SQL Se ......