随笔分类 -  数据库 Database

SQL_MSSQL_Oracle etc
Window Firewall cause "MS SQL Server New SQL Server Registeration" and "New ODBC DSN " failure
摘要：Three computers have MS SQL Server 2000 installed.One is Windows 2000 Server ,the other two are Windows XP Professional.The Windows XP Professional can register the MS SQL Server instance on Windows 2... 阅读全文

posted @ 2004-10-20 14:04 番茄鸡蛋面 阅读(606) 评论(0) 推荐(0)

NET Framework Data Providers
摘要：MSDN article NET Framework Data Providers helps us to understand several .NET Framework Data Providers and how to choose a proper Data Provider between.NET Framework Data Provider for SQL Server.NET F... 阅读全文

posted @ 2004-06-22 16:27 番茄鸡蛋面 阅读(745) 评论(0) 推荐(0)

Oracle - MSSQL Convert Tips (1)
摘要：These days I participate a project to convert sql statements between Oracle and MSSQL and learn a lot.1.Autoincreamentcolumn Issuesqlserver:whencreatetabledefinethiscolumn property identity(0,1)oracle... 阅读全文

posted @ 2004-06-18 17:43 番茄鸡蛋面 阅读(2075) 评论(2) 推荐(0)

Learn SQL Join,Inner Join, Outer Join
摘要：For Example:Table A have 12( 8+4) entries, 8 entries have valid relation with BTable B have 80(77+3) entries , 77 entries have valid relation with A.then the return amount of join is :cross join : 12*... 阅读全文

posted @ 2004-06-18 15:10 番茄鸡蛋面 阅读(4530) 评论(2) 推荐(0)

Oracle 9i is finally installed!
摘要：Oracle universal Installer,Oracle Database ,Enterprise Edition.Oracle Database Configuration Assistant to Create Database.Oracle Net Configuration Assistant to connect the a certain (remote/local) dat... 阅读全文

posted @ 2004-06-17 19:11 番茄鸡蛋面 阅读(606) 评论(0) 推荐(0)

导航