Code:
...
-- Add the parameters for the stored procedure here
@topicid int,
@subject varchar(100),
@replies int,
@author varchar(100),
@lastpostdate datetime,
@thrid int,
@message varchar(max)
AS
BEGIN
SET IDENTITY_INSERT Threads ON
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
INSERT Threads
(topicid, "subject", replies, author, lastpostdate)
VALUES(@topicid, @subject, @replies,@author, @lastpostdate)
--e asd valjda ovde bi trebalo da izvucem ovaj key iz prve tabele i da ga smestim u thrid jel da??
INSERT Messages
(threadid, author, date, "message")
VALUES(@thrid, @author, @lastpostdate, @message)
END
...
-- Add the parameters for the stored procedure here
@topicid int,
@subject varchar(100),
@replies int,
@author varchar(100),
@lastpostdate datetime,
@thrid int,
@message varchar(max)
AS
BEGIN
SET IDENTITY_INSERT Threads ON
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
INSERT Threads
(topicid, "subject", replies, author, lastpostdate)
VALUES(@topicid, @subject, @replies,@author, @lastpostdate)
--e asd valjda ovde bi trebalo da izvucem ovaj key iz prve tabele i da ga smestim u thrid jel da??
INSERT Messages
(threadid, author, date, "message")
VALUES(@thrid, @author, @lastpostdate, @message)
END
svaki električni uređaj radi na beli dim koji se nalazi u njemu; kada beli dim izađe, uređaj više ne radi. 8-)