SQLÊý¾Ý¿âÁ¬½ÓÓï¾ä
Ò»°ãµÄÔ¶³Ì·ÃÎʵÄд³ÉÕâÑù£º
Data Source=IP;Initial Catalog=Êý¾Ý¿âÃû;UserID=Óû§Ãû;Password=ÃÜÂë
±¾µØ·ÃÎʵÄд³ÉÕâÑù£º
Data Source=(local);Initial Catalog=Êý¾Ý¿âÃû;UserID=Óû§Ãû;Password=ÃÜÂë
Èç¹ûÊDZ¾µØµÄ£¬Í¨¹ýwindows×é¼þÑéÖ¤µÄ£¨Ò²¾ÍÊÇûÓÐÓû§Ãû£¬ÃÜÂëµÄ£©Ð´³ÉÕâÑù£º
Data Source=(local);Initial Catalog=Êý¾Ý¿âÃû;Integrated Security=True
Èç¹û²»ÊÇĬÈϵÄʵÀý£¬¼ÙÈçʵÀýÃûÊÇSQLEXPRESS£¬Ð´³ÉÕâÑù£º
Data Source=(local)\SQLEXPRESS;Initial Catalog=Êý¾Ý¿âÃû;Integrated Security=True
ExecuteReader
¼òµ¥¸ßЧµÄ£¬µ¥ÏòÇ°µÄÊý¾Ý²éѯ¡£·µ»ØÒ»¸öSqlDataReader¶ÔÏó
ͨ³£ÓÃÓÚ¶ÁÈ¡Êý¾Ý
ExecuteNonQuery
·µ»ØÒ»¸öintÀàÐ͵ÄÖµ£¬·µ»ØÊý¾Ý¿âÖÐËùÓ°ÏìµÄÐÐÊý¡£
ÓÃÓÚ¶ÔÊý¾Ý¿âµÄ¸÷ÖÖ²Ù×÷
ExecuteScalar
·µ»Ø¶Á³ö½á¹ûµÄµÚÒ»ÐеÚÒ»ÁÐ
Ïà¹ØÎĵµ£º
Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
¡¡¡¡Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
¡¡¡¡Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
¡¡¡¡Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
¡¡¡¡Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
¡¡¡¡Select ......
±ÈÈçij¸öÊý¾Ý¿â϶ÔSQL SERVERµÄÊý¾Ý¿â½øÐÐÁËÿÌìµÄ±¸·Ý£¬ÏÖÔÚÒª±£Áô7ÌìÒÔÄڵģ¬ÆäËûµÄɾ³ýµô£¬ÓÃASP¿ÉÒÔʵÏÖÁË£¬µ«ÒªÓõ½filesystemobject£¬²»´óˬ
Ê×ÏÈдһ¸öjsÎļþclearDatabaseBackup£¬ÄÚÈÝÈçÏÂ
function deleteBackupFile(beforedays) {
var fso = new ActiveXObject ......
1.±íSYSOBJECTSÓÃÓÚÃèÊöÊý¾Ý¿âÖеĶÔÏó --±í¡¢ÊÓͼ¡¢´æ´¢¹ý³ÌµÈ
˵Ã÷£º¸Ã±íÏà¹Ø×ֶεĺ¬ÒåÈçÏ£º
¡¡¡¡SYSOBJECTS.name ¶ÔÏóÃû£¬È磺±íÃû£¬ÊÓͼÃû¡£
¡¡¡¡SYSOBJECTS.id ¶ÔÏóid¡£
¡¡¡¡SYSOBJECTS.type ¶ÔÏóÀàÐÍ£¨p´æ´¢¹ý³Ì£¬vÊÓͼ£¬sϵͳ±í£¬uÓû§±í£©¡£
ex:
......
ת×Ôhttp://www.tzwhx.com/newOperate/Html/3/31/311/16609.html
Óï·¨
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] }
[ WITH APPEND ]
......
2009-10-08 16:05
ʲôÊÇÊÓͼ
´ó¼Ò¶¼ÖªµÀ£¬ÎÒÃǹú¼ÒÏÖÔÚ“ÉñÆß”ÉÏÌìÁË¡£´ÓÃÀ¹úµÄÔÂÇòµÇÔ¿ªÊ¼£¬ÈËÀàÉÏÌì²»ÔÙÊÇÉñ»°¡£Ìý˵£¬ÔÚÃÀ¹ú£¬ÄãÖ»Òª³ö¼¸Ê®ÍòÃÀÔª£¬Äú¾Í¿ÉÒÔÉÏÒ»´ÎÔÂÇò½øÐÐÌ«¿ÕÂÃÐУ¬ËùÒÔ£¬ÎÒÃÇÏàÐÅ£ºÔÚ²»¾ÃµÄ½«À´£¬ÉÏÌìÂÃÐн«×ß½øÎÒÃÇ°ÙÐÕµÄÉú»î£¬ÄÇÊÇÒ»¼þ¶àôÐÂÏÊÉñÆæµÄÊÂÇé° ......