IF OBJECT_ID(N'dbo.STP_Insert_FilesHistory', N'P') IS NOT NULL DROP PROCEDURE dbo.STP_Insert_FilesHistory; GO CREATE PROCEDURE dbo.STP_Insert_FilesHistory @FileName VARCHAR(255), @FileType VARCHAR(50) = NULL, @FileSize VARCHAR(50) = NULL, @UploadedBy VARCHAR(50), @UploadedDate DATETIME, @FileStatus VARCHAR(50), @FileLocation VARCHAR(500) = NULL, @Description VARCHAR(500) = NULL, @LoaderType VARCHAR(50) = NULL, @FTPUrl VARCHAR(255) = NULL, @FTPFileModifiedDate DATETIME = NULL, @FTPFilePath VARCHAR(255) = NULL, @ParentFileId INT = NULL, @ProcessNumber INT = NULL AS BEGIN SET NOCOUNT ON; SET DATEFORMAT ymd; INSERT INTO dbo.FilesHistory ( FileName, FileType, FileSize, UploadedBy, UploadedDate, FileStatus, FileLocation, [Description], LoaderType, FTPUrl, FTPFileModifiedDate, FTPFilePath, ParentFileId, ProcessNumber ) VALUES ( @FileName, @FileType, @FileSize, @UploadedBy, @UploadedDate, @FileStatus, @FileLocation, @Description, @LoaderType, @FTPUrl, @FTPFileModifiedDate, @FTPFilePath, @ParentFileId, @ProcessNumber ); SELECT CAST(SCOPE_IDENTITY() AS INT) AS NewId; END GO