sqlÓï¾äÖеÄ[]
¼Ó[ ]ÓÃÓÚ¶¨½çÁÐÃû»ò±íÃûµÈÐÅÏ¢£¬ÒÔÇø±ðÒ»Ð©ÌØÊâµÄ²»ºÏÃüÃû¹æÔòµÄ×Ö´®£¬»òÊÇÓëϵͳ±£Áô×ÖÓгåÍ»¡£
Èç"user"ÊÇSQL Server±£ÁôµÄ¹Ø¼ü×Ö£¬ËùÒÔÓÃ"select * from user"²éѯ»áÌáʾÓï·¨´íÎó¡£¼ÓÉÏÖÐÀ¨ºÅ£¬ÒÔÉùÃ÷Æä²»ÊDZ£Áô×Ö¡£
"select * from [user]"
Èç¹û±íÃû²»Êǹؼü×Ö£¬ÈçCompany£¬ÔòÓÃ"select * from Company"ÊÇûÎÊÌâµÄ£¬²»ÓüÓÖÐÀ¨ºÅ,µ±È»×îºÃµÄ°ì·¨ÊDZíÃûͳͳ¼Ó·½À¨ºÅ
[] ÀïµÄÄÚÈݱíʾÊÇÒ»¸öÓû§¼¶µÄ±äÁ¿.
Ä¿µÄÊÇ·ÀÖ¹Óû§Ê¹ÓõÄÃû³ÆºÍϵͳ±£Áô×Ö³åÍ»
±ÈÈçÄãÓÐÒ»¸ö±íÃû¾Í½Ðselect
ÄÇôÄã select * from select¿Ï¶¨ÊDz»ÐеÄ.
µ«ÊÇÄãselect * from [select] ¾ÍûÎÊÌâÁË
ÄãÄǸö userÒ²ÊÇÒ»Ñù.
ËùÓеıíÃû×Ö¶ÎÃû¶¼¿ÉÒÔ¼Ó[],µ«ÊÇÖ»Òª²»¸úϵͳ¹Ø¼ü×Ö³åÍ»¾Í¿ÉÒÔÊ¡ÂÔ
Ïà¹ØÎĵµ£º
2008Êý¾Ý¿â¸½¼Ó
/*
ÍøÉÏ¿´µ½µÄÕûÀíÁËһϡ£
ÔÎĵØÖ·http://database.51cto.com/art/201003/190984.htm
ÔÚSQL Server 7.0ÖУ¬Î¢ÈíÍÆ³öÁËsp_attach_dbºÍsp_attach_single_file_dbϵͳ´æ´¢¹ý³Ì¡£
Ëü¶ÔÓÚSQL ServerÊý¾Ý¿â¹ÜÀíÔ±Ö´ÐÐÏÂÃæµÄÈÎÎñÊǷdz£·½±ãµÄ£º
1 ʹÓÃsp_attach_d ......
º¯ÊýÒÀÀµ
==========================================
Ò»¡¢º¯ÊýÒÀÀµ¸ÅÄî
¡¡¡¡º¯ÊýÒÀÀµÊÇ´ÓÊýѧ½Ç¶ÈÀ´¶¨ÒåµÄ£¬ÔÚ¹ØÏµÖÐÓÃÀ´¿Ì»¹ØÏµ¸÷ÊôÐÔÖ®¼äÏà»¥ÖÆÔ¼¶øÓÖÏ໥ÒÀÀµµÄÇé¿ö¡£º¯ÊýÒÀÀµÆÕ±é´æÔÚÓÚÏÖʵÉú»îÖУ¬±ÈÈ磬ÃèÊöÒ»¸öѧÉúµÄ¹ØÏµ£¬¿ÉÒÔÓÐѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵµÈ¶à¸öÊôÐÔ£ ......
SQL Server 2008¼òÌåÖÐÎÄÆóÒµ°æÏÂÔØ£º
thunder://QUFodHRwOi8vd3d3LnF1aWNrOC5jbi9kb3duLmFzcD9pZD0xMjM2JnNpZD0wWlo=
±¾DVD°üº¬ÁËx86 x64 ia64 ÈýÖÖCPUģʽµÄ°²×°³ÌÐò¡£°æ±¾ºÅΪ£º 10.0.1600.22
ÐòÁкţº
¿ª·¢°æ(Developer): PTTFM-X467G-P7RH2-3Q6CG-4DMYB
ÆóÒµ°æ(Enterprise): JD8Y6-HQG69-P9H84-XDTPG-34MBB ......
Sqlʱ¼äº¯Êý
Ò»¡¢sql serverÈÕÆÚʱ¼äº¯Êý
Sql ServerÖеÄÈÕÆÚÓëʱ¼äº¯Êý
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
Àý ......