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

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

¡¡¡¡µ±Ö´ÐÐÒ»ÌõDMLÓï¾äºó£¬DMLÓï¾äµÄ½á¹û±£´æÔÚËĸöÓαêÊôÐÔÖУ¬ÕâЩÊôÐÔÓÃÓÚ¿ØÖƳÌÐòÁ÷³Ì»òÕßÁ˽â³ÌÐòµÄ״̬¡£µ±ÔËÐÐDMLÓï¾äʱ£¬PL/SQL´ò¿ªÒ»¸öÄÚ½¨Óα겢´¦Àí½á¹û£¬ÓαêÊÇά»¤²éѯ½á¹ûµÄÄÚ´æÖеÄÒ»¸öÇøÓò£¬ÓαêÔÚÔËÐÐDMLÓï¾äʱ´ò¿ª£¬Íê³Éºó¹Ø±Õ¡£ÒþʽÓαêֻʹÓÃSQL%FOUND,SQL%NOTFOUND,SQL%ROWCOUNTÈý¸öÊôÐÔ.SQL%FOUND,SQL%NOTFOUNDÊDz¼¶ûÖµ£¬SQL%ROWCOUNTÊÇÕûÊýÖµ¡£
¡¡¡¡SQL%FOUNDºÍSQL%NOTFOUND
¡¡¡¡ÔÚÖ´ÐÐÈκÎDMLÓï¾äÇ°SQL%FOUNDºÍSQL%NOTFOUNDµÄÖµ¶¼ÊÇNULL,ÔÚÖ´ÐÐDMLÓï¾äºó£¬SQL%FOUNDµÄÊôÐÔÖµ½«ÊÇ£º
¡¡¡¡. TRUE :INSERT
¡¡¡¡. TRUE :DELETEºÍUPDATE£¬ÖÁÉÙÓÐÒ»Ðб»DELETE»òUPDATE.
¡¡¡¡. TRUE :SELECT INTOÖÁÉÙ·µ»ØÒ»ÐÐ
¡¡¡¡µ±SQL%FOUNDΪTRUEʱ,SQL%NOTFOUNDΪFALSE¡£
¡¡¡¡SQL%ROWCOUNT
¡¡¡¡ÔÚÖ´ÐÐÈκÎDMLÓï¾ä֮ǰ£¬SQL%ROWCOUNTµÄÖµ¶¼ÊÇNULL,¶ÔÓÚSELECT INTOÓï¾ä£¬Èç¹ûÖ´Ðгɹ¦£¬SQL%ROWCOUNTµÄֵΪ1,Èç¹ûûÓгɹ¦£¬SQL%ROWCOUNTµÄֵΪ0£¬Í¬Ê±²úÉúÒ»¸öÒì³£NO_DATA_FOUND.
¡¡¡¡SQL%ISOPEN
¡¡¡¡SQL%ISOPENÊÇÒ»¸ö²¼¶ûÖµ£¬Èç¹ûÓαê´ò¿ª£¬ÔòΪTRUE, Èç¹ûÓαê¹Ø±Õ£¬ÔòΪFALSE.¶ÔÓÚÒþʽÓαê¶øÑÔSQL%ISOPEN×ÜÊÇFALSE£¬ÕâÊÇÒòΪÒþʽÓαêÔÚDMLÓï¾äÖ´ÐÐʱ´ò¿ª£¬½áÊøʱ¾ÍÁ¢¼´¹Ø±Õ¡£


Ïà¹ØÎĵµ£º

SQLÓï¾ä ´´½¨Ë÷Òý

Óï·¨£º
CREATE [Ë÷ÒýÀàÐÍ] INDEX Ë÷ÒýÃû³Æ
ON ±íÃû(ÁÐÃû)
WITH FILLFACTOR = Ìî³äÒò×ÓÖµ0~100
GO
/*ʵÀý*/
USE ¿âÃû
GO
IF EXISTS
(SELECT * from SYSINDEXES WHERE NAME='IX_TEST_TNAME')--¼ì²âÊÇ·ñÒѾ­´æÔÚIX_TEST_TNAMEË÷Òý
DROP INDEX
TEST.IX_TEST_TNAME--Èç¹û´æÔÚÔòɾ³ý
--´´½¨Ë÷Òý
CREATE NONCLUSTER ......

c# ²Ù×÷mssqlÊý¾Ý¿â º¬Óдø²ÎÊýsqlÓï¾äÔËÐÐ

<?xml version="1.0" encoding="utf-8"?>
<configuration>
 <appSettings>
  <add key="Default" value="Default" />
 </appSettings>
 <connectionStrings>
  <add name="Default" connectionString="Data Source=192.168.1.197;User ID ......

ÅäÖÃODBCÁ¬²»ÉÏSQL ServerµÄ½â¾ö·½·¨

1¡¢¸ÃÓû§ÓеǼȨÏÞ¡£
2¡¢ServerÈç¹û¿ªÁËFirewall£¬ÔÚexceptionsÀïÌí¼Ó1433 port ¡£
3¡¢ÅäÖù¤¾ß->SQL ServerÍâΧӦÓÃÅäÖÃÆ÷->·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷->´ò¿ªMSSQLSERVER½ÚµãÏ嵀 Database Engine ½Úµã£¬Ñ¡Ôñ“Ô¶³ÌÁ¬½Ó”£¬½ÓϽ¨ÒéÑ¡Ôñ"ͬʱʹÓÃTCP/IPºÍnamed pipes"£¬È·¶¨ºó£¬ÖØÆôÊý¾Ý¿â·þÎñºó ......

SQLÖÐ CAST Óë CONVERTת»¯º¯ÊýµÄÓ÷¨

 ½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£CAST ºÍ CONVERT ÌṩÏàËƵŦÄÜ¡£
Óï·¨
ʹÓà CAST£º
CAST ( expression AS data_type )
ʹÓà CONVERT£º
CONVERT (data_type[(length)], expression [, style])
²ÎÊý
expression
ÊÇÈκÎÓÐЧµÄ Microsoft® SQL Server™ ±í´ïʽ¡£Óйظü¶àÐÅÏ¢£¬Çë² ......

¹ØÓÚsql server ´úÀí£¨ÒѽûÓôúÀíxp£©

Ö¢×´£º
SQL SERVER2005ÀïÃ棬Æô¶¯SQL´úÀí·þÎñ£¬Æô¶¯Õý³££¬µ«ÊÇÔÚsql server ´úÀí»¹ÊÇÏÔʾÒѽûÓôúÀí xp
ÔÚManagement StudioÖÐн¨Î¬»¤¼Æ»®Ê±£¬ÌáʾÒÔÏ´íÎóÐÅÏ¢£º
“´úÀíXP”×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö±»¹Ø±Õ¡£ÏµÍ³¹ÜÀíÔ±¿ÉÒÔʹÓÃsp_configureÀ´ÆôÓÓ´úÀíXP”¡£ÓйØÆôÓÓ´úÀíXP ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ