sql server 觸發器用的臨時表怎么翻譯為oracle觸發器用的臨時表？拜托各位了 3Q

sql 的觸發器 操作時有2個表 一個 deleted 表 這個表保存的數據就是操作前的數據 想應該符合樓主要的 before 的結果 after 觸發器在觸發它們的語句完成后執行。如果該語句因錯誤（如違反約束或語法錯誤）而失敗，觸發器將不會執行。不能為視圖指定 after 觸發器，只能為表指定該觸發器。可以為每個觸發操作（insert、update 或 delete）指定多個 after 觸發器。如果表有多個 after 觸發器，可使用 sp_settriggerorder 定義哪個 after 觸發器最先激發，哪個最后激發。除第一個和最后一個觸發器外，所有其它的 after 觸發器的激發順序不確定，并且無法控制。 在sql server 2000 中 after 是默認觸發器。不能在 sql server 7.0 版或更早的版本中指定 after 或 instead of，這些版本中的所有觸發器都作為 after 觸發器運行。 instead of 該觸發器代替觸發操作執行。可在表和視圖上指定 instead of 觸發器。只能為每個觸發操作（insert、update 和 delete）定義一個 instead of 觸發器。instead of 觸發器可用于對 insert 和 update 語句中提供的數據值執行增強的完整性檢查。instead of 觸發器還允許指定某些操作，使一般不支持更新的視圖可以被更新。

創新互聯成都企業網站建設服務，提供網站建設、網站設計網站開發,網站定制,建網站,網站搭建,網站設計,自適應網站建設,網頁設計師打造企業風格網站,提供周到的售前咨詢和貼心的售后服務。歡迎咨詢做網站需要多少錢:18982081108

滿意請采納

高分求翻譯~~

The main part of the design of hardware to solve the data received from the one-way within the network, and network data from the device database is written out, one way to solve the data transfer, RS-232 serial port devices use in a transmit data line and a root ground for transmission equipment Arm_linux operating system, the stability of this operating system is better suited to real-time data transmission services, operating outside the network open-source database using the freetds library additions and deletions to the database. Hardware, software mainly ARMLinux as the core operating system, network server receiving data within an infinite loop to read data using unpack, the external network database operations directly connected modules FREETDS SQLSERVER additions and deletions to the database server operations. To achieve the data from the software within the network from outside networks, one-way release.

This system is applied to the Land and Resources Bureau of Changchun City, e-government system as a module released outside the network, the Changchun City Land Resources Web site requires registration and outside the network card and workflow for real-time status data. Changchun City Land and Resources issued outside the main data network for the registration card and workflow status data, these two data are very concerned about the people, so the following Land and Resources Bureau of Changchun City, the data within the network as an example to explain the data published released in the middle of special equipment for service development.

Changchun City Land and Resources issued outside the network data services, delphi development is the use of system services components. Sqlserver ado connection through the network database to obtain updated data into a sql statement, the company's pcommlite components through access to XOMA COM1, and send data, receive data released equipment sqlserver database connection outside the network, after the implementation of data update sql statement.

nativeforsqlserver英語不顯示了

可以新建sqlserver試試進行連接。

生產環境的操作系統和數據庫可能是英文版的，而我們的母語是中文，如果英語能力差點，可能有時對英語環境下的數據庫腳本報錯的英文提示看不懂，如果直接拿英語錯誤提示通過翻譯工具去翻譯，也不一定就是完全翻譯得100%準確。可以換成中文語言好像，進入到選項窗口，點擊字體。打開nativeforsqlservers應用界面，點擊工具，進入到工具列表界面，點擊選項，進入到選項窗口，點擊字體，進入到字體窗口，點擊下拉框，打開下拉框列表，選擇需要的中文字體，然后在完成其他選項的中文字體設置后點擊保存就可以了。

SQLserver 2000英文和中文翻譯

一、SQL Server關系數據庫簡介

1、SQL Server是由Microsoft開發和推廣的關系數據庫系統（DBMS)，它最初是由Microsoft、Sybase和Ashton-Tate三家公司共同開發的，并于1988年推出了第一個OS/2版本。

2、關系數據庫（RDBMS)管理系統功能：

》維護數據庫數據之間的關系；

》保證數據存儲的正確性；

》當出現系統故障的時候，將所有數據恢復到能夠保證一致行的某種狀態

3、RDBMS:SQL Server，Oracle，DB/2,Sybase，Informix

4、Non-RDBMS(File-based）：Foxpro，Access

二、SQL Server 2000的版本

1、SQL Server 2000常見版本有：

》企業版（Enterprise Edition）

支持所有SQL Server 2000的功能。該版本多用于大中型產品數據庫服務器，并且可以支持大型網站，企業OLTP（聯機事務處理）和大型數據倉庫系統OLAP(聯機分析處理）所要求的性能。

》標準版（Standard Edition）

實用范圍是小型的工作組或部門。它支持大多數的SQL Server2000功能。但是，不具有支持大型數據庫，數據倉庫和網站的功能。而且，不支持所有的關系數據庫引擎的功能。

》個人版（Personal Edition）

主要適用于移動用戶，因為他們經常從網絡上斷開，而運行的應用程序卻仍然需要SQL Server 2000的支持。除了事務處理復制功能以外，能夠支持所有SQL Server 2000標準版支持的特性。

》開發者版（Developer Edition）

適用于應用程序開發的版本，支持除圖形化語言設置以外的SQL Server2000的所有其它功能。該版本主要適用于程序員在開發應用程序時，將SQL Server 2000作為其數據存儲區。雖然開發版的功能齊備，但是只被授權為一個開發和測試系統，而不是一個產品服務器。

1.1 SQL Server特點

》與因特網的集成：

SQL Server 2000的數據庫引擎全面支持XML（Extensive Markup Language，擴展標記語言），能使用戶很容易地將數據庫中的數據發布到Web頁面上。

》可伸縮性與可用性：

可跨越從運行Windows 95/98的膝上型電腦到運行Windows 2000的大型多處理器等多種平臺使用。另外，對聯合服務器，索引視圖等的支持，使得SQL Server 2000企業版可以升級到最大Web站點所需的性能級別。

》企業級數據庫功能：

SQL Server 2000分布式查詢可以引用來自不同數據庫的數據，而且這些對于用戶來說是完全透明的；分布式數據庫將保證任何分布式數據更新時的完整性；復制可以使我們能夠維護多個數據復本，這些用戶能夠自主地進行工作，然后再將所做的修改合并到發布數據庫；SQL Server 2000關系數據庫引擎能夠充分保護數據完整性，還可以將管理并發修改數據庫開銷到最小。

》易于安裝，部署和使用：

SQL Server 2000由一系列的管理和開發工具組成，這些工具使得在多個站點上進行SQL Server的安裝，部署，管理和使用變得更加容易。開發人員可以更加快速地交付SQL Server應用程序，而且只需要進行最少的安裝和管理就可以實現這些應用程序。

》數據倉庫：

數據倉庫是SQL Server 2000中包含的用于分析取和分析匯總數據以進行聯機分析處理的工具。這個功能只在Oracle和其他更昂貴的DBMS中才有。

1.1.1 SQL Server 2000新特性

全面擴展了SQL Server 7.0的性能，可靠性和易用性。增加了一系列的功能，具體如下：

》在關系數據庫方面的增強

》圖形管理增強

》增強的聯合數據庫服務器

1.2 SQL Server 2000工具和實用程序

1、企業管理器 2、服務管理器 3、查詢分析器 4、事件探查器

5、導入和導出數據 6、服務器網絡使用工具 7、客戶端網絡使用工具 8、聯機幫助文檔

1.2.1 企業管理器

企業管理器是基于一種新的被稱為微軟管理控制臺（Microsoft Management Console)的公共服務器管理環境，它是SQL Server 2000中最重要的一個管理工具。

企業管理器不僅能夠配置系統環境和管理SQL Server，而且由于它能夠以層疊列表的形式來顯示所有的SQL Server對象，因而所有SQL Server對象的建立與管理都可以通過它來完成。

用企業管理可以完成的操作

》管理SQL Server服務器；建立與管理數據庫；建立與管理表、視圖、存儲過程、觸發程序、角色、規則、默認值等數據庫對象，以及用戶定義的數據類型；備份數據庫和事務日志、

恢復數據庫；復制數據庫；設置任務調度；設置警報；提供跨服務器的拖放控制操作；管理用戶賬戶；建立Transact-SQL命令語句以及管理和控制SQL Mail。

》在企業管理器中包含兩個窗口，左側的窗口是以“樹狀目錄”顯示的活動窗口，右側是顯示內容的窗口。

》單擊左側窗口中的加號，可以展開各個項目包含的子項目。

》通過選中的某個項目的節點，可以在右側的窗口中看到該項目包含的內容。

1.2.2服務管理器（Service Manager）

1、SQL Server服務管理器是在服務器端實際工作時最有用的實用程序，服務管理器用來啟動、暫停、繼續和停止數據庫服務器的實時服務，其提供的服務類型包括：SQL Server、SQL Server代理、Microsoft搜索和分布式事務協調器等。

A relational database, SQL Server

1, by Microsoft SQL Server is the development and popularization of relational database system (DBMS), which was originally by Microsoft, and Ashton Sybase Tate - three companies and joint development, launched in 1988, the first OS / 2 version.

2 and relational database management system (RDBMS) function:

"Maintaining the relationship between database data,

"Ensure the correctness of the data storage,

"When a system fault, all data recovery to ensure consistent done some condition

3, RDBMS: SQL Server, Oracle, DB / 2, Sybase Informix,

4 and amplified RDBMS (File - based) : Foxpro, Access

Second, SQL Server 2000 version

1 and SQL Server 2000 common version:

"Enterprise Edition (Enterprise Edition),

Support all SQL Server 2000 function. This version for large and medium-sized products, and can support the database server, large web companies OLTP (online transaction processing) and large data warehouse system (on-line analytical processing (OLAP) required performance.

"Standard version (Standard Edition),

A small range of practical working or departments. It supports most SQL Server2000 function. But, do not have support large database, data warehouse and the functionality of the site. And don't support all the relations of the database engine.

"Personal Edition (Personal Edition),

Mainly used in mobile users, because they often disconnected, and from the network of applications running still need SQL Server 2000 support. Besides the transaction copy, able to support all functions of SQL Server 2000 standard version of the support.

"Edition) Developer Edition (Developer

Suitable application development version, support except graphical Server2000 SQL language setting beyond all the other functions. This version is mainly used in the programmer development application, will SQL Server 2000 as data storage area. Although development version of the function, but only authorized for a development and testing system, not a product server.

1.1 SQL Server features

With the integration of the Internet:

SQL Server 2000 database engine comprehensive support XML Language, creating take (extensible Markup Language), that the user can easily be database data released to the Web page.

"Scalability and usability:

Can span from running Windows 95, 98 / the laptop to run Windows 2000 large-scale multiple processors etc. Various platforms. In addition, to jointly Server, etc, the support index view that SQL Server 2000 enterprise edition can upgrade to the largest Web site desired performance level.

"Enterprise databases functions:

SQL Server 2000 distributed query can quote from different database data, and these are completely transparent to users, Distributed database will ensure that any distributed data update integrity, Copy can enable us to maintain multiple data available, the user can work independently, and then will be done by modified merged into the database, SQL Server 2000 relational database engine can fully protect data integrity, still can be modified database management concurrent cost to a minimum.

"Easy to install, deployment and use:

SQL Server 2000 by a series of management and development tools, these tools at multiple sites on SQL Server installation, deploy, manage and use more easily. Developers can more quickly deliver SQL Server applications and requires only the least installation and management can achieve these applications.

"Data warehouse:

The data warehouse is SQL Server 2000 contains for analysis and summary data analysis on on-line analytical processing tools. This function only in Oracle and other more expensive DBMS.

1.1.1 SQL Server 2000 new features

Fully expanded the SQL Server 7.0 performance, reliability and usability. Increases the range of functions, specific as follows:

In the aspect of relational database

"Graphics management enhancement

The combination of enhanced database server

1.2 SQL Server 2000 tools, and utilities

1, enterprise management, service management 3, 4, event detection query parsers

5 and 6, the input and output data network, server client to use tools, tools Internet use online documentation

1.2.1 enterprise management

Enterprise Management is based on a new called Microsoft Management Console (r) of public Management Microsoft Server Management environment, it is the SQL Server 2000 in one of the most important Management tools.

Enterprise management can not only configuration system environment and management, but also because it SQL Server can cascade form to list all the SQL Server object, so all the SQL Server object of establishment and management can be accomplished by it.

In enterprise management can finish operation

"Management SQL Server Server. Establish and manage database, Establish and manage, view, storage process, triggering role, rules, procedures, by default, such as user defined object database of data types, Backup database and transaction log,

Restore database, Copy database, Set task scheduling, Set alarm, Provide cross-server drag-and-drop controls operating, Manage the user accounts, Establish Transact - SQL commands and the management and control of the SQL statement E-mail.

"In the enterprise management in the window contains two on" the window "directory tree right is the active window, showing the contents of the window.

"The window, click on various projects can deploy plus committeeapos contains.

"Through a project of the selected node in the window, can see on this project contains the content.

1.2.2 Service Manager (up) Service

1 and SQL Server service manager is in practical work when the Server is most practical program, service management is to start, stop, and continue to suspend the real-time database Server service, the service provided types include: SQL Server, SQL Server proxy, Microsoft search and distributed coordination, etc.

給分的啊 累死了！！

高分求翻譯一小段文章，急

【中英對照譯文如下】：

學生成績管理系統是一個教育單位不可缺少的部分,它的內容對于學校的決策者

和管理者來說都至關重要。

Student score management system is an essential part for an education unit. Its content plays an important role to decision makers and administrators of a school.

本系統主要用于在校學生成績的日常管理。該系統界面友好，操作簡單，易學易用，從總體方案上力求達到該軟件所需的目標要求。

This system was mainly developed for daily management of student score which has a great user-friendly interface with the feature of both easy to operate and easy to learn. It follows after all needs of the software demands on the general scheme.

在開發過程中注意使其符合操作的業務流程，并力求系統的全面性、通用性，使

得本系統不只適用于一家教育機構。

In the whole software development, it very accords with operation flow and follows after the comprehensiveness and universality for the system, which can be applicable to more than one educational institution.

在開發方法的選擇上，選擇了生命周期法與原型法相結合的方法，遵循系統調查研究、系統分析、系統設計和系統實施四個主要階段進行設計，而在具體的設計上，采取了演化式原型法，隨著用戶的使用及對系統了解的不斷加深，對某一部分或幾部分進行重新分析、設計、實施。

Concerning the development approach, used the combination of life cycle method and prototyping approach, the system was designed abide by four major stages, which are systematic investigation and study, systems analysis, system design and systems implementation. Its planning design, adopted Evolutionary Prototyping Method and keep deepening along with facilitating the users and their understanding about the system, then aiming at a certain part of several parts to redo the analysis, design and put into operation.

本論文主要講述了利用Asp.net+sqlserver開發的一個基于web的學生成績管理系統，通過開發此系統，文中探討了基于.net的web設計與開發，詳細講述數據庫的開發以及核心程序的具體實現，提供了一套比較完善的學生成績WEB系統開發方案。論文主要從系統分析、系統設計、系統實施與使用等幾個方面進行介紹。

This paper mainly discusses about by using Asp.net + SQL Server to develop a student score management system based on web, and to discuss the web design and development on the basis of “.net”, explaining the details of the development of databases as well as the implementations of kernel program, so as to provide a preferably perfect development program for student test scours’ web system. This paper mainly introduces from aspects, namely systems analysis, system design, and systems implementation.

---------------------{ 請詳閱譯文內容，如有問題可聯系}------------------

Sql翻譯器怎么實現

標準sql+一個翻頁支持就可以了。

提供一個mssql的

package com.cat.xtools.data;

import java.io.PrintStream;

import org.hibernate.dialect.SQLServerDialect;

public class MsSqlDialect extends SQLServerDialect

{

public MsSqlDialect()

{

}

public String getLimitString(String sql, int offset, int limit)

{

if(offset == 0)

{

return super.getLimitString(sql, 0, limit);

}

String sqlTemp = super.getLimitString(sql, 0, limit);

String orderby = getOrderby(sql);

if(orderby.equals(""))

{

sqlTemp = super.getLimitString((new StringBuilder("select * from (")).append(sqlTemp).append(") cat_sql_temp_000").toString(), 0, (limit - offset) + 1);

} else

{

sqlTemp = super.getLimitString((new StringBuilder("select * from (")).append(sqlTemp).append(") cat_sql_temp_000 order by ").append(orderby).toString(), 0, (limit - offset) + 1);

}

return sqlTemp;

}

private static String getOrderby(String sql)

{

String orderby = "";

int lastk = sql.lastIndexOf(")");

int lasto = sql.toLowerCase().lastIndexOf("order by");

if(lastk lasto lastk -1 || lastk == lasto)

{

return "";

}

orderby = sql.substring(lasto + 8, sql.length());

String os[] = orderby.split(",");

String nob = "";

for(int i = 0; i os.length; i++)

{

int dian = os[i].indexOf(".");

if(dian -1)

{

os[i] = os[i].substring(dian + 1, os[i].length());

}

String colums[] = os[i].trim().split(" ");

String cm = colums[0];

int as = 0;

as = sql.indexOf((new StringBuilder(" ")).append(colums[0]).append(" as ").toString());

if(as 0)

{

as = sql.indexOf((new StringBuilder(",")).append(colums[0]).append(" as ").toString());

}

if(as 0)

{

as = sql.indexOf((new StringBuilder(".")).append(colums[0]).append(" as ").toString());

}

if(as -1)

{

as += (new StringBuilder(".")).append(colums[0]).append(" as ").toString().length();

int end = sql.indexOf(" ", as);

if(end 0 || end sql.indexOf(",", as) sql.indexOf(",", as) -1)

{

end = sql.indexOf(",", as);

}

if(end -1)

{

cm = sql.substring(as, end);

}

}

if(colums.length 2)

{

nob = (new StringBuilder(String.valueOf(nob))).append(",").append(cm).append(" desc").toString();

} else

if(colums[1].toLowerCase().equals("asc"))

{

nob = (new StringBuilder(String.valueOf(nob))).append(",").append(cm).append(" desc").toString();

} else

{

nob = (new StringBuilder(String.valueOf(nob))).append(",").append(cm).append(" asc").toString();

}

}

if(nob.length() 0)

{

nob = nob.substring(1, nob.length());

}

return nob;

}

public static void main(String args[])

{

MsSqlDialect d = new MsSqlDialect();

System.out.println(d.getLimitString("SELECT * FROM HtmlLabelIndex", 1, 1));

}

}

網頁標題：sqlserver翻譯器,數據庫語句翻譯軟件
轉載注明：http://vcdvsql.cn/article38/dsiespp.html

成都網站建設公司_創新互聯，為您提供營銷型網站建設、、外貿建站、網站收錄、品牌網站制作、做網站

廣告

聲明：本網站發布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創新互聯