GO ALTER procedure [dbo].[sp_InsertImage] @Image varbinary(max), @Date datetime, @Uploader int as Insert into ImageTable(img) values(@Image); Insert into ImageDetails(makerid,createdon,homakerid) values(@Uploader,@Date,(select top 1 sno from imagetable order by sno desc))
Insert into ImageTable(img) values(@Image); DECLARE @Id INTEGER SET @Id = SCOPE_IDENTITY() Insert into ImageDetails(makerid,createdon,homakerid) values(@Uploader,@Date,@Id)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)