SQL server 2008 ÆóÒµ°æ
ºú»Ô£º13028803715 0755-82945017
9¡¢ÉîÛÚmicrosoft Windows 2003 Server±¨¼Û ÖÐÎıê×¼°æ5Óû§ 4100
10¡¢ÉîÛÚmicrosoft Windws 2003 Server±¨¼Û ÖÐÎÄÆóÒµ°æ25Óû§ 20500
11¡¢ÉîÛÚmicrosoft Windows 2008 Server±¨¼Û ÖÐÎıê×¼°æ5Óû§ 5800
12¡¢ÉîÛÚmicrosoft Windows 20008 Server ÖÐÎÄÆóÒµ°æ25Óû§ 22000
13¡¢ÉîÛÚmicrosoft SQL Êý¾Ý¿â ¹¤×÷×é°æ 10Óû§ ¿ª·ÅʽÐí¿É 12900
14¡¢ÉîÛÚmicrosoft SQLÊý¾Ý¿â±¨¼Û ±ê×¼°æ 15Óû§ ¿ª·ÅʽÐí¿É 29000
ÉîÛÚmicrosoft SQL server 2008±¨¼Û ÖÐÎıê×¼°æ15Óû§²Ê°ü 33300
ÉîÛÚmicrosoft SQL server 2008 ÖÐÎŤ×÷×é°æ±¨¼Û10Óû§²Ê°ü 13000
Ïà¹ØÎĵµ£º
select sql_text, spid, v$session.program, process
from v$sqltext, v$session, v$process
where v$sqltext.address = v$session.sql_address
and v$sqltext.hash_value = v$session.sql_hash_value
and v$session.paddr = v$process.addr
and v$process.spid in (4335);
×¢Ò ......
sysforeignkeys
°üº¬¹ØÓÚ±í¶¨ÒåÖÐµÄ FOREIGN KEY Ô¼ÊøµÄÐÅÏ¢¡£¸Ã±í´æ´¢ÔÚÿ¸öÊý¾Ý¿âÖС£
ÁÐÃû Êý¾ÝÀàÐÍ ÃèÊö
constid int FOREIGN KEY Ô¼ÊøµÄ ID¡£
fkeyid int ¾ßÓÐ FOREIGN KEY Ô¼ÊøµÄ±í¶ÔÏó ID¡£
rkeyid int ÔÚ FOREIGN KEY Ô¼ÊøÖÐÒýÓõıí¶ÔÏó ID¡£
fkey smallint ......
SqlÓï¾ä×÷Ϊ¹ú¼Ê±ê×¼µÄÊý¾Ý¿â²éѯÓï¾ä£¬±±¾©°á¼Ò¹«Ë¾ ±±¾©Êèͨ¹«Ë¾ÔÚ¸÷ÖÖ±à³Ì»·¾³Öеõ½Á˹㷺µÄÓ¦Óá£×÷Ϊһ¸ö³ÉÊì¡¢Îȶ¨µÄϵͳ£¬Óû§µÇ½ºÍÃÜÂëÑéÖ¤ÊDZز»¿ÉÉٵġ£ÔÚƽʱµÄ±à³Ì¹¤×÷ÖÐÐí¶à³ÌÐòÔ±ÔÚÓÃsqlÓï¾ä½øÐÐÓû§ÃÜÂëÑé֤ʱÊÇͨ¹ýÒ»¸öÀàËÆÕâÑùµÄÓï¾äÀ´ÊµÏֵģº
strSel = " Select * from Óû§±í where ÐÕÃû= '" ......
´ò¿ª²éѯ·ÖÎöÆ÷£¬ÔÚ²éѯ·ÖÎöÆ÷ÏÂÖ´ÐУº
exec sp_defaultdb Õ˺ÅÃû , ĬÈÏÊý¾Ý¿â
¾ÙÀý£ºÎÒµÄĬÈÏÕ˺ÅÊÇsa£¬´ò¿ª²éѯ·ÖÎöÆ÷£¬Ä¬ÈÏÊý¾Ý¿âÊÇmaster£»ÏÖÔÚÎÒн¨ÁËÒ»¸öÊý¾Ý¿âmyData,Ï뽫ĬÈÏÊý¾Ý¿â¸ÄΪmyData£¬Ö»ÐèÖ´ÐУº exec sp_defaultdb sa , myData ¼´ ......