SQL Server²¹¶¡°æ±¾µÄ¼ì²é
SQL ServerµÄ²¹¶¡°æ±¾¼ì²é²»ÈçWindows ²¹¶¡°æ±¾¼ì²éÖ±½Ó£¬Ò»¸öϵͳ¹ÜÀíÔ±£¬Èç¹û²»Á˽âSQL Server°æ±¾¶ÔÓ¦µÄ²¹¶¡ºÅ£¬¿ÉÄÜÒ²»áÓöµ½Ò»µãÂé·³£¬Òò´ËÔÚÕâ˵Ã÷һϣ¬Í¨¹ýÕâÑùµÄ°ì·¨Åбð»úÆ÷ÊÇ°²È«µÄ°ì·¨£¬²»»á¶Ôϵͳ²úÉúÈκÎÓ°Ïì¡£
¡¡
1¡¢ÓÃIsql»òÕßSQL²éѯ·ÖÎöÆ÷µÇ¼µ½SQL Server£¬Èç¹ûÊÇÓÃIsql£¬ÇëÔÚcmd´°¿ÚÊäÈëisql -U sa,È»ºóÊäÈëÃÜÂ룬½øÈ룻Èç¹ûÊÇÓÃSQL²éѯ·ÖÎöÆ÷£¬Çë´Ó³ÌÐòÖÐÆô¶¯£¬ÊäÈësaºÍÃÜÂ루Ҳ¿ÉÒÔÓÃwindowsÑéÖ¤£©¡£
¡¡
2¡¢ÔÚISQLÖÐÊäÈ룺
Select @@Version£»
go
»òÕßSQL²éѯ·ÖÎöÆ÷ÖÐÊäÈë(ÆäʵÈç¹û²»ÏëÊäÈ룬ֻҪ´ò¿ª°ïÖúµÄ¹ØÓھͿÉÒÔÁË:))
Select @@Version£»
È»ºó°´Ö´ÐУ»
Õâʱ»á·µ»ØSQLµÄ°æ±¾ÐÅÏ¢£¬ÈçÏ£º
Microsoft
SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright
(c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT
5.0 (Build 2195: Service Pack 3)
ÆäÖеÄ8.00.760¾ÍÊÇSQL ServerµÄ°æ±¾ºÍ²¹¶¡ºÅ¡£¶ÔÓ¦¹ØϵÈçÏ£º
8.00.194 £——————SQL Server 2000 RTM
8.00.384 £——————(SP1)
8.00.534 £——————(SP2)
8.00.760 £——————(SP3)
8.00.2039---------------------(sp4)
ÕâÑùÎÒÃǾÍÄÜ¿´µ½SQL ServerµÄÕýÈ·°æ±¾ºÍ²¹¶¡ºÅÁË¡£
------------------------------------------------------------------------------------
ת×Ô£ºhttp://yk216.blog.51cto.com/252445/119130
Ïà¹ØÎĵµ£º
ÈçÏÂÁгö²éѯ±í´ïʽ£¬³£ÓòÙ×÷·û£¬ÓëSQLÓï¾ä¶ÔÓ¦¡£
where ¹Ø¼ü×ÖµÄʹÓÃ
public void MyWhere()
{
NorthwindDataContext dc = new NorthwindDataContext();
//²éѯ²úÆ·Ãû³ÆÒÔL¿ªÍ·µÄ¼Ç¼
var query = from p in dc.Products
where p.Prod ......
1. ²é¿´Êý¾Ý¿âµÄ°æ±¾
select @@version
2. ²é¿´Êý¾Ý¿âËùÔÚ»úÆ÷²Ù×÷ϵͳ²ÎÊý
exec master..xp_msver
3. ²é¿´Êý¾Ý¿âÆô¶¯µÄ²ÎÊý
sp_configure
4. ²é¿´Êý¾Ý¿âÆô¶¯Ê±¼ä
select convert(varchar(30),login_time,120) from master ......
1¡¢ÔÚÁíһ̨»úÆ÷ÉϽ¨Á¢¶ÀÁ¢µÄÊý¾Ý¿â·þÎñÆ÷£¬×÷ΪÁ´½ÓÄ¿±ê
2¡¢±¾µØÊý¾Ý¿â·þÎñÆ÷ÉÏÌí¼Ó“Á´½Ó·þÎñÆ÷”£º
Ãû×Ö£ºËæ±ãÈ¡Ò»¸öÃû×Ö
·þÎñÆ÷ÀàÐÍ£ºÑ¡ÔñÊý¾ÝÔ´£ºMicrosoft OLE DB Provider for SQL Server
Êý¾ÝÔ´£ºÐ´±ðÃû£¨ÔÚ¿Í»§¶ËÍøÂçʵÓù¤¾ßÖÐÉèÖã©
Ñ¡ÖÐRPCºÍRPCÊä³ö ......
mysqlµ¼³ösql½Å±¾ ÊÕ²Ø
×¢ÒâÊÂÏî:
*±ØÐëÔÚD:\LTSOFT\MYSQL4\bin> mysqldump -u root -p test > c:\a.sql
ÏȵýøÈëmysql°²×°Ä¿Â¼µÄbinÏ£¨¿ÉÒÔ¿´µ½ÀïÃæÓÐmysqldump.exe£©£¬Í¨³£mysqlĬÈÏ°²×°ÔÚC:\Program Files\MySQL\MySQL Server 5.0
* ²»ÄܽøÈëmysql ÃüÁîÀï.
MySQLµ¼³ ......