Click here to Skip to main content
14,359,240 members
   

Database

 
GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 6:58
membermjackson1119-Mar-13 6:58 
GeneralRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 7:07
professionalGuyThiebaut19-Mar-13 7:07 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 15:18
memberkalula17-Mar-13 15:18 
AnswerRe: how did i add calender to my site Pin
NotPolitcallyCorrect17-Mar-13 15:22
memberNotPolitcallyCorrect17-Mar-13 15:22 
AnswerRe: how did i add calender to my site Pin
Mycroft Holmes17-Mar-13 20:57
memberMycroft Holmes17-Mar-13 20:57 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 15:16
memberkalula17-Mar-13 15:16 
AnswerRe: how did i add calender to my site Pin
thatraja4-Oct-13 21:39
protectorthatraja4-Oct-13 21:39 
QuestionSkeptical about Trigger! Pin
Thiru615-Mar-13 0:10
memberThiru615-Mar-13 0:10 
Dude's,

want to insert the values in one table(say bookingtable),
the remaining seats column in another table must be suitably updated.

Trying to concept using of Triggers. Can I go with the following way? but my table is not updated. Pls help on this.

CREATE TRIGGER Trgupdtsts ON Table_FB2
FOR INSERT
AS
DECLARE @FNo INT,
@DOJRNY DATETIME,
@RMNGSTS INT

SELECT @FNO = i.FNO,
@DOJRNY = i.DOJRNY
FROM inserted i;
set @RMNGSTS = ("need to insert logic here?")--'Record Inserted'

INSERT INTO TBL_FSTS
(FNO , DOJRNY , RMNGSTS)
VALUES (@FNO , @DOJRNY , @RMNGSTS)
--select @RMNGSTS from inserted
QuestionRe: Skeptical about Trigger! Pin
gvprabu15-Mar-13 0:52
membergvprabu15-Mar-13 0:52 
AnswerRe: Skeptical about Trigger! Pin
Thiru616-Mar-13 0:22
memberThiru616-Mar-13 0:22 
SuggestionRe: Skeptical about Trigger! Pin
gvprabu17-Mar-13 19:37
membergvprabu17-Mar-13 19:37 
GeneralRe: Skeptical about Trigger! Pin
Thiru617-Mar-13 20:16
memberThiru617-Mar-13 20:16 
AnswerRe: Skeptical about Trigger! Pin
Mycroft Holmes15-Mar-13 0:58
memberMycroft Holmes15-Mar-13 0:58 
GeneralRe: Skeptical about Trigger! Pin
Jörgen Andersson15-Mar-13 3:16
protectorJörgen Andersson15-Mar-13 3:16 
GeneralRe: Skeptical about Trigger! Pin
Mycroft Holmes15-Mar-13 14:23
memberMycroft Holmes15-Mar-13 14:23 
GeneralRe: Skeptical about Trigger! Pin
Jörgen Andersson15-Mar-13 15:09
protectorJörgen Andersson15-Mar-13 15:09 
GeneralRe: Skeptical about Trigger! Pin
Thiru616-Mar-13 0:25
memberThiru616-Mar-13 0:25 
GeneralRe: Skeptical about Trigger! Pin
GuyThiebaut19-Mar-13 10:35
professionalGuyThiebaut19-Mar-13 10:35 
GeneralRe: Skeptical about Trigger! Pin
Jörgen Andersson19-Mar-13 11:28
protectorJörgen Andersson19-Mar-13 11:28 
QuestionDynamic Query for XML? Pin
kasimmohamed14-Mar-13 21:55
memberkasimmohamed14-Mar-13 21:55 
AnswerRe: Dynamic Query for XML? Pin
Mycroft Holmes15-Mar-13 0:55
memberMycroft Holmes15-Mar-13 0:55 
GeneralRe: Dynamic Query for XML? Pin
Shameel15-Mar-13 2:14
professionalShameel15-Mar-13 2:14 
GeneralRe: Dynamic Query for XML? Pin
Eddy Vluggen15-Mar-13 2:29
mveEddy Vluggen15-Mar-13 2:29 
GeneralRe: Dynamic Query for XML? Pin
Mycroft Holmes15-Mar-13 14:20
memberMycroft Holmes15-Mar-13 14:20 
QuestionRepeating Field in SSRS report. Pin
Laurence123414-Mar-13 1:44
memberLaurence123414-Mar-13 1:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.