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

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

創(chuàng)新互聯(lián)成都企業(yè)網(wǎng)站建設(shè)服務(wù)，提供網(wǎng)站建設(shè)、網(wǎng)站設(shè)計網(wǎng)站開發(fā),網(wǎng)站定制,建網(wǎng)站,網(wǎng)站搭建,網(wǎng)站設(shè)計,自適應(yīng)網(wǎng)站建設(shè),網(wǎng)頁設(shè)計師打造企業(yè)風(fēng)格網(wǎng)站,提供周到的售前咨詢和貼心的售后服務(wù)。歡迎咨詢做網(wǎng)站需要多少錢: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試試進行連接。

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

SQLserver 2000英文和中文翻譯

一、SQL Server關(guān)系數(shù)據(jù)庫簡介

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

2、關(guān)系數(shù)據(jù)庫（RDBMS)管理系統(tǒng)功能：

》維護數(shù)據(jù)庫數(shù)據(jù)之間的關(guān)系；

》保證數(shù)據(jù)存儲的正確性；

》當出現(xiàn)系統(tǒng)故障的時候，將所有數(shù)據(jù)恢復(fù)到能夠保證一致行的某種狀態(tài)

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

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

二、SQL Server 2000的版本

1、SQL Server 2000常見版本有：

》企業(yè)版（Enterprise Edition）

支持所有SQL Server 2000的功能。該版本多用于大中型產(chǎn)品數(shù)據(jù)庫服務(wù)器，并且可以支持大型網(wǎng)站，企業(yè)OLTP（聯(lián)機事務(wù)處理）和大型數(shù)據(jù)倉庫系統(tǒng)OLAP(聯(lián)機分析處理）所要求的性能。

》標準版（Standard Edition）

實用范圍是小型的工作組或部門。它支持大多數(shù)的SQL Server2000功能。但是，不具有支持大型數(shù)據(jù)庫，數(shù)據(jù)倉庫和網(wǎng)站的功能。而且，不支持所有的關(guān)系數(shù)據(jù)庫引擎的功能。

》個人版（Personal Edition）

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

》開發(fā)者版（Developer Edition）

適用于應(yīng)用程序開發(fā)的版本，支持除圖形化語言設(shè)置以外的SQL Server2000的所有其它功能。該版本主要適用于程序員在開發(fā)應(yīng)用程序時，將SQL Server 2000作為其數(shù)據(jù)存儲區(qū)。雖然開發(fā)版的功能齊備，但是只被授權(quán)為一個開發(fā)和測試系統(tǒng)，而不是一個產(chǎn)品服務(wù)器。

1.1 SQL Server特點

》與因特網(wǎng)的集成：

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

》可伸縮性與可用性：

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

》企業(yè)級數(shù)據(jù)庫功能：

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

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

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

》數(shù)據(jù)倉庫：

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

1.1.1 SQL Server 2000新特性

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

》在關(guān)系數(shù)據(jù)庫方面的增強

》圖形管理增強

》增強的聯(lián)合數(shù)據(jù)庫服務(wù)器

1.2 SQL Server 2000工具和實用程序

1、企業(yè)管理器 2、服務(wù)管理器 3、查詢分析器 4、事件探查器

5、導(dǎo)入和導(dǎo)出數(shù)據(jù) 6、服務(wù)器網(wǎng)絡(luò)使用工具 7、客戶端網(wǎng)絡(luò)使用工具 8、聯(lián)機幫助文檔

1.2.1 企業(yè)管理器

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

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

用企業(yè)管理可以完成的操作

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

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

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

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

》通過選中的某個項目的節(jié)點，可以在右側(cè)的窗口中看到該項目包含的內(nèi)容。

1.2.2服務(wù)管理器（Service Manager）

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

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.

給分的啊 累死了！！

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

【中英對照譯文如下】：

學(xué)生成績管理系統(tǒng)是一個教育單位不可缺少的部分,它的內(nèi)容對于學(xué)校的決策者

和管理者來說都至關(guān)重要。

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.

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

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.

在開發(fā)過程中注意使其符合操作的業(yè)務(wù)流程，并力求系統(tǒng)的全面性、通用性，使

得本系統(tǒng)不只適用于一家教育機構(gòu)。

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.

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

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開發(fā)的一個基于web的學(xué)生成績管理系統(tǒng)，通過開發(fā)此系統(tǒng)，文中探討了基于.net的web設(shè)計與開發(fā)，詳細講述數(shù)據(jù)庫的開發(fā)以及核心程序的具體實現(xiàn)，提供了一套比較完善的學(xué)生成績WEB系統(tǒng)開發(fā)方案。論文主要從系統(tǒng)分析、系統(tǒng)設(shè)計、系統(tǒng)實施與使用等幾個方面進行介紹。

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.

---------------------{ 請詳閱譯文內(nèi)容，如有問題可聯(lián)系}------------------

Sql翻譯器怎么實現(xiàn)

標準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));

}

}

網(wǎng)頁標題：sqlserver翻譯器,數(shù)據(jù)庫語句翻譯軟件
轉(zhuǎn)載注明：http://aaarwkj.com/article38/dsiespp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供營銷型網(wǎng)站建設(shè)、、外貿(mào)建站、網(wǎng)站收錄、品牌網(wǎng)站制作、做網(wǎng)站

廣告

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