如何将Oracle查询转换为sql server中的存储过程? [英] how to convert Oracle query into stored procedure in sql server ?
本文介绍了如何将Oracle查询转换为sql server中的存储过程?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何将以下Oracle查询转换为sql server中的存储过程
insert into audit_upload_log
(AUL_UPLOAD_ID,AUL_SLA_CATEORY,AUL_FROM_DATE,AUL_TO_DATE,AUL_USER_FILE_NAME,AUL_SAVED_FILE_NAME,AUL_UPLOADED_DATE,AUL_UPLOADED_BY)
values (seq_audit_id_audit_upload_log.NEXTVAL,
' + DropDownList1.SelectedItem。值+',
' + TextBox1.Text +' ,' + TextBox2.Text +',' + filename +',' + new_file_name +',
to_date(' + DateTime.Now.ToL ocalTime()。ToString(dd / MM / yyyy HH:mm:ss)+',' dd / mm / yyyy hh24:mi:ss'),
' + HttpContext.Current.User.Identity.Name +')
解决方案
您不需要seq_audit_id_audit_upload_log.NEXTVAL;而是将AUL_UPLOAD_ID列声明为IDENTITY
CREATE PROCEDURE SQL_Procedure
@ AUL_SLA_CATEORY NVARCHAR ( 255 ),
@ AUL_FROM_DATE DATETIME ,
@ AUL_TO_DATE DATETIME ,
@AUL_USER_FILE_NAME NVARCHAR ( 255 ),
@ AUL_SAVED_FILE_NAME NVARCHAR ( 255 ),
@ AUL_UPLOADED_BY NVARCHAR ( 255 )
AS
BEGIN
- SET NOCOUNT ON已添加到阻止额外的结果集
- 干扰SELECT语句。
SET NOCOUNT ON ;
INSERT INTO audit_upload_log
(AUL_SLA_CATEORY,AUL_FROM_DATE,AUL_TO_DATE, AUL_USER_FILE_NAME,AUL_SAVED_FILE_NAME,AUL_UPLOADED_DATE,AUL_UPLOADED_BY)
VALUES ( @ AUL_SLA_CATEORY , @ AUL_FROM_DATE , @ AUL_TO_DATE , @ AUL_USER_FILE_NAME , @ AUL_SAVED_FILE_NAME ,GETDATE(), @ AUL_UPLOADED_BY )
结束
添加代码块
how to convert below Oracle query into stored procedure in sql server
insert into audit_upload_log
(AUL_UPLOAD_ID,AUL_SLA_CATEORY,AUL_FROM_DATE,AUL_TO_DATE,AUL_USER_FILE_NAME,AUL_SAVED_FILE_NAME,AUL_UPLOADED_DATE,AUL_UPLOADED_BY)
values (seq_audit_id_audit_upload_log.NEXTVAL,
'" + DropDownList1.SelectedItem.Value + "',
'" + TextBox1.Text + "','" + TextBox2.Text + "','" + filename + "','" + new_file_name + "',
to_date('" + DateTime.Now.ToLocalTime().ToString("dd/MM/yyyy HH:mm:ss") + "','dd/mm/yyyy hh24:mi:ss'),
'" + HttpContext.Current.User.Identity.Name + "')
解决方案
You will not need seq_audit_id_audit_upload_log.NEXTVAL; instead declare column AUL_UPLOAD_ID as IDENTITY
CREATE PROCEDURE SQL_Procedure @AUL_SLA_CATEORY NVARCHAR(255), @AUL_FROM_DATE DATETIME, @AUL_TO_DATE DATETIME, @AUL_USER_FILE_NAME NVARCHAR(255), @AUL_SAVED_FILE_NAME NVARCHAR(255), @AUL_UPLOADED_BY NVARCHAR(255) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; INSERT INTO audit_upload_log (AUL_SLA_CATEORY,AUL_FROM_DATE,AUL_TO_DATE,AUL_USER_FILE_NAME,AUL_SAVED_FILE_NAME,AUL_UPLOADED_DATE,AUL_UPLOADED_BY) VALUES (@AUL_SLA_CATEORY, @AUL_FROM_DATE, @AUL_TO_DATE, @AUL_USER_FILE_NAME , @AUL_SAVED_FILE_NAME, GETDATE(), @AUL_UPLOADED_BY) END
code block added
这篇关于如何将Oracle查询转换为sql server中的存储过程?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文