³¹µ×Çå³ýSQL SERVERÊý¾Ý¿â
ÔÚ¸ø¸÷ºÏ×÷ѧУ°²×°Ó¦ÓÃϵͳ¹ý³ÌÖУ¬·¢ÏÖѧУÀïµÄSQL SERVER 2000Êý¾Ý¿âËð»µÁËÖØ×°ºó¶¼·¢ÉúÁËͬÑùµÄÎÊÌ⣬ÄǾÍÊÇ°²×°SQL SERVERÊý¾Ý¿â²»³É¹¦¡£ÔÒò£º¼´Ê¹Äãͨ¹ý¿ØÖÆÃæ°åÀïµÄ“Ìí¼Ó/ɾ³ý³ÌÐò” Õý³£µÄжÔØSQL SERVERÊý¾Ý¿â£¬µ«ÊÇ£¬SQL SERVER»¹ÊÇûÓÐÍêȫжÔظɾ»£¬»¹ÐèÒªÊÖ¹¤½øÐÐһЩ²Ù×÷¡£Òò´ËÖØа²×°²»³É¹¦£¬ºÜ¶àÈËÖ»ºÃÖØװϵͳ½â¾ö¡£¾¹ý½Ï³¤Ê±¼äµÄÃþË÷ºÍʵ¼ù×ܽᣬÎÒÕÒµ½ÁËÒ»µã¼¼ÇÉ·½·¨£¬ÔÚÕâÀïÓë´ó¼Ò·ÖÏí¡£
²Ù×÷²½Ö裺
ÔÚ½øÐвÙ×÷֮ǰ£¬½¨Ò鱸·ÝºÃ×¢²á±íÒÔ¼°ÖØÒªµÄÊý¾Ý¿âÎļþ¡£
Ê×ÏÈ£¬ÎÒÃdz¢ÊÔÓÃIsUninst.exeжÔسÌÐòÀ´°²È«Ð¶ÔØWindowsÖеijÌÐòºÍÓëÆäÏà¹ØµÄ×é¼þ£º
£¨1£©ÔËÐÐRegedit.exe,È»ºóÕÒµ½ÒÔÏÂ×¢²á±íÏ
HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\windows\CurrentVersion\Uninstall
£¨2£©UninstallÏîÏ£¬ÕÒµ½ÒªÉ¾³ýµÄMicrosoft SQL Server2000 ʵÀýµÄ²úÆ·´úÂë¡£
£¨3£©ÔÚÈÎÎñÀ¸ÉÏ£¬µ¥»÷¡¾¿ªÊ¼¡¿°´Å¥£¬È»ºóµ¥»÷¡¾ÔËÐС¿°´Å¥¡£ÔÚÔËÐжԻ°¿òÖУ¬¸´ÖƲ¢Õ³ÌùÒÔÏÂÃüÁÀýÈ磺
C:\WINNT\IsUninst.exe-f “C:\Program Files\Microsoft SQL Server\MSSQL¡çServer1\Uninst.is”
-c”C:\Program Files\Microsoft SQL Server\MSSQL¡çServer1\sqlsun.dll”-Mssql.miff I=Il
ÆäÖУºMSSQL Serverl±íʾ°²×°µÄʵÀýÃûΪServerl¡£
Èç¹ûÒÔÉÏ·½·¨²»×àЧ£¬ÔòÎÒÃDZØÐëÊÖ¹¤À´½øÐÐɾ³ý²Ù×÷¡£
£¨1£© ɾ³ýÒÔÏÂ×¢²á±í×ÓÏ
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ Microsoft SQL Server
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVER AGENT
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services \MSSQLServerADHelper
£¨2£© ÊÖ¹¤É¾³ý°²×°Ä¿Â¼£¬Ä¬ÈÏÇé¿öÏÂλÓÚ£º
C:\Program Files\Microsoft SQL Server
£¨3£© жÔØMicrosoft Search ·þÎñ£¬»¹ÐèҪɾ³ý£º
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search
£¨4£© жÔØMicrosoft È«ÎIJéѯ£¬»¹ÐèҪɾ³ý£º
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSFTPSVC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSCNTRS
HKE
Ïà¹ØÎĵµ£º
ÈçºÎÉú³Éexplain plan?
¡¡¡¡½â´ð:ÔËÐÐutlxplan.sql. ½¨Á¢plan ±í
¡¡¡¡Õë¶ÔÌض¨SQLÓï¾ä£¬Ê¹Óà explain plan set statement_id = 'tst1' into plan_table
¡¡¡¡ÔËÐÐutlxplp.sql »ò utlxpls.sql²ì¿´explain plan
EXPLAIN PLAN ÊÇÒ»¸öºÜºÃµÄ·ÖÎöSQLÓï¾äµÄ¹¤¾ß,ËüÉõÖÁ¿ÉÒÔÔÚ²»Ö´ÐÐSQLµÄÇé¿öÏ·ÖÎöÓï¾ä. ͨ¹ý·ÖÎö,ÎÒÃǾͿÉÒÔÖ ......
SQL *PLUS RepostµÄ¿ª·¢·½·¨
ʹÓÃSQL*PLUS ¿ÉÖ±½ÓÔÚIE BrowserÖÐÉú³É¹æÕûµÄ×Ö·ûÐÍReport. ʵÏÖ·½·¨¼òµ¥£¬²¼ÊðÈÝÒס£
·½·¨:
1. ÀûÓÃÎı¾±à¼Æ÷±àдSQL*PLUS ½Å±¾£¬±£´æ³É .sql Îļþ¡£
2. ÉÏ´«sql ÎļþÖÁÓ¦ÓõÄsql Ŀ¼¡£
3.  ......
CREATE FUNCTION StringToBarcode
(@Value Varchar(50) )
RETURNS NVarchar(100)
AS
BEGIN
Declare @charCount int
Declare @charPos int, @minCharPos int
declare @currentChar int, @checksum int
Declare @isTableB int,@isValid int
&n ......
Ò»¸öʾÀýËÀËø
ÈÃÎÒÃÇ´ÓÕâÑùÒ»¸öʾÀý¿ªÊ¼ËµÆð£¬ËüÔÚ SQL Server 2000 ºÍ 2005 Öж¼ÄÜÒýÆðËÀËø¡£ÔÚ±¾ÎÄÖУ¬ÎÒʹÓà SQL Server 2005 µÄ×îРCTP£¨ÉçÇø¼¼ÊõÔ¤ÀÀ£¬Community Technology Preview£©°æ±¾£¬SQL Server 2005 Beta 2£¨7 Ô·¢²¼£©Ò²Í¬ÑùÊÊÓá£Èç¹ûÄúûÓÐ Beta 2 »ò×îÐ嵀 CTP °æ±¾£¬ÇëÏÂÔØ SQL Server 2005 Express µÄ ......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Collections;
using System.Data.SqlClient;
/// <summary>
/// Êý¾Ý¿âµÄͨÓ÷ÃÎÊ´úÂë
/// ´ËÀàΪ³éÏóÀ࣬²»ÔÊÐíʵÀý»¯£¬ÔÚÓ¦ÓÃʱֱ½Óµ÷Óü´¿É
/// </summary>
public ab ......