´æ´¢¹ý³ÌµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
´æ´¢¹ý³ÌµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
´´½¨´æ´¢¹ý³Ì¡£´æ´¢¹ý³ÌÊÇÒѱ£´æµÄ Transact-SQL Óï¾ä¼¯ºÏ£¬»ò¶Ô Microsoft .NET Framework ¹«¹²ÓïÑÔÔËÐÐʱ (CLR) ·½·¨µÄÒýÓ㬿ɽÓÊÕ²¢·µ»ØÓû§ÌṩµÄ²ÎÊý¡£¿ÉÒÔ´´½¨¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°£¨¾Ö²¿ÁÙʱ¹ý³Ì£©ÖÐÁÙʱʹÓ㬻òÔÚËùÓлỰ£¨È«¾ÖÁÙʱ¹ý³Ì£©ÖÐÁÙʱʹÓá£
Æô¶¯ SQL Server µÄÒ»¸öʵÀýʱ£¬Ò²¿ÉÒÔ´´½¨²¢×Ô¶¯ÔËÐд洢¹ý³Ì¡£
Transact-SQL Óï·¨Ô¼¶¨
Óï·¨
CREATE { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ]
[ { @parameter [ type_schema_name. ] data_type }
[ VARYING ] [ = default ] [ [ OUT [ PUT ]
] [ ,...n ]
[ WITH <procedure_option> [ ,...n ]
[ FOR REPLICATION ]
AS { <sql_statement> [;][ ...n ] | <method_specifier> }
[;]
<procedure_option> ::=
[ ENCRYPTION ]
[ RECOMPILE ]
[ EXECUTE_AS_Clause ]
<sql_statement> ::=
{ [ BEGIN ] statements [ END ] }
<method_specifier> ::=
EXTERNAL NAME assembly_name.class_name.method_name
±¸×¢
Transact-SQL ´æ´¢¹ý³ÌµÄ×î´ó´óСΪ 128 MB¡£
Ö»ÄÜÔÚµ±Ç°Êý¾Ý¿âÖд´½¨Óû§¶¨Òå´æ´¢¹ý³Ì¡£ÁÙʱ¹ý³Ì¶Ô´ËÊǸöÀýÍ⣬ÒòΪËüÃÇ×ÜÊÇÔÚ tempdb Öд´½¨¡£Èç¹ûδָ¶¨¼Ü¹¹Ãû³Æ£¬ÔòʹÓô´½¨¹ý³ÌµÄÓû§µÄĬÈϼܹ¹¡£Óйؼܹ¹µÄÏêϸÐÅÏ¢£¬Çë²ÎÔÄÓû§¼Ü¹¹·ÖÀë¡£
ÔÚµ¥¸öÅú´¦ÀíÖУ¬CREATE PROCEDURE Óï¾ä²»ÄÜÓëÆäËû Transact-SQL Óï¾ä×éºÏʹÓá£
ĬÈÏÇé¿öÏ£¬²ÎÊý¿ÉΪ¿ÕÖµ¡£Èç¹û´«µÝ NULL ²ÎÊýÖµ²¢ÇÒÔÚ CREATE »ò ALTER TABLE Óï¾äÖÐʹÓøòÎÊý£¬¶ø¸ÃÓï¾äÖб»ÒýÓÃÁÐÓÖ²»ÔÊÐíʹÓÿÕÖµ£¬ÔòÊý¾Ý¿âÒýÇæ »á²úÉúÒ»¸ö´íÎó¡£ÈôÒª×èÖ¹Ïò²»ÔÊÐíʹÓÿÕÖµµÄÁд«µÝ NULL£¬ÇëΪ¹ý³ÌÌí¼Ó±à³ÌÂß¼£¬»òʹÓà CREATE TABLE »ò ALTER TABLE µÄ DEFAULT ¹Ø¼ü×Ö£¬ÒÔ±ã¶Ô¸ÃÁÐʹÓÃĬÈÏÖµ¡£
´æ´¢¹ý³ÌÖеÄÈκΠCREATE TABLE »ò ALTER TABLE Óï¾ä¶¼½«×Ô¶¯´´½¨ÁÙʱ±í¡£½¨Òé¶ÔÓÚÁÙʱ±íÖеÄÿÁУ¬ÏÔʽָ¶¨ NULL »ò NOT NULL¡£Èç¹ûÔÚ CREATE TABLE »ò ALTER TABLE Óï¾äÖÐδ½øÐÐÖ¸¶¨£¬Ôò ANSI_DFLT_ON ºÍ ANSI_DFLT_OFF Ñ¡Ï¿ØÖÆÊý¾Ý¿âÒýÇæ ΪÁÐÖ¸ÅÉ NULL »ò NOT NULL ÊôÐԵķ½Ê½¡£Èç¹ûij¸öÁ¬½ÓÖ´ÐеĴ洢¹ý³Ì¶ÔÕâЩ
Ïà¹ØÎĵµ£º
Ïà¹ØÎÄÕÂ:
mysqlÊý¾Ý¿âËø
ORACLEÀXÖÖËøÄ£Ê½
ÍÆ¼öȦ×Ó: Pipboy
¸ü¶àÏà¹ØÍÆ¼ö
new Draggable("related_topics");
¶ÔËø»úÖÆµÄÑо¿Òª¾ß±¸Á½¸öÌõ¼þ£º
1£®Êý¾ÝÁ¿´ó
2£®¶à¸öÓû§Í¬Ê±²¢·¢
Èç¹ûȱÉÙÕâÁ½¸öÌõ¼þ£¬Êý¾Ý¿â²»ÈÝÒײúÉúËÀËøÎÊÌâ¡£Ñо¿ÆðÀ´¿ÉÄÜ»áʱ¶¹ ......
1.SQLServerµÄ´´½¨½Å±¾ÈçÏ£º
USE [master]
GO
/****** Object: Database [test] Script Date: 10/29/2009 17:43:10 ******/
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test.mdf' , S ......
sqlserver µÄntextÀàÐÍÔÚÊý¾Ý¿âÖÐÊÇ¿´²»µ½ÖµµÄ
Æð³õÎÒ»¹ÒÔΪÊý¾ÝûÓвåÈ룬ºóÀ´²ÅÖªµÀntextÀàÐÍÔÚÊý¾Ý¿âÖб¾À´¾Í¿´²»µ½µÄ£¨Êý¾Ý½Ï¶ÌµÄ¿ÉÒÔ¿´µ½£©£»
ÄÇÎÒÒªÏë¿´µ½ntextÊý¾ÝÔõô°ì£¿
ÔÚ²éѯ·ÖÎöÆ÷ÖпÉÒÔ¿´µ½£¨²éѯ·ÖÎöÆ÷ÖÐÒ²Ö»¿´µ½ÁËǰ¼¸Ê®¸ö×Ö·û£¬¡¡²»ÊÇÈ«²¿µÄ£© ......
======================SqlServer´ó²¿·Ö֪ʶ¶¼ÔÚÎÒÕâ½Å±¾Àï===============
Èç¹ûÄãÄܰÑÊý¾Ý½á¹¹»³öÀ´µÄ»°£¬ÄÇôÄã¾ÍÈëÃÅÁË£¡£¡ºÇºÇ£¡£¡
--²é¿´konwyoumore¿âÊÇ·ñ´æÔÚ
USE master
IF exists(SELECT * from sysdatabases WHERE name='KnowYouMore')
BEGIN
DROP DATABASE knowyoumore;
END
GO
--´´½¨konwyo ......
Ë÷ÒýµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
Ϊָ¶¨±í»òÊÓͼ´´½¨¹ØÏµË÷Òý£¬»òΪָ¶¨±í´´½¨ XML Ë÷Òý¡£¿ÉÔÚÏò±íÖÐÌîÈëÊý¾Ýǰ´´½¨Ë÷Òý¡£¿Éͨ¹ýÖ¸¶¨ÏÞ¶¨µÄÊý¾Ý¿âÃû³Æ£¬ÎªÁíÒ»¸öÊý¾Ý¿âÖеıí»òÊÓͼ´´½¨Ë÷Òý¡£
Transact-SQL Óï·¨Ô¼¶¨
Óï·¨
Create Relational Index CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] IN ......