ͨ¹ý·ÖÎöSQLÓï¾äµÄÖ´Ðмƻ®ÓÅ»¯SQL
Ç°ÑÔ
±¾ÎĵµÖ÷Òª½éÉÜÓëSQLµ÷ÕûÓйصÄÄÚÈÝ£¬ÄÚÈÝÉæ¼°¶à¸ö·½Ã棺SQLÓï¾äÖ´ÐеĹý³Ì¡¢ORACLEÓÅ»¯Æ÷£¬±íÖ®¼äµÄ¹ØÁª£¬ÈçºÎµÃµ½SQLÖ´Ðмƻ®£¬ÈçºÎ·Ö ÎöÖ´Ðмƻ®µÈÄÚÈÝ£¬´Ó¶øÓÉdzµ½ÉîµÄ·½Ê½Á˽âSQLÓÅ»¯µÄ¹ý³Ì£¬Ê¹´ó¼ÒÖð²½²½ÈëSQLµ÷ÕûÖ®ÃÅ£¬È»ºóÄ㽫·¢ÏÖ……¡£
¸ÃÎĵµµÄ²»µ±Ö®´¦£¬¾´ÇëÖ¸³ö£¬ÒÔ±ã½øÒ»²½¸ÄÕý¡£Ç뽫Æä·¢ÍùÎÒµÄÐÅÏ䣺xu_yu_jin2000@sina.com¡£
Èç¹ûÒýÓñ¾ÎĵÄÄÚÈÝ£¬ÇëÖøÃû³ö´¦£¡
×÷ÕߣºÐìÓñ½ð
MSN£ºsunny_xyj@hotmail.com
Email: xu_yu_jin2000@sina.com
&
Ïà¹ØÎĵµ£º
----start
SQL(Structured Query Language)£¬Ò²¾ÍÊǽṹ»¯²éѯÓïÑÔ£¬Ëü±»Éè¼ÆÓÃÀ´²Ù×÷¼¯ºÏµÄ£¬ÊǷǹý³Ì»¯µÄÓïÑÔ¡£Ëæ×ÅÓ¦ÓóÌÐòµÄ·¢Õ¹£¬ÒµÎñÂß¼Ô½À´Ô½¸´ÔÓ£¬´«Í³µÄSQLÒѾ²»ÄÜÂú×ãÈËÃǵÄÒªÇó£¬ÓÚÊÇÈËÃǶÔSQL½øÐÐÁËÀ©Õ¹£¬Ê¹Ëü¾ßÓÐÁ˹ý³Ì»¯µÄÂß¼£¬¼´£ºSQL PL¡£SQL PLµÄÈ«³ÆÊÇ SQL Procedural Language£ ......
×ÜÓû§±í:select count(*) ×ܱíÊý from sysobjects where xtype='u'
×ÜÓû§±íºÍϵͳ±í:select count(*) ×ܱíÊý from sysobjects where xtype in('u','s')
×ÜÊÓͼÊý:select count(*) ×ÜÊÓͼÊý from sysobjects where xtype='v'
×Ü´æ´¢¹ý³ÌÊý:select count(*) ×Ü´æ´¢¹ý³ÌÊý from sysobjects where xtype='p'
×Ü´¥·¢Æ÷Êý:s ......
SQL ServerÀïµÄ ISNULL Óë Oracle ÖÐµÄ NULLIF²»Í¬:
SQL Server ÖÐÓÐÁ½¸ö²ÎÊý£¬Óï·¨£º
ISNULL(check_expression, replacement_value)
check_expression Óë replacement_value Êý¾ÝÀàÐͱØÐëÒ»ÖÂ
Èç¹û check_expression Ϊ NULL£¬Ôò·µ»Ø replacement_v ......
¹Ì¶¨³¤¶È(char)Óë¿É±ä³¤¶È(varchar)×Ö·ûÊý¾ÝÀàÐÍ
char[(n)]
³¤¶ÈΪn¸ö×ֽڵĹ̶¨³¤¶ÈÇÒ·ÇUnicodeµÄ×Ö·ûÊý¾Ý¡£n±ØÐëÊÇÒ»¸ö½éÓÚ1ºÍ8,000Ö®¼äµÄÊýÖµ¡£´æ´¢´óСΪn¸ö×Ö½Ú¡£charÔÚSQL-92ÖеÄͬÒå´ÊΪcharacter¡£
varchar[(n)]
³¤¶ÈΪn¸ö×ֽڵĿɱ䳤¶ÈÇÒ·ÇUnicodeµÄ×Ö·ûÊý¾Ý¡£n±ØÐëÊÇÒ»¸ö½éÓÚ1ºÍ8,000Ö®¼äµÄÊýÖµ¡£´æ´¢´óСΪ ......
--Èç¹ûÊÇʵ±í¿ÉÒÔÓÃ
if exists (select * from sysobjects where id = object_id(N'[dbo].[±íÃû]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[±íÃû]
--Èç¹ûÊÇÁÙʱ±í¿ÉÒÔÓÃ(˵Ã÷,Èç¹ûÓòéÕÒʵ±í·½·¨À´´òÁÙʱ±í»áÕÒ²»µ½.·¢²¼Çø±ð¶Ô´ú.)
if object_id('tempdb..##temp') is not null
......