c#Æô¶¯Sql Server·þÎñ
³ÌÐòÆô¶¯Sql ServerÆäʵºÜ¼òµ¥
´úÂ룺
System.ServiceProcess.ServiceController myController =
new System.ServiceProcess.ServiceController("MSSQL$ACCP4444"); //·þÎñÃû³Æ ÕÒÁ˰ëÌì²ÅÕÒµ½£¬±¿ËÀÎÒÍêÁË¡£ÔÚ·þÎñÉÏÓÒ¼üÊôÐÔ£¬ÄÜ¿´µ½
if (myController.CanStop)
{ }
else
{
myController.Start();
}
//×¢ ÐèÒªÒýÓà System.ServiceProcess ÔÚÏîÄ¿->Ìí¼ÓÒýÓÃ->ÄÜÕÒµ½Õâ¸öÒýÓá£
Ïà¹ØÎĵµ£º
5.1 ÃÜÂë²ßÂÔ
¡¡¡¡ÓÉÓÚsql server²»Äܸü¸ÄsaÓû§Ãû³Æ£¬Ò²²»ÄÜɾ³ýÕâ¸ö³¬¼¶Óû§£¬ËùÒÔ£¬ÎÒÃDZØÐë¶ÔÕâ¸öÕʺŽøÐÐ×îÇ¿µÄ±£»¤£¬µ±È»£¬°üÀ¨Ê¹ÓÃÒ»¸ö·Ç³£Ç¿×³µÄÃÜÂ룬×îºÃ²»ÒªÔÚÊý¾Ý¿âÓ¦ÓÃÖÐʹÓÃsaÕʺš£Ð½¨Á¢Ò»¸öÓµÓÐÓësaÒ»ÑùȨÏ޵ij¬¼¶Óû§À´¹ÜÀíÊý¾Ý¿â¡£Í¬Ê±Ñø³É¶¨ÆÚÐÞ¸ÄÃÜÂëµÄºÃϰ¹ß¡£Êý¾Ý¿â¹ÜÀíÔ±Ó¦¸Ã¶¨ÆÚ²é¿´ÊÇ·ñÓв»·ûºÏ ......
1.oracle
sql = "SELECT column_name, data_type, data_length, nullable";
sql += " from user_tab_columns ";
sql += " where table_name='";
sql += $tableName;
sql += "'";
select * from user_tab_comments & ......
SQL Server 2000 µÄϵͳÊý¾Ý¿â
SQL Server 2000·þÎñÆ÷°²×°ºó»á½¨Á¢4ϵͳÊý¾Ý¿â¡£·Ö±ðÊÇmaster¡¢model¡¢msdb¡¢tempdb¡£
1¡¢masterÊý¾Ý¿â
masterÊý¾Ý¿âÊÇSQL Server 2000ÖÐ×îÖØÒªµÄÊý¾Ý¿â£¬¼Ç¼ÁËSQL Server 2000µÄ·þÎñÆ÷¼¶ÏµÍ³ÐÅÏ¢£¬°üÀ¨ËùÓÐÕË»§ºÍÃÜÂ룬´ÅÅ̿ռ䡢Îļþ·ÖÅäºÍʹÓá¢ÏµÍ³¼¶µÄÅäÖòÎÊý¡ ......
±í×¨Çø
--
¸´ÖÆ±í¼°Êý¾Ý£¨´Ó
userinfo
±í¸´ÖƵ½Ð±í
b
select
*
into
b
from
UserInfo
--
»ñÈ¡µ±Ç°Êý¾Ý¿âÖеÄËùÓÐÓû§±í
select * from sysobjects where xtype='U' and category=0
--
»ñȡijһ¸ö±íµÄËùÓÐ×Ö¶Î
......
ͨ³£Çé¿öÏ£¬SQL ServerÀïÃæµÄÉú³ÉSQL½Å±¾£¬Ö»»á°üº¬Êý¾Ý¿â¼°±íµÄ×ֶνṹ£¬¶ø²»»á°üº¬±íµÄÊý¾Ý£¬Ò²¾ÍÊÇSQL½Å±¾ÀïÃæÖ»ÓÐCreate database£¬Create table ÕâÑùµÄÓï¾ä£¬Ã»ÓÐinsert into¡£
ÒòΪSQL Server²¢²»°üº¬Õâ¸ö¹¦ÄÜ£¬Ö»ÄÜ¿¿µÚÈý·½µÄ´úÂëÁË¡£
ÒÔÏ´洢¹ý³Ì¿ÉÒÔʵÏÖ£º
CREATE PROCEDURE dbo.UspOutputData
@tablenam ......