Can you please show how to change it. Here i show the original stored procedure.
Dont know where to put the select SCOPE_IDENTITY()
CREATE procedure mydomain.AddFile
@PortalId int,
@FileName nvarchar(100),
@Extension nvarchar(100),
@Size int,
@WIdth int,
@Height int,
@ContentType nvarchar(200),
@Folder nvarchar(200),
@FolderID int
as
insert into Files (
PortalId,
FileName,
Extension,
Size,
WIdth,
Height,
ContentType,
Folder,
FolderID
)
values (
@PortalId,
@FileName,
@Extension,
@Size,
@WIdth,
@Height,
@ContentType,
@Folder,
@FolderID
)
select SCOPE_IDENTITY()