Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Sql ServerÖÐÈçºÎÅжϱí»òÕßÊý¾Ý¿âµÄ´æÔÚ

sql serverÖÐÈçºÎÅжϱí»òÕßÊý¾Ý¿âµÄ´æÔÚ£¬µ«ÔÚʵ¼ÊʹÓÃÖУ¬ÐèÅжÏStatus״̬λ£º
ÆäÖÐijЩ״̬λ¿ÉÓÉÓû§Ê¹Óà sp_dboption£¨read only¡¢dbo use only¡¢single user µÈ£©½øÐÐÉèÖãº
1 = autoclose£»Ê¹Óà sp_dboption ÉèÖᣠÊý¾Ý¿âÍêÈ«¹Ø±Õ£¬Æä×ÊÔ´ÔÚ×îºóÒ»¸öÓû§×¢ÏúºóÊÍ·Å¡£
4 = select into/bulkcopy£»Ê¹Óà sp_dboption ÉèÖá£ÔÊÐíʹÓà Select INTO Óï¾äºÍ¿ìËÙ´óÈÝÁ¿¸´ÖÆ¡£
8 = trunc. log on chkpt£»Ê¹Óà sp_dboption ÉèÖá£Èç¹ûÊý¾Ý¿â´¦ÓÚÈÕÖ¾½Ø¶Ïģʽ£¬Ôò¼ì²éµã½«½Ø¶ÏÈÕÖ¾ÖзǻµÄ²¿·Ö¡£Ö»ÄÜΪ master Êý¾Ý¿âÉèÖôËÑ¡Ïî¡£16 = torn page detection£¬Ê¹Óà sp_dboption ÉèÖ᣿ÉÒÔ¼ì²â²Ðȱҳ¡£
32 = loading¡£
64 = pre recovery¡£
128 = recovering¡£
256 = not recovered¡£
512 = offline£»Ê¹ÓÃsp_dboption ÉèÖá£Êý¾Ý¿â½«´¦ÓÚÍÑ»ú״̬¡£
1024 = read only£»Ê¹Óà sp_dboption ÉèÖá£Óû§½öÄܶÁÈ¡Êý¾Ý¿âÖеÄÊý¾Ý¶øÎÞ·¨¶ÔÆä½øÐÐÐ޸ġ£
2048 = dbo use only£»Ê¹ÓÃsp_dboption ÉèÖá£Ö»ÓÐÊý¾Ý¿âËùÓÐÕß¿ÉÒÔʹÓÃÊý¾Ý¿â¡£
4096 = single user£»Ê¹Óà sp_dboption ÉèÖá£Ã¿´ÎÖ»ÄÜÓÐÒ»¸öÓû§·ÃÎÊÊý¾Ý¿â¡£
32768 = emergency mode¡£
4194304 = autoshrink¡£
1073741824 = cleanly shutdown¡£
¿ÉÒÔͬʱ´ò¿ª¶à¸öλ¡£
Æ©È磺ÅжÏÒ»¸öÊý¾Ý¿âÊÇ·ñoffline
select * from master.dbo.sysdatabases where name='pubs' and status<>512
sql serverÖÐÅжϱí¶ÔÏóÊÇ·ñ´æÔÚ£º
select count(*) from sysobjects where id = object_id('Êý¾Ý¿âÃû.Owner.±íÃû')
if exists
(select count(*) from sysobjects where id = object_id('Êý¾Ý¿âÃû.Owner.±íÃû'))
print '´æÔÚ'
else
print '²»´æÔÚ'
sql serverÖÐÅжϱíÖÐ×Ö¶ÎÊÇ·ñ´æÔÚ£º
if exists(select * from syscolumns where name='colname1' and id=object_id('Êý¾Ý¿âÃû.Owner.±íÃû'))
print '´æÔÚ'
else
print '²»´æÔÚ'
´ú±í±ítablename1ÖдæÔÚcolname1×Ö¶Î
Àý£º
select * from syscolumns where name='Test' and id=object_id('dbo.test')
AccessÖÐÅжϱí¶ÔÏóÊÇ·ñ´æÔÚ£º
Æäʵ£¬AccessÊý¾Ý¿âÒ²ÓÐϵͳ±í£¬´æ·ÅÓжÔÏóÃû
Select Count(*) AS Qty from MSysObjects Where ((MSysObjects.Name) Like '±íÃû');
ÅжÏÊý¾Ý¿âºÍ±íÊÇ·ñ´æÔÚ 
if not exists(select 1 from master.dbo.sysdatabases where name=N'JZKStarCfg')


Ïà¹ØÎĵµ£º

ÓαêÊôÐÔSQL%FOUND,SQL%NOTFOUND,SQL%ROWCOUNT

¡¡¡¡µ±Ö´ÐÐÒ»ÌõDMLÓï¾äºó£¬DMLÓï¾äµÄ½á¹û±£´æÔÚËĸöÓαêÊôÐÔÖУ¬ÕâЩÊôÐÔÓÃÓÚ¿ØÖƳÌÐòÁ÷³Ì»òÕßÁ˽â³ÌÐòµÄ״̬¡£µ±ÔËÐÐDMLÓï¾äʱ£¬PL/SQL´ò¿ªÒ»¸öÄÚ½¨Óα겢´¦Àí½á¹û£¬ÓαêÊÇά»¤²éѯ½á¹ûµÄÄÚ´æÖеÄÒ»¸öÇøÓò£¬ÓαêÔÚÔËÐÐDMLÓï¾äʱ´ò¿ª£¬Íê³Éºó¹Ø±Õ¡£ÒþʽÓαêֻʹÓÃSQL%FOUND,SQL%NOTFOUND,SQL%ROWCOUNTÈý¸öÊôÐÔ.SQL%FOUND,SQ ......

.netÁ¬½ÓÊý¾Ý¿â£¬Ö´ÐÐsql½Å±¾

1¡¢¶¨ÒåÖ¸Á£ºusing System.Data.SqlClient;
2¡¢¶¨ÒåsqlÁ¬½Ó£º SqlConnection conn= new SqlConnection("server=(local);database=colorring;uid=sa;pwd=;");
3¡¢´ò¿ªsqlÁ¬½Ó£º conn.Open();
4¡¢¶¨ÒåsqlÓï¾ä£ºstring sqlstr = "insert into test values (123321)";
5¡¢×é×°sqlÓï¾äºÍÁ¬½Ó£ºSqlCommand cmd = new SqlCo ......

SQLÓï¾ä²éѯÊÇ·ñΪ¿Õ =null¼°null

  a                  b                             c&nb ......

.net³ÌÐòÔ±ËùÐèÕÆÎÕµÄsql£¬»ù±¾¼¼ÇÉ(2)

1. ¼òÊö private¡¢ protected¡¢ public¡¢ internal ÐÞÊηûµÄ·ÃÎÊȨÏÞ¡£
´ð . private :  ˽ÓгÉÔ±, ÔÚÀàµÄÄÚ²¿²Å¿ÉÒÔ·ÃÎÊ¡£
    protected : ±£»¤³ÉÔ±£¬¸ÃÀàÄÚ²¿ºÍ¼Ì³ÐÀàÖпÉÒÔ·ÃÎÊ¡£
    public :    ¹«¹²³ÉÔ±£¬ÍêÈ«¹«¿ª£¬Ã»ÓзÃÎÊÏÞÖÆ¡£
    internal:  ÔÚÍ¬Ò ......

C#ÖвÙ×÷OracleʱµÄSQLÓï¾ä²ÎÊýµÄÓ÷¨

C#ÖвÙ×÷OracleʱµÄSQLÓï¾ä²ÎÊýµÄÓ÷¨
OracleTransaction myTrans ;
            conn.Open();
            myTrans =conn.BeginTransaction(IsolationLevel.ReadCommitted) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ