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

sqlдËÀÊý¾Ý

ÈçºÎÓÃsqlдËÀÁ½ÐÐÊý¾Ý
Èç:
ÐÔ±ð
ÄÐ
Å®
ÇóÒ»sql
ʲô½ÐдËÀ£¿Ô¼ÊøÂð£¿



ÎÒµÄÀí½âÊÇ:
insert into ±í (ÐÔ±ð) values (ÄÐ)
insert into ±í (ÐÔ±ð) values (Å®)

²»ÖªµÀÊDz»ÊÇÕâ¸ö.

Õâ¸ö±í±¾À´²»´æÔÚ£¬ÒªÁÙʱ´´½¨.µ«ÔËÐÐÍêÒÔºó¾ÍûÁË.

Ô¼Êø¼ì²é£¿

ÓÃdeclare @t table(sex varchar(20))
insert into @t values('ÄÐ')
insert into @t values('Å®')


ÓÃÍê@tÖ±½Ó×Ô¶¯ÊÍ·ÅÁË



ÒýÓÃ
Õâ¸ö±í±¾À´²»´æÔÚ£¬ÒªÁÙʱ´´½¨.µ«ÔËÐÐÍêÒÔºó¾ÍûÁË.

±í±äÁ¿»òÁÙʱ±í¶¼ÐÐ



create temp table
a char(1) check ('ÄÐ', 'Å®')

select *
from (select 'ÄÐ' as ÐÔ±ð union select 'Å®') t

°ÑºìÉ«²¿·Öµ±Ò»¸ö±íÓü´¿É


лл¸÷λµÄ½â´ð.6Â¥ºÍ9Â¥µÄ»Ø´ðÊÇÕýÈ·µÄ¡£


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

¹ØÓÚSQL Server Mobile Edition - .NET¼¼Êõ / ASP.NET

¹ØÓÚSQL Server Mobile Edition
ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf
ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ