SQL Server 2005ÖÐÐÂÔöµÄ¹¦ÄÜÇ¿´óµÄ´°¿Úº¯Êý
ÔÎĵØÖ·£ºhttp://www.cnblogs.com/changhai0605/articles/1276319.html
OracleµÄÇë²Î¿¼£ºhttp://zonghl8006.blog.163.com/blog/static/4528311520083995931317/
1.¼ò½é£º
SQL Server 2005ÖÐÐÂÔöµÄ´°¿Úº¯Êý°ïÖúÄãѸËٲ鿴²»Í¬¼¶±ðµÄ¾ÛºÏ£¬Í¨¹ýËü¿ÉÒԷdz£·½±ãµØÀÛ¼Æ×ÜÊý¡¢Òƶ¯Æ½¾ùÖµ¡¢ÒÔ¼°Ö´ÐÐÆäËü¼ÆËã¡£
´°¿Úº¯Êý¹¦Äܷdz£Ç¿´ó£¬Ê¹ÓÃÆðÀ´Ò²Ê®·ÖÈÝÒס£¿ÉÒÔʹÓÃÕâ¸ö¼¼ÇÉÁ¢¼´µÃµ½´óÁ¿Í³¼ÆÖµ¡£
´°¿ÚÊÇÓû§Ö¸¶¨µÄÒ»×éÐС£ ¿ª´°º¯Êý¼ÆËã´Ó´°¿ÚÅÉÉúµÄ½á¹û¼¯Öи÷ÐеÄÖµ¡£
2.ÊÊÓ÷¶Î§£º
ÅÅÃû¿ª´°º¯ÊýºÍ¾ÛºÏ¿ª´°º¯Êý.
Ò²¾ÍÊÇ˵´°¿Úº¯ÊýÊǽáºÏÅÅÃû¿ª´°º¯Êý»òÕ߾ۺϿª´°º¯ÊýÒ»ÆðʹÓÃ
OVER×Ó¾äÇ°Ãæ±ØÐëÊÇÅÅÃûº¯Êý»òÕßÊǾۺϺ¯Êý
3.ÀýÌ⣺
--½¨Á¢¶©µ¥±í
create table SalesOrder(
OrderID int, --¶©µ¥id
OrderQty decimal(18,2) --ÊýÁ¿
)
go
--²åÈëÊý¾Ý
insert into SalesOrder
select 1,2.0
union all
select 1,1.0
union all
select 1,3.0
union all
select 2,6.0
union all
select 2,1.1
union all
select 3,8.0
union all
select 3,1.1
union all
select 3,7.0
go
--²éѯµÃÈçϽá¹û
select * from SalesOrder
go
OrderID OrderQty
----------- ------------
1 2.00
1 1.00
1 3.00
2 6.00
2 1.10
3 8.00
3 1.10
3 7.00
ÏÖÒªÇóÏÔʾ»ã×Ü×ÜÊý£¬Ã¿µ¥ËùÕ¼±ÈÀý£¬·Ö×é»ã×ÜÊý£¬Ã¿µ¥ÔÚ¸÷×éËùÕ¼±ÈÀý£¬ÒªÇó¸ñʽÈçÏ£º
OrderID OrderQty »ã×Ü Ã¿µ¥±ÈÀý ·Ö×é»ã×Ü Ã¿µ¥ÔÚ¸÷×é±ÈÀý
1 2.00 29.20
Ïà¹ØÎĵµ£º
select name from syscolumns where id in (select id from sysobjects where type = 'u' and name = 'ÏàÓ¦±íÃû')
ÓÃÒÔÉÏsqlÓï¾äÊäÈëÏàÓ¦±íÃû¾Í¿ÉÒԲ鵽±íµÄ×Ö¶ÎÃû£¬¶ÔÓ¦ºÃÊý¾Ý¿â ²éѯÊÇ·ñ´æÔڸñíÓï¾ä
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tb_cost]') and OBJECTPROPER ......
*
sql xml ÈëÃÅ:
--by jinjazz
--http://blog.csdn.net/jinjazz
1¡¢xml: ÄÜÈÏʶԪËØ¡¢ÊôÐÔºÍÖµ
2¡¢xpath: Ñ°Ö·ÓïÑÔ£¬ÀàËÆwind ......
½ñÌìºöÈ»ms sql2000µÄÆóÒµ¹ÜÀíÆ÷³ö´í£¬ËÑË÷ÁËÒ»ÏÂÕÒµ½Á˽â¾ö°ì·¨£¬¼Ç¼һÏ£¬·½±ãÈÕºó²éѯ
´íÎóÐÅÏ¢£º
---------------------------
Microsoft Management Console
---------------------------
MMC ²»ÄÜ´ò¿ªÎļþ C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC¡£
Õâ¿ÉÄÜÊÇ ......
ÏÖÔںܶàÍøÕ¾¶¼ÌṩÁËÕ¾ÄÚµÄËÑË÷¹¦ÄÜ£¬Óеĺܼòµ¥ÔÚSQLÓï¾äÀï¼ÓÒ»¸öÌõ¼þÈ磺where names like ‘%words%’¾Í¿ÉÒÔʵÏÖ×î»ù±¾µÄËÑË÷ÁË¡£
ÎÒÃÇÀ´¿´¿´¹¦ÄÜÇ¿´óÒ»µã£¬¸´ÔÓÒ»µãµÄËÑË÷ÊÇÈçºÎʵÏֵģ¨ÔÚSQL¡¡£Ó£Å£Ò£Ö£Å£Ò£²£°£°£¯£²£°£°£µÍ¨¹ý´æ´¢¹ý³ÌʵÏÖËÑË÷Ëã·¨£©¡£
ÎÒÃÇ ......
°²×°SQL Server2005 ÎÊÌâÐÅÏ¢£º
“SQL Server °²×°³ÌÐòÎÞ·¨»ñÈ¡ ASPNET ÕÊ»§µÄϵͳÕÊ»§ÐÅÏ¢”
½â¾ö°ì·¨£º
ÓÃaspnet_regiisʵÓù¤¾ßжÔغÍÖØа²×°Ò»Ï¾ͿÉÒÔÁË¡£
¾ßÌåµÄ²Ù×÷£º
1¡¢½øÈëCMD£º
C:\windows\microsoft.net\framework\v2.0.50727Îļþ¼ÐÏ£¬ÔËÐÐaspnet_regiis -uжÔØ
È»ºóÔËÐÐaspnet_regiis -i Ö ......