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Êý¾Ý¿âÈÕÖ¾Îļþ
/*--ѹËõÊý¾Ý¿âµÄͨÓô洢¹ý³Ì
ÓÐÁ½ÖÖ·½·¨ Ò»ÊÇѹËõÈÕÖ¾£¬¶þÊÇɾ³ýÈÕÖ¾¡£
Ò»¡¢Ñ¹ËõÈÕÖ¾¼°Êý¾Ý¿âÎļþ´óС
ÒòΪҪ¶ÔÊý¾Ý¿â½øÐзÖÀë´¦Àí
ËùÒÔ´æ´¢¹ý³Ì²»ÄÜ´´½¨ÔÚ±»Ñ¹ËõµÄÊý¾Ý¿âÖÐ
/*--µ÷ÓÃʾÀý
exec p_compdb 'test'
--*/
use master --×¢Òâ,´Ë´æ´¢¹ý³ÌÒª½¨ÔÚmasterÊý¾Ý¿âÖÐ
go ......
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER trigger [dbo].[checkExamNo] on [dbo].[student]
for insert,update as
if exists(select examNo from student whe ......
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 CONVERT(varchar(100), GE ......
ΪÁË´ó¼Ò¸üÈÝÒ×Àí½âÎÒ¾Ù³öµÄSQLÓï¾ä£¬±¾Îļٶ¨ÒѾ½¨Á¢ÁËÒ»¸öѧÉú³É¼¨¹ÜÀíÊý¾Ý¿â£¬È«ÎľùÒÔѧÉú³É¼¨µÄ¹ÜÀíΪÀýÀ´ÃèÊö¡£
¡¡¡¡1.ÔÚ²éѯ½á¹ûÖÐÏÔʾÁÐÃû£º
¡¡¡¡a.ÓÃas¹Ø¼ü×Ö£ºselect name as 'ÐÕÃû' from students order by age
¡¡¡¡b.Ö±½Ó±íʾ£ºselect name 'ÐÕÃû' from students order by age
¡¡¡¡2.¾«È·²éÕÒ:
¡¡¡¡a.ÓÃ ......
2009-10-08 16:05
ʲôÊÇÊÓͼ
´ó¼Ò¶¼ÖªµÀ£¬ÎÒÃǹú¼ÒÏÖÔÚ“ÉñÆß”ÉÏÌìÁË¡£´ÓÃÀ¹úµÄÔÂÇòµÇÔ¿ªÊ¼£¬ÈËÀàÉÏÌì²»ÔÙÊÇÉñ»°¡£Ìý˵£¬ÔÚÃÀ¹ú£¬ÄãÖ»Òª³ö¼¸Ê®ÍòÃÀÔª£¬Äú¾Í¿ÉÒÔÉÏÒ»´ÎÔÂÇò½øÐÐÌ«¿ÕÂÃÐУ¬ËùÒÔ£¬ÎÒÃÇÏàÐÅ£ºÔÚ²»¾ÃµÄ½«À´£¬ÉÏÌìÂÃÐн«×ß½øÎÒÃǰÙÐÕµÄÉú»î£¬ÄÇÊÇÒ»¼þ¶àôÐÂÏÊÉñÆæµÄÊÂÇé° ......