Viewing 9 posts - 1 through 9 (of 9 total)
Ok , thank you , I will 🙂
May 23, 2014 at 3:09 pm
It seems it works but it asked about the time which is CURRENT_TIMESTAMP , it supposed to get the current time of the system automatically ,right!
May 23, 2014 at 2:41 pm
this my stored procedure and I'm sorry about names
ALTER proc [dbo].[storedP]
(@prdctName nvarchar(50)
,@ordrdQnty int
,@OrderID int
,@ordrPrice money
,@TrnDate datetime
,@TrnTotal money)
as
BEGIN TRY
begin transaction trs
DECLARE @TrnId int
SET @TrnId = 'SCOPE_IDENTITY'
INSERT INTO [dbo].[OrderProduct]
([OrdrId],
[prdctName]
,[ordrdQnty]
,[ordrPrice]
,[TrnId])
VALUES
(@OrderID,
@prdctName
,@ordrdQnty
,@ordrPrice
,@TrnId
)
INSERT...
May 23, 2014 at 9:19 am
It's yes 🙂 ,but I've used IDENTITY as SET @TrnId = 'SCOPE_IDENTITY', but it doesn't work I don't know how
May 23, 2014 at 9:05 am
I want to fill the two tables at the same time but I don't know how to do that, It's not many to many relationship I think , they are...
May 23, 2014 at 8:52 am
Thank you @sean Lange for your reply and your valuable words I will edit my table and SP names ,
well I've faced difficulties to join more than...
May 21, 2014 at 2:41 am
I really want help
May 13, 2014 at 3:50 pm
Viewing 9 posts - 1 through 9 (of 9 total)