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

¸öÈË×ܽáµÄ¼¸Ìõ±È½ÏÓÐÒâ˼µÄsqlÓï¾ä


 
--------------------------------------------------------------------
-- ×÷ÕߣºÕŰ®¹ú
-- ÈÕÆÚ£º2010-01-23 15:00:17
-- ÃèÊö: һЩ±È½ÏÓÐÒâ˼µÄSQLÓï¾ä
-- Version:
--    Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
--    Feb  9 2007 22:47:07
--    Copyright (c) 1988-2005 Microsoft Corporation
--    Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
--------------------------------------------------------------------
--Ê×ÏÈ´´½¨Ò»¸ö²âÊÔÓõıí
--Ò»ÏÂÓï¾äÖÐÓõ½µÄ±ítb¾ùÖ¸Õâ¸ö²âÊÔ±í
--1¡¢Äã²ÂÏÂÃæÕâÌõÓï¾äÄܵõ½Ê²Ã´½á¹û£¬Õâ¸öºÜ³£ÓÃ
if object_id('tb') is not null
drop table tb
go select getdate()
create table tb(id int identity ,name varchar(10))
insert into tb select 'ÕÅÈý'
union all select 'ÀîËÄ'
union all select 'ÍõÎå'
union all select 'ÕÔÁù'
go
select * into ta from tb where 1<>1
--2¡¢ÏÂÃæÕâÌõÓï¾ä»á±¨´íÂð£¿ÎªÊ²Ã´£¬ÔõôÐ޸IJÅÄÜÈÃËüÊä³ö “ÕýÈ·” ÕâÁ½¸ö×Ö
select case when 1>1 then 1
                        when 1=1 then 'ÕýÈ·'
                        when 1<1 then 2
                end
--3¡¢ Ôõô²ÅÄÜ×öµ½ÏÂÃæµÄÈýÌõͬʱִÐеõ½µÄ½á¹ûÊÇÃüÁîÒѳɹ¦Íê³É¡£
    --¶ø²»ÊÇselect¸½½üÓÐÓï·¨´íÎó
select
select 1
select
--4¡¢ ˼¿¼Ò»ÏÂÕâ¸öÎÊÌâ
--ÔÚmasterÖн¨¸ö±í£¬ÔÚÆäËü¿âÀï·ÃÎÊ(ͬһ·þÎñÆ÷)£¬²»ÔÊÐíʹÓÃÏÞ¶¨Ãû£¬ÈçºÎ²ÅÄÜÖ±½Ó·ÃÎÊ´Ë±í£¿
--5¡¢ datalength() ·µ»ØÓÃÓÚ±íʾÈκαí´ïʽµÄ×Ö½ÚÊý¡£
-- Äã²ÂÏÂÃæµÄ½á¹û»áÊÇʲô?Ϊʲô
select datalength('1'),datalength(1),datalength(getdate()),datalength('2010-01-23 13:01:37.280')
--6¡¢Äã¿ÉÒÔÊÔÊÔÏÂÃæµÄÈý¸öÓï¾ä£¬ÎªÊ²Ã´µÚÒ»¸ö»áÓÐÓï·¨´íÎ󣬶øµÚ¶þ¸ö½á¹ûÊÇÕýÈ·µÄ
--¢ñ£º
select * from tb ord


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

¾­µäSQLÓï¾ä´óÈ«(ÊʺÏSQL SERVER)


ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡¡¡1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â ......

SQL ServerµÄ ÅÅÐò¹æÔò(collation)³åÍ»ºÍ½â¾ö·½°¸

ʲôÊÇÅÅÐò¹æÔò£¨collation£©
¹ØÓÚSQL ServerµÄÅÅÐò¹æÔò£¬¹À¼Æ´ó¼Ò¶¼²»Ä°Éú£¬ÔÚ´´½¨Êý¾Ý¿âʱÎÒÃǾ­³£ÒªÑ¡ÔñÒ»ÖÖÅÅÐò¹æÔò£¨conllation£©£¬Ò»°ãÎÒÃÇ»áÁôÒ⵽ÿһÖÖÓïÑÔµÄÅÅÐò¹æÔò¶¼ÓÐÐí¶àÖÖ£¬±ÈÈç±ê×¼´ó½¼òÌåÖÐÎÄChinese_PRCµÄÅÅÐò¹æÔò¾ÍÓÐÊýÊ®ÖÖÖ®¶à

ÕâЩÅÅÐò¹æÔòÓÐʲô×÷ÓÃÄØ£¿ÈÃÎÒÃÇÏÈÀ´¿´¿´MS¹Ù·½µÄ½âÊÍ£º
ÅÅÐò¹æÔ ......

access sql server Êý¾Ý¿â Êý¾Ýµ¼³ö

×òÌìŪÁËÒ»¸ö±È½Ï¼¬ÊÖµÄÎÊÌâ¡£´ÓÍøÉÏÏÂÔØÁËÒ»¸öÈí¼þ£¬ËûµÄÊý¾Ý¿âÊÇaccessµÄ£¬´ò¿ª¿´ÁËһϣ¬¸Ð¾õ²»´í£¬ÊʺÏÎÒÏÖÔÚÏîÄ¿µÄÐèÇ󣬴󲿷ÖÄܹ»Âú×ãÎÒµÄÏîÄ¿ÐèÒª£¬¾ÍÏëÄÃÀ´Ö÷Òå¡£¿ÉÊÇÎÒÃÇÏîÄ¿µÄÊý¾Ý¿âÒ»Ö±¶¼ÊÇÓõÄsqlserver£¬ÓÚÊÇ£¬¾ÍÔÚÍøÉÏ·è¿ñµÄ£¬ÕÒ¹ØÓÚaccessת»»ÎªsqlserverµÄ×ÊÁÏÔÚÕâÀïÎÒÏë˵һÏÂÓйصÄ×¢ÒâÊÂÏ
Êý¾Ý¿âÉý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ