sql server ÖеÄһЩʵÓõÄsqlÓï¾ä
¼ò½é
ÔÚÕâƪÎÄÕÂÖУ¬ÎÒÁоÙһЩsqlÓï¾äÀ´½éÉÜÊý¾Ý¿â£¬Êý¾Ý±í£¬ÊÓͼµÈµÈ¡£µ±ÎÒÃÇÔÚʹÓòéѯ²éѯ²Ù×÷ʱÕâЩsqlÓï¾ä¶¼ÊǷdz£ÓÐÓõġ£ËäÈ»ÔÚsql server¶ÔÏóä¯ÀÀÆ÷ÖÐÎÒÃÇÒ²¿ÉÒÔ»ñµÃÕâЩÓï¾ä£¬µ«ÊÇÈç¹ûÎÒÃÇдÕâЩÓï¾äʱÎÒÃÇ¿ÉÒÔ½«Ëü×Ô¶¨Òå¡£Õâ¾ÍÒâζ×ÅÎÒÃÇ¿ÉÒÔ¸øÓè×Ô¼ºµÄÐèÇóÀ´¹ýÂ˽á¹û¡£
sqlÓï¾äÁбí
ÈçºÎÁоÙsql serverµ±Ç°Á¬½ÓµÄ¿ÉÓÃÊý¾Ý¿â
Method 1 : SP_DATABASES
Method 2 : SELECT name from SYS.DATABASES
Method 3 : SELECT name from SYS.MASTER_FILES
Method 4 : SELECT * from SYS.MASTER_FILES -- Type=0 for .mdf and type=1 for .ldf
SP_DATABASESÊÇÒ»¸ö¿ÉÒÔÁоÙÊý¾Ý¿â¼°Æä´óСµÄ´æ´¢¹ý³Ì
sys.databasesÓï¾äÖпÉÒÔÁоÙÊý¾Ý¿âÃû³Æ£¬´´½¨ÈÕÆÚ£¬ÐÞ¸ÄÈÕÆÚ£¬ÒѾÊý¾Ý¿âidºÍÆäËûһЩÐÅÏ¢¡£
SYS.MASTER_FILESÓï¾ä¿ÉÒÔ²éѯÊý¾ÝµÄÏêϸÇé¿ö£¬±ÈÈçÊý¾Ý¿âid£¬´óС£¬ÎïÀí´æ´¢Â·¾¶ÒÔ¼°ÁоÙÊý¾Ý¿âmdfºÍldf.
ÈçºÎÁоÙÊý¾Ý¿âÖеÄÊý¾Ý±í
ÒÔϵÄsqlÓï¾ä¶¼¿ÉÒÔÁбísql serverÊý¾Ý¿âÖеÄÓû§±í.
Method 1 : SELECT name from SYS.OBJECTS WHERE type='U'
Method 2 : SELECT NAME from SYSOBJECTS WHERE xtype='U'
Method 3 : SELECT name from SYS.TABLES
Method 4 : SELECT name from SYS.ALL_OBJECTS WHERE type='U'
Method 5 : SELECT table_name from INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
Method 6 : SP_TABLES
ÈçºÎÁоÙÊý¾Ý¿âÖеĴ洢¹ý³Ì
Method 1 : SELECT name from SYS.OBJECTS WHERE type='P'
Method 2 : SELECT name from SYS.PROCEDURES
Method 3 : SELECT name from SYS.ALL_OBJECTS WHERE type='P'
Method 4 : SELECT NAME from SYSOBJECTS WHERE xtype='P'
Method 5 : SELECT Routine_name from INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE='PROCEDURE'
SYS.OBJECTSÊý¾Ý±í°üº¬ÁËÈ«²¿µÄ´æ´¢¹ý³Ì£¬Êý¾Ý±í£¬´¥·¢Æ÷£¬ÊÓͼµÈµÄÐÅÏ¢£¬ÕâÀïʹÓÃtype=’p'À´²éѯ´æ´¢¹ý³Ì.
Information_schema.routinesÔÚsql server 7.0ÊÇÒ»¸öÊý¾ÝÊÓͼ£¬ÔÚÆäºóµÄ°æ±¾ÖÐÒѾ±ä³É´æ´¢¹ý³ÌרÓеıí.
ÈçºÎÁоÙÊý¾Ý¿âÖеÄÊÓͼ
Method 1 : SELECT name from SYS.OBJECTS WHERE type='V'
Method 2 : SELECT name from SYS.ALL_OBJECTS WHERE type='V' 
Ïà¹ØÎĵµ£º
SQL code
SQL ServerÊý¾Ýµ¼Èëµ¼³ö¹¤¾ßBCPÏê½â
BCPÊÇSQL ServerÖиºÔðµ¼Èëµ¼³öÊý¾ÝµÄÒ»¸öÃüÁîÐй¤¾ß£¬ËüÊÇ»ùÓÚDB
-
LibraryµÄ£¬²¢ÇÒÄÜÒÔ²¢Ðеķ½Ê½¸ßЧµØµ¼Èëµ¼³ö´óÅúÁ¿µÄÊý¾Ý¡£BCP¿ÉÒÔ½«Êý¾Ý¿âµÄ±í»òÊÓͼֱ½Óµ¼³ö£¬Ò²ÄÜͨ¹ýSELECT fromÓï¾ä¶Ô±í»òÊÓͼ½øÐйýÂ˺󵼳ö¡£ÔÚµ¼Èëµ¼³öÊý¾Ýʱ£¬¿ÉÒÔʹÓÃĬÈÏÖµ»òÊÇʹÓÃÒ»¸ö¸ ......
»Ö¸´Ä£Ê½£¨Recovery Model£©Ö¼ÔÚ¿ØÖÆÊÂÎñÈÕ־ά»¤¡£»Ö¸´Ä£Ê½ËµÃ÷Á˹¤×÷¶ªÊ§µÄ·çÏÕ£¬ÄÜ·ñ»Ö¸´µ½Ê±µã£¿
SQL ServerÊý¾Ý¿âÓÐÈýÖÖ»Ö¸´Ä£Ê½£º¼òµ¥»Ö¸´Ä£Ê½¡¢ÍêÕû»Ö¸´Ä£Ê½ºÍ´óÈÝÁ¿ÈÕÖ¾»Ö¸´Ä£Ê½¡£
Ïà¶ÔÓÚ¼òµ¥»Ö¸´Ä£Ê½¶øÑÔ£¬ÍêÕû»Ö¸´Ä£Ê½ºÍ´óÈÝÁ¿ÈÕÖ¾»Ö¸´Ä£Ê½ÌṩÁ˸üÇ¿µÄÊý¾Ý±£»¤¹¦ÄÜ¡£ÕâЩ»Ö¸´Ä£Ê½¶¼ÊÇ»ùÓÚ±¸·ÝÊÂÎñÈÕÖ ......
1.˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ,Ô´±íÃû£ºa бíÃû£ºb)
SQL: select * into b from a where 11
2.˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý,Ô´±íÃû£ºa Ä¿±ê±íÃû£ºb)
SQL: insert into b(a, b, c) select d,e,f from a;
3.˵Ã÷£ºÏÔʾÎÄÕ¡¢Ìá½»È˺Í×îºó»Ø¸´Ê±¼ä
SQL: select a.title,a.username,b.adddate from table a,(select max(adddat ......
1.Êý¾ÝµÄ·Ö²¼Skip()ºÍtake()
Skip(100)´ú±íÌø¹ý100Ðкó.´ÓµÚ101ÐпªÊ¼·ÖÒ³;
take(10)±íʾ¶àÉÙÐзÖÒ³;
Àý:
var result=from pdt in db.Product
select pdt;
this.dataview.DataSource=result.Skip(10).take(10);
......