Click here to Skip to main content
11,437,713 members (48,334 online)
   

Database

 
GeneralRe: Persisted Primary Key? Pin
Jörgen Andersson14-Mar-13 8:21
memberJörgen Andersson14-Mar-13 8:21 
QuestionWant to get data on weekly basis Pin
VishwaKL13-Mar-13 0:07
memberVishwaKL13-Mar-13 0:07 
AnswerRe: Want to get data on weekly basis Pin
Mycroft Holmes13-Mar-13 3:15
memberMycroft Holmes13-Mar-13 3:15 
AnswerRe: Want to get data on weekly basis Pin
Davidduraisamy13-Mar-13 21:44
memberDavidduraisamy13-Mar-13 21:44 
GeneralRe: Want to get data on weekly basis Pin
VishwaKL14-Mar-13 23:16
memberVishwaKL14-Mar-13 23:16 
GeneralRe: Want to get data on weekly basis Pin
Davidduraisamy14-Mar-13 23:23
memberDavidduraisamy14-Mar-13 23:23 
GeneralRe: Want to get data on weekly basis Pin
VishwaKL18-Mar-13 0:02
memberVishwaKL18-Mar-13 0:02 
QuestionClarification on SQL Server Function? Pin
HARI JJ12-Mar-13 20:34
memberHARI JJ12-Mar-13 20: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 21:26
memberShameel12-Mar-13 21:26 
GeneralMessage Removed Pin
HARI JJ12-Mar-13 23:54
memberHARI JJ12-Mar-13 23:54 
GeneralRe: Clarification on SQL Server Function? Pin
Shameel13-Mar-13 0:01
memberShameel13-Mar-13 0:01 
AnswerRe: Clarification on SQL Server Function? Pin
Mycroft Holmes12-Mar-13 21:44
memberMycroft Holmes12-Mar-13 21:44 
GeneralMessage Removed Pin
HARI JJ12-Mar-13 23:55
memberHARI JJ12-Mar-13 23:55 
GeneralRe: Clarification on SQL Server Function? Pin
Mycroft Holmes13-Mar-13 22:20
memberMycroft Holmes13-Mar-13 22:20 
AnswerRe: Clarification on SQL Server Function? Pin
Uma Shankar Patel13-Mar-13 3:00
memberUma Shankar Patel13-Mar-13 3:00 
QuestionArithmetic overflow error converting expression to data type nvarchar. Pin
Vuyiswa Maseko12-Mar-13 11:19
memberVuyiswa Maseko12-Mar-13 11:19 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Mycroft Holmes12-Mar-13 13:35
memberMycroft Holmes12-Mar-13 13:35 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Richard Deeming13-Mar-13 3:18
memberRichard Deeming13-Mar-13 3:18 
Questionput a condition in join query Pin
demoninside912-Mar-13 2:38
memberdemoninside912-Mar-13 2:38 
AnswerRe: put a condition in join query Pin
Jörgen Andersson12-Mar-13 3:19
memberJörgen Andersson12-Mar-13 3:19 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 19:47
memberdemoninside912-Mar-13 19:47 
GeneralRe: put a condition in join query Pin
Mycroft Holmes12-Mar-13 21:40
memberMycroft Holmes12-Mar-13 21:40 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 21:49
memberdemoninside912-Mar-13 21:49 
GeneralRe: put a condition in join query Pin
Mycroft Holmes12-Mar-13 23:23
memberMycroft Holmes12-Mar-13 23:23 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 23:39
memberdemoninside912-Mar-13 23:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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 | Mobile
Web04 | 2.8.150506.1 | Last Updated 6 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid