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

SQL»ñÈ¡ËùÓÐÊý¾Ý¿âÃû¡¢±íÃû¡¢´¢´æ¹ý³ÌÒÔ¼°²ÎÊýÁбí

SQL»ñÈ¡ËùÓÐÊý¾Ý¿âÃû¡¢±íÃû¡¢´¢´æ¹ý³ÌÒÔ¼°²ÎÊýÁбí
1.»ñÈ¡ËùÓÐÊý¾Ý¿âÃû:
   (1)¡¢Select Name from Master..SysDatabases order by Name
2.»ñÈ¡ËùÓбíÃû:
   (1)¡¢Select Name from SysObjects Where XType=''U'' orDER BY Name
           XType=''U'':±íʾËùÓÐÓû§±í;
           XType=''S'':±íʾËùÓÐϵͳ±í;
   (2)¡¢SELECT name from sysobjects WHERE type = ''U'' AND sysstat = ''83''
           ×¢Ò⣺һ°ãÇé¿öÖ»ÐèÒªtype = ''U''£¬µ«ÓÐʱºò»áÓÐϵͳ±í»ìÔÚÆäÖУ¨²»ÖªµÀʲôԭÒò£©£¬¼ÓÉϺóÃæÒ»¾äºó¾ÍÄÜɾ³ýÕâЩϵͳ±íÁË
3.»ñÈ¡ËùÓÐ×Ö¶ÎÃû:
(1)¡¢Select Name from SysColumns Where id=Object_Id(''TableName'')
(2)¡¢SELECT syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length from syscolumns, systypes WHERE syscolumns.xusertype = systypes.xusertype AND "syscolumns.id = object_id(''tableName'')
       ×¢Òâµã£º
     £¨a£©ÕâÀïΪÁËÖصãÍ»³öijЩÖØÒªÄÚÈÝ£¬Ñ¡È¡ÁËÆäÖм¸ÏîÐÅÏ¢Êä³ö¡£
     £¨b£©syscolumns±íÖÐÖ»º¬ÓÐÊý¾ÝÀàÐͱàºÅ£¬Òª»ñÈ¡ÍêÕûµÄÃû×ÖÐèÒª´Ósystypes±íÖÐÕÒ£¬Ò»°ãÓû§Ê¹ÓõÄÊý¾ÝÀàÐÍÓÃxusertype¶ÔÓ¦±È½ÏºÃ£¬²»»á³öÏÖÒ»¶Ô¶àµÄÇé¿ö¡£
     £¨c£©syscolumns.lengthµÃµ½µÄÊÇÎïÀíÄÚ´æµÄ³¤¶È£¬ËùÒÔnvarcharºÍvarcharµÈÀàÐÍÔÚÊý¾Ý¿âÖеÄÏÔʾÊÇÕâ¸öµÄÒ»°ë¡£
4¡¢µÃµ½±íÖÐÖ÷¼üËù°üº¬µÄÁÐÃû:
    SELECT syscolumns.name from syscolumns,sysobjects,sysindexes,sysindexkeys WHERE syscolumns.id = object_id(''tablename'') AND sysobjects.xtype = ''PK'' AND sysobjects.parent_obj = syscolumns.id AND sysindexes.id = syscolumns.id AND sysobjects.name = sysindexes.name AND sysindexkeys.id = syscolumns.id AND sysindexkeys.indid = sysindexes.indid AND syscolumns.colid = sysindexkeys.colid
×¢Ò⣺ÕâÊÇÔÚ4ÕÅϵͳ±íÖÐÑ°Õҵģ¬¹Øϵ±È½Ï¸´ÔÓ£¬´óÖ¿ÉÒÔ±íʾΪ£º
syscolumnsÖдæÓбíÖеÄÁÐÐÅÏ¢ºÍ±íid£¬sysobjects±íÖдæÓÐÖ÷¼üÃû×Ö£¨¼´PK_TableÀàËÆ£©ºÍ±íid£¬sysindexesÖдæ ÓÐÖ÷¼üÃû×ֺͱíidºÍindex±àºÅ£¬sysi


Ïà¹ØÎĵµ£º

ÔÚlinuxÉÏÅäÖÃunixODBCºÍFreeTDS·ÃÎÊMS SQL Server.

Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓжÔÆäËü° ......

SqlÓï¾äѧϰ±Ê¼Ç(1) ´´½¨Êý¾Ý¿â

˵Ã÷£º´´½¨Ò»¸öÓ°µú×âÁÞ¹ÜÀíϵͳ£¬ÕâÀïÖ÷Òª³éÏóÁËËÄÕÅ±í£º
tb_user(Óû§ÐÅÏ¢),tb_movie_type£¨Ó°Æ¬ÀàÐÍ£©,tb_movie£¨Ó°Æ¬ÐÅÏ¢£©,tb_retal£¨×âÁ޼Ǽ£©
use master--ϵͳ±í£¬ËùÓд´½¨µÄÊý¾Ý¿â¾ùÔڴ˱»¼Ç¼
go
--¼ì²âÊÇ·ñÒѾ­´æÔÚRetaDBÕâ¸öÊý¾Ý¿â£¬ÓеĻ°£¬²»ÄÜÖØÃû£¬¿ÉÒÔ½øÐÐɾ³ý
if exists (select * from sysdatabas ......

SqlÓï¾äѧϰ±Ê¼Ç(3) ²åÈëÊý¾Ý

ÕâÀïʹÓõÄÊý¾Ý¿âºÍÊý¾Ý±í·Ö±ðÀ´×ÔSqlÓï¾äѧϰ±Ê¼Ç£¨1£©——´´½¨Êý¾Ý¿âºÍSqlÓï¾äѧϰ±Ê¼Ç£¨2£©——´´½¨Êý¾Ý±í
use RetalDB
go
--²åÈëÊý¾Ýµ½±ítb_movie_type
insert tb_movie_type values(0,'ÆÕͨƬ','Regular')
insert tb_movie_type values(1,'ÐÂƬ','NewRelease')
insert tb_movie_type values ......

SqlÓï¾äѧϰ±Ê¼Ç(4) ²éѯ1

ÕâÀïʹÓõÄÊý¾Ý¿âºÍÊý¾Ý±í·Ö±ðÀ´×ÔSqlÓï¾äѧϰ±Ê¼Ç£¨1£©——´´½¨Êý¾Ý¿âºÍSqlÓï¾äѧϰ±Ê¼Ç£¨2£©——´´½¨Êý¾Ý±í
use RetalDB
/********************
µ¥±í²éѯ
*********************/
--²éѯtb_userÖеÄÊý¾Ý£ºÎÞÌõ¼þ²éѯ
--(1)
select * from tb_user--²éѯËùÓÐÐÅÏ¢
--(2)
select top 2 * from ......

IBatisNet SQL ServerµÄfloatÀàÐÍת»»Îªc# float³ö´í

½ñÌìдһ¸öÉÌÆ·µÄÐ޸ŦÄÜʱÓöµ½µÄÎÊÌâ
ÉÌÆ·ÖÐÖØÁ¿ weight µÄÊý¾Ý¿â(SQL Server2005)ÀàÐͶ¨ÒåΪ float
ÔÚmappings ÖÐת»»Îªc#ÀàÐ͵ÄÒ»¾äΪ
<result property="Goods_Weight" column="Goods_Weight" type="float" dbType="float"/>
°´Àí˵Õâ¸ö float ÊÇÒ»ÑùµÄ£¬×ª»»ÍêÈ«²»»á³öÏÖÎÊÌ⣬
ʵ¼Ê³ÌÐòÔËÐÐʱ£¬ÏµÍ³±¨´í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ