°²×°SQL Server 2005ÐÔÄܼàÊÓÆ÷¼ÆÊýÆ÷ÒªÇó (´íÎó)
ÊÖ¶¯ÉèÖüÆÊýÆ÷×¢²á±íÏîµÄÔöÁ¿ :
1.ÔÚ Microsoft Windows 2003 »ò Windows XP ×ÀÃæÉÏ£¬ÒÀ´Îµ¥»÷“¿ªÊ¼”¡¢“ÔËÐД£¬È»ºóÔÚ“´ò¿ª”ÖмüÈë regedit.exe£¬ÔÙµ¥»÷“È·¶¨”¡£ÔÚ Windows 2000 ÖУ¬Ê¹Óà regedt32.exe Æô¶¯×¢²á±í±à¼Æ÷¡£
2.¶¨Î»µ½ÒÔÏÂ×¢²á±íÏ
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]
"Last Counter"=dword:00000ed4 (5276)
"LastHelp"=dword:00000ed5 (5277)
3.ÉÏÒ»²½µÄ“Last Counter”Öµ (5276) ±ØÐëÓëÒÔÏÂ×¢²á±íÏîÖГPerflib\004”µÄ“Counter”ÏîµÄ×î´óֵƥÅ䣬²¢ÇÒÉÏÒ»²½µÄ“Last Help”Öµ (5277) ±ØÐëÓëÒÔÏÂ×¢²á±íÏîÖГPerflib\004”µÄ“Help”ÏîµÄ×î´óֵƥÅä¡£
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009]
×¢Òâ 009Öд洢µÄÊÇÓ¢Îİ汾µÄ¼ÆÊýÆ÷(Èç¹ûÄã°²×°µÄÊÇÓ¢ÎİæMicrosoft SQL Server2005ÔòÐÞ¸ÄPerflib\009)£¬004Öд洢µÄÊÇÖÐÎİ汾µÄ¼ÆÊýÆ÷(Èç¹ûÄã°²×°µÄÊÇÖÐÎİæMicrosoft SQL Server2005ÔòÐÞ¸ÄPerflib\004)¡£“Last Counter”ºÍ“Last Help”ÖµÊÇÓÉ Windows ¶¯Ì¬·ÖÅäµÄ£»ÕâÁ½¸öÖµ»áÒò¼ÆËã»úµÄ²»Í¬¶ø²»Í¬¡£
Ïà¹ØÎĵµ£º
ËäȻ˵ÎÒÃǾ¡Á¿ÔÚд³ÌÐòµÄʱºò¿ØÖƲåÈëµ½Êý¾Ý¿âµÄÊý¾Ý£¬¶ø²»ÒªÓÃÊý¾Ý¿âÈ¥ÅжÏÊý¾ÝµÄ¶Ô´í£¬µ«ÊÇÓÐʱºòΪÁË·½±ã»¹ÊÇÐèÒªÊý¾Ý¿â×ÔÉíµÄÈÝ´íÄÜÁ¦À´°ïÖúÎÒÃǴﵽĿµÄµÄ¡£¾ÙÀý˵Ã÷£º
´´½¨ÈçÏÂÊý¾Ý±í
CREATE TABLE `book` (
`id` int(11) default NULL,
`num` int(11) unsigned default NULL
) ENGINE=InnoDB DE ......
USE [rossic]
GO
/****** Object: StoredProcedure [dbo].[fn_GetLunar] Script Date: 02/23/2010 15:46:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[fn_GetLunar]   ......
MySQLÖÐÎIJο¼ÊÖ²á- 7 MySQL ÓïÑԲο¼
<!--
body { font-size: 9pt; }
a:hover{color:red;}
a.t1:visited{color:red;}
-->
¶ÔÓÚÿ¸öÀàÐÍÓµÓеÄÖµ·¶Î§ÒÔ¼°²¢ÇÒÖ¸¶¨ÈÕÆÚºÎʱ¼äÖµµÄÓÐЧ¸ñʽµÄÃèÊö¼û7.3.6 ÈÕÆÚºÍʱ¼äÀàÐÍ
¡£
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_col
µÄÖµÊÇÔÚ×îº ......
if object_id('tb') is not null drop table tb
go
create table tb([A] varchar(10),[B] int)
insert tb
select 'bcd',1 union all
select 'bcde',2 union all
select 'cd',3
go
¸öÈË·ÖÎöÕâµÀÌâµÄ˼·ÊÇ£º
ͨ¹ýSubstring() À´Ñ»··Ö¸î B ÁÐϵÄ×Ö·û´®¡£¡£
--ÏëµÃµ½µÄ½á¹û£º
/**
a b& ......