您不需要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