Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çå³ýSQL Server Management Studio×î½ü·þÎñÆ÷Áбí

Õª×Ô£ºÒÁÒÇÇïË®
SQL Server Management Studio (SSMS) µÄ“Á¬½Óµ½·þÎñÆ÷”¶Ô»°¿ò»á¼Ç¼Óû§ËùÓзÃÎʹýµÄ·þÎñÆ÷Ãû³Æ£¬Õâ¸ö¹¦ÄܶÔÓÚ¾­³£Á¬½Ó¶à¸öÊý¾Ý¿âµÄÈËÀ´ËµÈ·ÊµÍ¦·½±ãµÄ¡£
²»¹ýʹÓÃÁËÒ»¶Îʱ¼äÖ®ºó£¬Õâ¸öÁбí»á±äµÃºÜ³¤¡£ÀïÃæ»¹Óкܶà·þÎñÆ÷Ãû³Æ¶¼ÒѾ­Ê§Ð§ÁË£¬ºÜÏë°ÑÕâ¸öÁбíÇå¿ÕÁË¡£µ«ÊǺÜÓôÃÆÔÚSSMSµÄ½çÃæÕÒ²»µ½¿ÉÒÔÇå¿Õ¸ÃÁбíµÄµØ·½£¬ÓÚÊÇÎÒGoogleÁËÒ»°Ñ£¬ÕÒµ½Á˴𰸡£
¶ÔÓÚ SQL Server 2005 Management Studio£¬¿ÉÒÔɾ³ýÒÔÏÂÎļþÇå¿Õ¸ÃÁÐ±í£º
WinXP: C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat
Vista/Win7: C:\Users\<user>\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat
¶ÔÓÚ SQL Server 2008 Management Studio£¬¿ÉÒÔɾ³ýÒÔÏÂÎļþÇå¿Õ¸ÃÁÐ±í£º
WinXP: C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin
Vista/Win7: C:\Users\<user>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin


Ïà¹ØÎĵµ£º

SQL²éѯÅóÓѹØÏµÈ¦Ó¦ÓÃʵÀý

Ô­Ìù£ºhttp://topic.csdn.net/u/20100412/11/a4ea520e-7dd0-44d2-98bb-9f62f0ed6160.html?21233
--------------------------------------------------------------------------
--  Author : htl258(Tony)
--  Date   : 2010-04-14 06:02:36
--  Version:Microsoft SQL Server 2008 (RTM) - 1 ......

»ñµÃÊý¾Ý¿âÃû³Æ///////²éѯÊý¾Ý¿âÀïËùÓбíµÄsqlÓï¾ä£¡

select   name   as   ¿âÃû   from   master..sysdatabases   where   dbid>=7 »ñµÃÊý¾Ý¿âÃû³Æ
select * from sysobjects where xtype='u' or xtype='v' ²éѯÊý¾Ý¿âÀïËùÓбíµÄsqlÓï¾ä£¡
select name from sysobjects where type='u' ²éѯһ¸ö¿ ......

oracle Ïà關µÄsql語¾ä

Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
¡¡¡¡1¡¢Óû§£º
¡¡¡¡¡¡select username from dba_users;
¡¡¡¡¸Ä¿ÚÁî
¡¡¡¡¡¡alter user spgroup identified by spgtest;
¡¡¡¡2¡¢±í¿Õ¼ä£º
¡¡¡¡¡¡select * from dba_data_files;
¡¡¡¡¡¡select * from dba_tablespaces;//±í¿Õ¼ä
¡¡¡¡¡¡select tablespace_name,sum(bytes), sum(b ......

SQL Server2000 ½âÎöXML

DECLARE @HDOC INT --Îĵµ¾ä±ú
DECLARE @XMLSTRING VARCHAR(200) --XML×Ö·û´®
SET @xmlString ='<?xml version="1.0"?>
<ROOT>
<USER ID="1" Name="SBQCEL"/>
<USER ID="2" Name="PEACELI"/>
<USER ID="3" Name="SHEEPCHANG"/>
</ROOT>'
--ʹÓÃϵͳ´æ´¢ ......

Sql Server ¶ÔxmlÀàÐ͵IJÙ×÷

 declare @XML XML
SET @XML='<root>
 <OLDVALUE>
  <H_Action id="1130">030</H_Action>
  <D_Action>030</D_Action>
  <OrderCompany>00220</OrderCompany>
  <OrderNumber>10004035</OrderNumber> ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ