| 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
|