Firebird³£ÓÃϵͳ±íSqlÓï¾ä
--µÃµ½Êý¾Ý¿âµÄËùÓÐÕßÃû³Æ
SELECT distinct RDB$OWNER_NAME AS DATABASE_OWNER
from RDB$RELATIONS
WHERE (RDB$SYSTEM_FLAG = 1);
--¸ù¾Ý±íÃûµÃµ½±íµÄÖ÷¼ü
SELECT RC.RDB$CONSTRAINT_NAME AS CONSTRAINT_NAME,
I.RDB$RELATION_NAME AS TABLE_NAME,
S.RDB$FIELD_NAME AS COLUMN_NAME
from RDB$RELATION_CONSTRAINTS RC
LEFT JOIN RDB$INDICES I ON
(I.RDB$INDEX_NAME = RC.RDB$INDEX_NAME)
LEFT JOIN RDB$INDEX_SEGMENTS S ON
(S.RDB$INDEX_NAME = I.RDB$INDEX_NAME)
WHERE (RC.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY')
AND (I.RDB$RELATION_NAME = 'COUNTRY')
---¸ù¾Ý±íÃûµÃµ½ÆäÏà¹ØµÄÒÀÀµ.
SELECT RDB$DEPENDENT_NAME AS DEPENDENT_NAME,
RDB$DEPENDED_ON_NAME AS DEPENDS_ON,
RDB$FIELD_NAME AS FIELD_NAME,
RDB$DEPENDENT_TYPE DEPENDENT_TYPE,
CASE
WHEN RDB$DEPENDENT_TYPE = 0 THEN 'TABLE'
WHEN RDB$DEPENDENT_TYPE = 1 THEN 'VIEW'
WHEN RDB$DEPENDENT_TYPE = 2 THEN 'TRIGGER'
WHEN RDB$DEPENDENT_TYPE = 3 THEN 'COMPUTED'
WHEN RDB$DEPENDENT_TYPE = 4 THEN 'VALIDATION'
WHEN RDB$DEPENDENT_TYPE = 5 THEN 'PROCEDURE'
WHEN RDB$DEPENDENT_TYPE = 6 THEN 'expression_r_INDEX'
WHEN RDB$DEPENDENT_TYPE = 7 THEN 'EXCEPTION'
WHEN RDB$DEPENDENT_TYPE = 8 THEN 'USER'
WHEN RDB$DEPENDENT_TYPE = 9 THEN 'FIELD'
WHEN RDB$DEPENDENT_TYPE = 10 THEN 'INDEX'
WHEN RDB$DEPENDENT_TYPE = 14 THEN 'GENERATOR'
ELSE 'UNKNOWN'
END AS DEPENDENT_TYPE_STR,
RDB$DEPENDED_ON_TYPE AS DEPEND_ON_TYPE,
CASE
WHEN RDB$DEPENDED_ON_TYPE = 0 THEN 'TABLE'
WHEN RDB$DEPENDED_ON_TYPE = 1 THEN 'VIEW'
WHEN RDB$DEPENDED_ON_TYPE = 2 THEN 'TRIGGER'
WHEN RDB$DEPENDED_ON_TYPE = 3 THEN 'COMPUTED'
WHEN RDB$DEPENDED_ON_TYPE = 4 THEN 'VALIDATIO
Ïà¹ØÎĵµ£º
1.Óòéѯ·ÖÎöÆ÷ÖØÃüÃû
exec sp_rename ÔÃû³Æ, ÐÂÃû³Æ
sp_rename ÊÇ SQL Server™ ×Ô´øµÄÒ»¸ö´æ´¢¹ý³Ì£¬ÓÃÓÚ¸ü¸Äµ±Ç°Êý¾Ý¿âÖÐÓû§´´½¨µÄ¶ÔÏóµÄÃû³Æ£¬Èç±íÃû¡¢ÁÐ±í¡¢Ë÷ÒýÃûµÈ¡£
2.ÓÃÆóÒµ¹ÜÀíÆ÷ÖØÃüÃû
ÔÚ±íÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”£¬Ñ¡ÖÐËùÒªÖØÃüÃûµÄ´¥·¢Æ÷£¬Ð޸Ĵ¥·¢Æ÷ ......
1.Óòéѯ·ÖÎöÆ÷ÖØÃüÃû
exec sp_rename ÔÃû³Æ, ÐÂÃû³Æ
sp_rename ÊÇ SQL Server™ ×Ô´øµÄÒ»¸ö´æ´¢¹ý³Ì£¬ÓÃÓÚ¸ü¸Äµ±Ç°Êý¾Ý¿âÖÐÓû§´´½¨µÄ¶ÔÏóµÄÃû³Æ£¬Èç±íÃû¡¢ÁÐ±í¡¢Ë÷ÒýÃûµÈ¡£
2.ÓÃÆóÒµ¹ÜÀíÆ÷ÖØÃüÃû
ÔÚ±íÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”£¬Ñ¡ÖÐËùÒªÖØÃüÃûµÄ´¥·¢Æ÷£¬Ð޸Ĵ¥·¢Æ÷Óï ......
×ªÔØËµÃ÷£º¸øÕýÔÚ×öϵͳºÍÏë×öϵͳµÄÈË£¬SQL²©´ó¾«ÉÄãÃÇ»áÓõ½µÄ¡£——mAysWINd
Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµ ......
SQL:
using System.Data.SqlClient;
string sql = "server=.;uid=sa;pwd=;database=tablename;";
ACCESS:
using System.Data.OleDb;
string sql = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + HttpRuntime.AppDomainAppPath + "//App_Data//db.mdb";
HttpRuntime.AppDomainAppPath Ϊ¸ùĿ¼
......
--ÉèÖÃÊý¾Ý¿âÊä³ö£¬Ä¬ÈÏΪ¹Ø±Õ£¬Ã¿´Îдò¿ª´°¿Ú¶¼ÒªÖØÐÂÉèÖÃ
set serveroutput on
--µ÷Óà °ü º¯Êý ²ÎÊý
execute dbms_output.put_line('hello world');
--»òÕßÓÃcallµ÷Óã¬Ï൱ÓÚjavaÖеĵ÷ÊÔ³ÌÐò´ò×®
call d ......