SQLSERVER·þÎñ Åú´¦ÀíÎļþ
»°Ëµ°³ÊǸöÀÁÈË¡£¡£¡£¡£
×°ÍêSQLSERVER2005 ÒòΪ¿ª»úºÜÂý ËùÒÔÄØ¾Í°Ñ¿ª»ú·þÎñ¸ã³ÉÊÖ¶¯µÄÁË
ÕâÑù¿ª»ú¿ìÁ˺ܶà
¿ÉÊÇÎÊÌâÒ²À´ÁË
ÿ´ÎÒªÓÃSqlServerµÄʱºòÒªÒ»¸öÒ»¸ö·þÎñÈ¥¿ªÆðÀ´ ¡£¡£¡£¡£
Âé·³°¡¡£¡£¡£¡£¡£
²»±È2000Óиö ¿ª¹ØµÄ³ÌÐò
ËùÒÔÉÏÍøÕÒÁËϽ̳Ì
×Ô¼ºÐ´¸öÅú´¦Àí ×Ô¶¯Æô¶¯·þÎñ
ÍÛ¹þ¹þ
ͻȻ¾õµÃ Ö»ÒªÓÐÍøÂç ÓïÑÔ²»ÊÇɶ´óµÄÕϰ
дÆðÀ´¶¼²î²»¶àѽ
ÍÛ¹þ¹þ
@echo off
echo ¿ªÆôSQLSERVER·þÎñ°´1
echo ¹Ø±ÕSQLSERVER·þÎñ°´2
set /p ans=
¡¡¡¡if %ans%==1 goto sta
¡¡¡¡if %ans%==2 goto sto
:sta
echo ×¼±¸¿ªÆô·þÎñ
net start SQLWriter
net start ReportServer
net start MsDtsServer
net start msftesql
net start SQLBrowser
net start MSSQLSERVEROLAPService
net start SQLSERVERAGENT
net start MSSQL$SQLEXPRESS
net start MSSQLSERVER
goto exit
:sto
echo ×¼±¸¹Ø±Õ·þÎñ
net stop SQLWriter
net stop ReportServer
net stop MsDtsServer
net stop msftesql
net stop SQLBrowser
net stop MSSQLSERVEROLAPService
net stop SQLSERVERAGENT
net stop MSSQL$SQLEXPRESS
net stop MSSQLSERVER
goto exit
:exit
echo over
Ïà¹ØÎĵµ£º
sqlserverÖУº
1 /*
2 1 * Description:¶ÔÊý¾Ý±í½øÐÐÐÐÁÐת»»
3 2 * Author:llf
4 3 * µ÷ÓÃ˵Ã÷£ºexec SP_RowChangeCol 'ѧÉú³É¼¨±í','ÐÕÃû','¿Î³Ì','·ÖÊý','desc',0,0,'where Äê¼¶=''Ò»Äê¼¶'''
& ......
ÔÚsqlserver2005ÏÂʹÓÃÏÂÃæÓï¾ä
WITH t AS (
SELECT ROW_NUMBER() OVER(ORDER BY id DESC) as row_number, id,ss
&nb ......
/***
ÓαêµÄʹÓÃ
½²ÁËÕâ¸ö¶àÓαêµÄÓŵ㣬ÏÖÔÚÎÒÃǾÍÇ××ÔÀ´½Ò¿ªÓαêµÄÉñÃØµÄÃæÉ´¡£
ʹÓÃÓαêµÄ˳Ðò£º ÉùÃûÓαꡢ´ò¿ªÓαꡢ¶ÁÈ¡Êý¾Ý¡¢¹Ø±ÕÓαꡢɾ³ýÓαꡣ
1.3.1ÉùÃ÷Óαê
×î¼òµ¥ÓαêÉùÃ÷£ºDECLARE <ÓαêÃû>CURSOR FOR<SELECTÓï¾ä>£»
ÆäÖÐselectÓï¾ä¿ÉÒÔÊǼòµ¥²éѯ£¬Ò²¿ÉÒÔÊǸ´ÔӵĽÓÁ¬²éѯºÍǶÌײéѯ
......
Author URL:http://www.cnblogs.com/xbf321/archive/2008/11/02/1325067.html
Microsoft URL:http://technet.microsoft.com/zh-cn/library/ms188001.aspx
ÕªÒª
1,EXECµÄʹÓÃ
2£¬sp_executesqlµÄʹÓÃ
MSSQLΪÎÒÃÇÌṩÁËÁ½ÖÖ¶¯Ì¬Ö´ÐÐSQLÓï¾äµÄÃüÁ·Ö±ðÊÇEXECºÍsp_executesql;ͨ³ ......