Click here to Skip to main content
13,509,654 members
   

Database

 
GeneralRe: Persisted Primary Key? Pin
Jörgen Andersson14-Mar-13 7:21
memberJörgen Andersson14-Mar-13 7:21 
QuestionWant to get data on weekly basis Pin
VishwaKL12-Mar-13 23:07
memberVishwaKL12-Mar-13 23:07 
AnswerRe: Want to get data on weekly basis Pin
Mycroft Holmes13-Mar-13 2:15
memberMycroft Holmes13-Mar-13 2:15 
AnswerRe: Want to get data on weekly basis Pin
Davidduraisamy13-Mar-13 20:44
memberDavidduraisamy13-Mar-13 20:44 
GeneralRe: Want to get data on weekly basis Pin
VishwaKL14-Mar-13 22:16
memberVishwaKL14-Mar-13 22:16 
GeneralRe: Want to get data on weekly basis Pin
Davidduraisamy14-Mar-13 22:23
memberDavidduraisamy14-Mar-13 22:23 
GeneralRe: Want to get data on weekly basis Pin
VishwaKL17-Mar-13 23:02
memberVishwaKL17-Mar-13 23:02 
QuestionClarification on SQL Server Function? Pin
HARI JJ12-Mar-13 19:34
memberHARI JJ12-Mar-13 19:34 
Friends,
Need one big helpSmile | :) Getting error while creating function in SQL Server. Pls help to resolve the issue.

FYI, the inputs as follows. -

Function name: func_check_seat_availability

Description: The function will check for the availability of seats in a particular bus on a given day.

Input Parameters: in_bus_No, in_DateOfJourney, in_NoOfAdults, in_NoOfChildren.

Return Values: Return 1 if the seats are available, else return 0.

Table details:
Column Data Type Constraints
-----------------------------------------------------------
BookingId Varchar(4) P_Key, Starts with B100
-----------------------------------------------------------
BusNo Int (REFERENCES tbl_busdetails)
-----------------------------------------------------------
CustomerId Int (REFERENCES tbl_Customer)
-----------------------------------------------------------
DateOfBooking DateTime
-----------------------------------------------------------
DateOfJourney DateTime DateOfJourney>=DateOfBooking
-----------------------------------------------------------
NoOfAdults Int Greater than zero
-----------------------------------------------------------
NoOfChildren Int Greater than or = to zero
-----------------------------------------------------------
AnswerRe: Clarification on SQL Server Function? Pin
Shameel12-Mar-13 20:26
memberShameel12-Mar-13 20:26 
GeneralRe: Clarification on SQL Server Function? Pin
Shameel12-Mar-13 23:01
memberShameel12-Mar-13 23:01 
AnswerRe: Clarification on SQL Server Function? Pin
Mycroft Holmes12-Mar-13 20:44
memberMycroft Holmes12-Mar-13 20:44 
GeneralRe: Clarification on SQL Server Function? Pin
Mycroft Holmes13-Mar-13 21:20
memberMycroft Holmes13-Mar-13 21:20 
AnswerRe: Clarification on SQL Server Function? Pin
Uma Shankar Patel13-Mar-13 2:00
memberUma Shankar Patel13-Mar-13 2:00 
QuestionArithmetic overflow error converting expression to data type nvarchar. Pin
Vuyiswa Maseko12-Mar-13 10:19
memberVuyiswa Maseko12-Mar-13 10:19 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Mycroft Holmes12-Mar-13 12:35
memberMycroft Holmes12-Mar-13 12:35 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Richard Deeming13-Mar-13 2:18
memberRichard Deeming13-Mar-13 2:18 
Questionput a condition in join query Pin
demoninside912-Mar-13 1:38
memberdemoninside912-Mar-13 1:38 
AnswerRe: put a condition in join query Pin
Jörgen Andersson12-Mar-13 2:19
memberJörgen Andersson12-Mar-13 2:19 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 18:47
memberdemoninside912-Mar-13 18:47 
GeneralRe: put a condition in join query Pin
Mycroft Holmes12-Mar-13 20:40
memberMycroft Holmes12-Mar-13 20:40 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 20:49
memberdemoninside912-Mar-13 20:49 
GeneralRe: put a condition in join query Pin
Mycroft Holmes12-Mar-13 22:23
memberMycroft Holmes12-Mar-13 22:23 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 22:39
memberdemoninside912-Mar-13 22:39 
QuestionHow to Recover the Data if the Delete Query is Fire?? Pin
eg_Anubhava11-Mar-13 22:11
membereg_Anubhava11-Mar-13 22:11 
AnswerRe: How to Recover the Data if the Delete Query is Fire?? Pin
Mycroft Holmes11-Mar-13 22:40
memberMycroft Holmes11-Mar-13 22:40 

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.


Advertise | Privacy |
Web03 | 2.8.180417.1 | Last Updated 24 Apr 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid