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Â¥µÄ»Ø´ðÊÇÕýÈ·µÄ¡£
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ' select cast(convert(numeric(18,2),1275674000000/100000000)as real) ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý select ²¿ÃÅ,ÐÕÃû from tb ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ XML code: <folder state="unchecked" label="È«²¿"> ¡¡¡¡ <folder state="unchecked&qu ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
¹ØÓÚSQL Server Mobile Edition ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......