mssql ĬÈϲÎÊýÔõÑù´¦Àí£¿ - MS-SQL Server / »ù´¡Àà
ÎÒ¶¨ÒåÒ»¸öº¯Êý£¬ÓÐÎå¸ö²ÎÊý
µ«Êµ¼ÊÉÏÎÒµ÷ÓÃʱ²»Ò»¶¨´«Îå¸ö²ÎÊý£¬ÓÐʱֻÐèÒª´«¶þ¸ö²ÎÊý£¬ÓÐʱֻÐèÒª´«Èý¸ö²ÎÊýµÈµÈ
ÕâÖÖ²ÎÊýÔõô¶¨ÒåÄØ£¿
SQL code:
CREATE FUNCTION [ owner_name.] function_name
( [ { @parameter_name [AS] scalar_parameter_data_type [ = default ] } [ ,...n ] ] )
RETURNS scalar_return_data_type
[ WITH < function_option> [ [,] ...n] ]
[ AS ]
BEGIN
function_body
RETURN scalar_expression
END
SQL code:
ÉèĬÈÏÖµ
default
²ÎÊýµÄĬÈÏÖµ¡£Èç¹û¶¨ÒåÁË default Öµ£¬ÔòÎÞÐèÖ¸¶¨´Ë²ÎÊýµÄÖµ¼´¿ÉÖ´Ðйý³Ì¡£Ä¬ÈÏÖµ±ØÐëÊdz£Á¿»ò NULL¡£Èç¹û¹ý³ÌʹÓôø LIKE ¹Ø¼ü×ֵIJÎÊý£¬Ôò¿É°üº¬ÏÂÁÐͨÅä·û£º%¡¢_¡¢[] ºÍ [^]¡£
USE AdventureWorks;
GO
IF OBJECT_ID ( 'HumanResources.usp_GetEmployees2', 'P' ) IS NOT NULL
DROP PROCEDURE HumanResources.usp_GetEmployees2;
GO
CREATE PROCEDURE HumanResources.usp_GetEmployees2
@lastname varchar(40) = 'D%',
@firstname varchar(20) = '%'
AS
SELECT LastName, FirstName, JobTitle, Department
from HumanResources.vEmployeeDepartment
WHERE FirstName LIKE @firstname
AND LastName LIKE @lastname;
GO
SQL77ÐÖ£º
Äܲ»ÄܾٸöÀý×Ó£¿
2Â¥²»¾ÍÊÇÀý×ÓÂð
bancxcÐÖ£º
²»ÊÇ´æ´¢¹ý³Ì£¬ÊÇ×Ô¶¨Ò庯Êý
´æ´¢¹ý³ÌÊÇ¿ÉÒÔµÄ
{{-
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......