Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql server 2005´¥·¢Æ÷ѧϰ±Ê¼Ç£¨Ò»£©

        ´¥·¢Æ÷ʵ¼ÊÉϾÍÊÇÒ»ÖÖÌØÊâÀàÐ͵Ĵ洢¹ý³Ì£¬ÆäÌØÊâÐÔ±íÏÖÔÚ£ºËüÊÇÔÚÖ´ÐÐÌØ¶¨µÄT-SQL ×Ô¶¯Ïà¼ÓµÄ¡£
   
        ´¥·¢Æ÷·ÖΪÁ½Àࣺ 
                               Ò»£º DML ´¥·¢Æ÷
                                                   DML´¥·¢Æ÷Êǵ±Êý¾Ý¿â·þÎñÆ÷Öз¢ÉúÊý¾Ý²Ù×÷ÓïÑÔʼþÖ´ÐеĴ洢¹ý³Ì¡£
                                                    DML·ÖΪ£º AFTER ´¥·¢Æ÷ ºÍ  Instead Of´¥·¢Æ÷
                               ¶þ£º DLL´¥·¢Æ÷
                                                     DDL´¥·¢Æ÷ÊÇÔÚÏìÓ¦Êý¾Ý¶¨ÒåÓïÑÔʱ¼äʱִÐеĴ洢¹ý³Ì¡£DDL´¥·¢Æ÷Ò»°ãÓÃÓÚÖ´ÐÐÊý¾Ý¿âÖйÜÀíÈÎÎñ¡£ÈçÉóºËºÍ¹æ·¶Êý¾Ý¿â²Ù×÷¡¢·ÀÖ¹Êý¾Ý±í½á¹¹±»Ð޸ĵȡ£
        
        ´¥·¢Æ÷×÷Óãº
                &n


Ïà¹ØÎĵµ£º

PL/SQL ѧϰ±Ê¼Ç2

±äÁ¿ÉùÃ÷
Syntax:
identifier [CONSTANT] datatype [NOT NULL]   [:= | DEFAULT expr];
SQL> declare
2 a date;
3 b number(20) not null :=100;
4 c varchar2(10);
5 d constant number(20) default 1000;
6 begin
7 null;
8 end;
9 /
PL/SQL procedure successful ......

C#Á¬½ÓSQL Server 2005 ExpressµÄ×Ö·û´®

C#Á¬½ÓSQL ServerµÄSqlConnectionµÄ×Ö·û´®£¬Ðí¶à¶¼ÊDz»ÄÜÁ¬½ÓµÄ¡£ÏÖÔÚ¸øÒ»¸öÄÜÁ¬½ÓµÄ£º
using System.Data.SqlClient;
public class sqlServerConnection {
//
public static void Main() {
//ÏÂÃæ¾ÍÊDZê×¼µÄÁ¬½Ó£¬×¢ÒâSERVERÊÇÎҵļÆËã»úÃû¡£SQLEXPRESSÊÇÊý¾Ý¿âʵÀý¡£SSPI±íʾʹÓÃWindowsµÇ½µÄÕÊ»§¡£masterÊÇÒªÁ¬½Óµ ......

SQL SERVERÐÔÄÜÓÅ»¯×ÛÊö

½üÆÚÒò¹¤×÷ÐèÒª£¬Ï£Íû±È½ÏÈ«ÃæµÄ×ܽáÏÂ
SQL SERVER
Êý¾Ý¿âÐÔÄÜÓÅ»¯Ïà¹ØµÄ×¢ÒâÊÂÏÔÚÍøÉÏËÑË÷ÁËÒ»ÏÂ
,
·¢ÏֺܶàÎÄÕÂ
,
ÓеͼÁгöÁËÉϰÙÌõ
,
µ«ÊÇ×Ðϸ¿´·¢ÏÖ£¬ÓкܶàËÆÊǶø·Ç»òÕß¹ýʱ
(
¿ÉÄܶÔ
SQL SERVER6.5
ÒÔǰµÄ°æ±¾»òÕß
ORACLE
ÊÇÊÊÓõÄ
)
µÄÐÅÏ¢£¬Ö»ºÃ×Ô¼º¸ù¾ÝÒÔǰµÄ¾­ÑéºÍ²âÊÔ½á¹û½øÐÐ×ܽáÁË¡£
ÎÒ ......

Sql Server »ù±¾º¯Êý

1.×Ö·û´®º¯Êý
³¤¶ÈÓë·ÖÎöÓÃ
datalength(Char_expr) ·µ»Ø×Ö·û´®°üº¬×Ö·ûÊý,µ«²»°üº¬ºóÃæµÄ¿Õ¸ñ
substring(expression,start,length) ²»¶à˵ÁË,È¡×Ó´®
right(char_expr,int_expr) ·µ»Ø×Ö·û´®ÓÒ±ßint_expr¸ö×Ö·û
×Ö·û²Ù×÷Àà
upper(char_expr) תΪ´óд
lower(char_expr) תΪСд
space(int_expr) Éú³Éint_expr¸ ......

sql °´ÕÕÈÎÒâ˳Ðò½øÐÐÅÅÐò

--´´½¨Ò»Õűí
create table stut
(
  id int,
  na varchar(20)
)
--²åÈë4ÌõÊý¾Ý¡£
insert into stut values(1,'aa')
insert into stut values(2,'bb')
insert into stut values(3,'df')
insert into stut values(4,'Öйú')
select * from stut
--¸ù¾Ý'df,aa,Öйú,bb'À´½øÐÐÅÅÐò
select * from stut ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ