Click here to Skip to main content
14,457,165 members
   

Database

 
GeneralRe: Persisted Primary Key? Pin
Jörgen Andersson14-Mar-13 8:21
communityengineerJö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
H JJ12-Mar-13 20:34
MemberH 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
professionalShameel12-Mar-13 21:26 
GeneralRe: Clarification on SQL Server Function? Pin
Shameel13-Mar-13 0:01
professionalShameel13-Mar-13 0:01 
AnswerRe: Clarification on SQL Server Function? Pin
Mycroft Holmes12-Mar-13 21:44
MemberMycroft Holmes12-Mar-13 21:44 
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
uspatel13-Mar-13 3:00
professionaluspatel13-Mar-13 3:00 
QuestionArithmetic overflow error converting expression to data type nvarchar. Pin
Vimalsoft(Pty) Ltd12-Mar-13 11:19
professionalVimalsoft(Pty) Ltd12-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
communityengineerRichard 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
communityengineerJö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 
QuestionHow to Recover the Data if the Delete Query is Fire?? Pin
Anubhava Dimri11-Mar-13 23:11
MemberAnubhava Dimri11-Mar-13 23:11 
AnswerRe: How to Recover the Data if the Delete Query is Fire?? Pin
Mycroft Holmes11-Mar-13 23:40
MemberMycroft Holmes11-Mar-13 23: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.