»ñµÃÊý¾Ý¿âÃû³Æ///////²éѯÊý¾Ý¿âÀïËùÓбíµÄ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' ²éѯһ¸ö¿âÀïµÄËùÓбíÃû³Æ
sysobjects
ÔÚÊý¾Ý¿âÄÚ´´½¨µÄÿ¸ö¶ÔÏó£¨Ô¼Êø¡¢Ä¬ÈÏÖµ¡¢ÈÕÖ¾¡¢¹æÔò¡¢´æ´¢¹ý³ÌµÈ£©ÔÚ±íÖÐÕ¼Ò»ÐС£Ö»ÓÐÔÚ tempdb ÄÚ£¬Ã¿¸öÁÙʱ¶ÔÏó²ÅÔڸñíÖÐÕ¼Ò»ÐС£
ÁÐÃû Êý¾ÝÀàÐÍ ÃèÊö
name sysname ¶ÔÏóÃû¡£
Id int ¶ÔÏó±êʶºÅ¡£
xtype char(2) ¶ÔÏóÀàÐÍ¡£¿ÉÒÔÊÇÏÂÁжÔÏóÀàÐÍÖеÄÒ»ÖÖ£º
C = CHECK Ô¼Êø
D = ĬÈÏÖµ»ò DEFAULT Ô¼Êø
F = FOREIGN KEY Ô¼Êø
L = ÈÕÖ¾
FN = ±êÁ¿º¯Êý
IF = ÄÚǶ±íº¯Êý
P = ´æ´¢¹ý³Ì
PK = PRIMARY KEY Ô¼Êø£¨ÀàÐÍÊÇ K£©
RF = ¸´ÖÆÉ¸Ñ¡´æ´¢¹ý³Ì
S = ϵͳ±í
TF = ±íº¯Êý
TR = ´¥·¢Æ÷
U = Óû§±í
UQ = UNIQUE Ô¼Êø£¨ÀàÐÍÊÇ K£©
V = ÊÓͼ
X = À©Õ¹´æ´¢¹ý³Ì
uid smallint ËùÓÐÕß¶ÔÏóµÄÓû§ ID¡£
info smallint ±£Áô¡£½öÏÞÄÚ²¿Ê¹Óá£
status int ±£Áô¡£½öÏÞÄÚ²¿Ê¹Óá£
base_schema_
ver int ±£Áô¡£½öÏÞÄÚ²¿Ê¹Óá£
replinfo int ±£Áô¡£¹©¸´ÖÆÊ¹Óá£
parent_obj int ¸¸¶ÔÏóµÄ¶ÔÏó±êʶºÅ£¨ÀýÈ磬¶ÔÓÚ´¥·¢Æ÷»òÔ¼Êø£¬¸Ã±êʶºÅΪ±í ID£©¡£
crdate datetime ¶ÔÏóµÄ´´½¨ÈÕÆÚ¡£
ftcatid smallint ΪȫÎÄË÷Òý×¢²áµÄËùÓÐÓû§±íµÄÈ«ÎÄĿ¼±êʶ·û£¬¶ÔÓÚûÓÐ×¢²áµÄËùÓÐÓû§±íÔòΪ 0¡£
schema_ver int °æ±¾ºÅ£¬¸Ã°æ±¾ºÅÔÚÿ´Î±íµÄ¼Ü¹¹¸ü¸Äʱ¶¼Ôö¼Ó¡£
stats_schema_
ver int ±£Áô¡£½öÏÞÄÚ²¿Ê¹Óá£
type char(2) ¶ÔÏóÀàÐÍ¡£¿ÉÒÔÊÇÏÂÁÐÖµÖ®Ò»£º
C = CHECK Ô¼Êø
D = ĬÈÏÖµ»ò DEFAULT Ô¼Êø
F = FOREIGN KEY Ô¼Êø
FN = ±êÁ¿º¯Êý
IF = ÄÚǶ±íº¯Êý
K = PRIMARY KEY »ò UNIQUE Ô¼Êø
L = ÈÕÖ¾
P = ´æ´¢¹ý³Ì
R = ¹æÔò
RF = ¸´ÖÆÉ¸Ñ¡´æ´¢¹ý³Ì
S = ϵͳ±í
TF = ±íº¯Êý
TR = ´¥·¢Æ÷
U = Óû§±í
V = ÊÓͼ
X = À©Õ¹´æ´¢¹ý³Ì
userstat smallint ±£Áô¡£
sysstat smallint ÄÚ²¿×´Ì¬ÐÅÏ¢¡£
indexdel smallint ±£Áô¡£
refdate datetime Áô×÷ÒÔºóʹÓá£
version int Áô×÷ÒÔºóʹÓá£
deltrig int ±£Áô¡£
instrig int ±£Áô¡£
updtrig int ±£Áô¡£
seltrig int ±£Áô¡£
category int ÓÃÓÚ·¢²¼¡¢Ô¼ÊøºÍ±êʶ¡£
cache smal
Ïà¹ØÎĵµ£º
ÍøÕ¾£ºhttp://werysoft.com/
Èç¹ûÄú±ØÐë¹ÜÀí»·¾³ÖеĶàÖÖÀàÐ͵ÄÊý¾Ý¿â·þÎñÆ÷£¬ÔòʹÓü¯ÖÐʽ¹¤¾ßµ÷ÕûËùÓÐÊý¾Ý¿â¿ÉÄÜ»á±È½Ï·½±ã¡£Werysoft µÄ QweryBuilder Ö¼ÔÚΪÄúÌṩ´ËÏÄÜ¡£Äú¿ÉÒÔʹÓÃËü´Óͬһ GUI Á¬½Óµ½ Microsoft SQL Server¡¢Sybase ASE¡¢SQL Anywhere ºÍ Oracle ʵÀý£¬È»ºó²é¿´¡¢´´½¨¡¢¸üкÍɾ³ýÊý¾Ý¿â½Å±¾¡¢¼Ü ......
http://weblogs.asp.net/scottgu/archive/2007/09/07/linq-to-sql-part-9-using-a-custom-linq-expression-with-the-lt-asp-linqdatasource-gt-control.aspx
1-9 parts are the most useful knowledge for you so far. ......
³ÌÐòÆô¶¯Sql ServerÆäʵºÜ¼òµ¥
´úÂ룺
System.ServiceProcess.ServiceController myController =
new System.ServiceProcess.ServiceController("MSSQL$ACCP4444"); //·þÎñÃû³Æ ÕÒÁ˰ëÌì²ÅÕÒµ½£¬±¿ËÀÎÒÍêÁË¡£ÔÚ·þÎñÉÏÓÒ¼üÊôÐÔ£¬ÄÜ¿´µ½
if (myController.CanStop)
{ }
else ......
ÔÌù£º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 ......
¸½:Oracle SQL Developer — À©Õ¹½»Á÷ÖÐÐÄ
http://www.oracle.com/technology/global/cn/products/database/sql_developer/files/extensions.htm
֮ǰ×÷Ϊһ¸öOracle Employee£¬È´×ÜÊÇÔÚʹÓÃPL/SQL Developer£¨¶øÇÒÊÇÆÆ½â°æ£©£¬ÕâʵÔÚÓÐЩ˵²»¹ýÈ¥£¬µ«ÊÇÈçºÎÕÒµ½Ò»¸öºÏÐijÃÊÖµÄÄܹ»Ô ......