Click here to Skip to main content
14,548,943 members
   

Database

 
GeneralRe: Persisted Primary Key? Pin
Jörgen Andersson14-Mar-13 7:21
professionalJö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
professionalMycroft 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
H JJ12-Mar-13 19:34
MemberH 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
professionalShameel12-Mar-13 20:26 
GeneralRe: Clarification on SQL Server Function? Pin
Shameel12-Mar-13 23:01
professionalShameel12-Mar-13 23:01 
AnswerRe: Clarification on SQL Server Function? Pin
Mycroft Holmes12-Mar-13 20:44
professionalMycroft Holmes12-Mar-13 20:44 
GeneralRe: Clarification on SQL Server Function? Pin
Mycroft Holmes13-Mar-13 21:20
professionalMycroft Holmes13-Mar-13 21:20 
AnswerRe: Clarification on SQL Server Function? Pin
uspatel13-Mar-13 2:00
professionaluspatel13-Mar-13 2:00 
QuestionArithmetic overflow error converting expression to data type nvarchar. Pin
Vimalsoft(Pty) Ltd12-Mar-13 10:19
professionalVimalsoft(Pty) Ltd12-Mar-13 10:19 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Mycroft Holmes12-Mar-13 12:35
professionalMycroft Holmes12-Mar-13 12:35 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Richard Deeming13-Mar-13 2:18
mveRichard 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
professionalJö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
professionalMycroft 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
professionalMycroft 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
Anubhava Dimri11-Mar-13 22:11
MemberAnubhava Dimri11-Mar-13 22:11 
AnswerRe: How to Recover the Data if the Delete Query is Fire?? Pin
Mycroft Holmes11-Mar-13 22:40
professionalMycroft 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.