Click here to Skip to main content
15,882,278 members
Home / Discussions / Database
   

Database

 
AnswerRe: How can I update databse record on application ending explicitly(power failure) Pin
Rocky#17-Dec-07 23:03
Rocky#17-Dec-07 23:03 
AnswerRe: How can I update databse record on application ending explicitly(power failure) Pin
Pete O'Hanlon17-Dec-07 23:49
mvePete O'Hanlon17-Dec-07 23:49 
GeneralRe: How can I update databse record on application ending explicitly(power failure) Pin
Rocky#18-Dec-07 0:30
Rocky#18-Dec-07 0:30 
GeneralRe: How can I update databse record on application ending explicitly(power failure) Pin
Pete O'Hanlon18-Dec-07 1:16
mvePete O'Hanlon18-Dec-07 1:16 
GeneralSql2005: How to get the error msg thrown from Storedproc to C# class Pin
kssknov17-Dec-07 19:58
kssknov17-Dec-07 19:58 
GeneralRe: Sql2005: How to get the error msg thrown from Storedproc to C# class Pin
That's Aragon17-Dec-07 21:46
That's Aragon17-Dec-07 21:46 
QuestionRe: Sql2005: How to get the error msg thrown from Storedproc to C# class Pin
kssknov18-Dec-07 21:02
kssknov18-Dec-07 21:02 
GeneralProblem in writing a stored procedure in SQL SERVER 2000 Pin
Member 305788717-Dec-07 19:41
Member 305788717-Dec-07 19:41 
Hi,
I have a problem in writing a query in SQLSERVER 2000. I have 2 tables tblemployees and tblbank. Fields in the tables

tblemployees tblbank
empid empname paymode empbankid bankid bankname

empbankid in tblemployees is a foreign key of bankid in tblbank.

some employees will have paymode as cheque or cash. I that the bankid field in tblemployees will be null.
Now I want a result set as below

empid empname paymode bankname

for this i have written a query like below

select tblemployees.empid,tblemployees.empname,tblemployees.paymode,tblbank.bankname from tblemployees,tblbank where tblemployees.empbankid=tblbank.bankid

The Actual problem comes now. This query is not retrieving employees who have bankid as null. For employees who do not have bank id the bank name should be displayed as null and the remaining fields should be displayed as it is.

Please help me with a solution for this problem
GeneralRe: Problem in writing a stored procedure in SQL SERVER 2000 Pin
pmarfleet17-Dec-07 21:41
pmarfleet17-Dec-07 21:41 
GeneralQuery regarding SQL Pin
sandhya1417-Dec-07 18:45
sandhya1417-Dec-07 18:45 
GeneralRe: Query regarding SQL Pin
That's Aragon17-Dec-07 18:52
That's Aragon17-Dec-07 18:52 
GeneralRe: Query regarding SQL Pin
sandhya1418-Dec-07 1:05
sandhya1418-Dec-07 1:05 
QuestionInsert vs Update Pin
Yusuf17-Dec-07 7:38
Yusuf17-Dec-07 7:38 
GeneralRe: Insert vs Update Pin
Colin Angus Mackay17-Dec-07 8:01
Colin Angus Mackay17-Dec-07 8:01 
GeneralRe: Insert vs Update Pin
GuyThiebaut17-Dec-07 8:51
professionalGuyThiebaut17-Dec-07 8:51 
QuestionFinding triggers that are disabled or not? Pin
Syed Mujtaba Hassan17-Dec-07 0:29
Syed Mujtaba Hassan17-Dec-07 0:29 
AnswerRe: Finding triggers that are disabled or not? Pin
GuyThiebaut17-Dec-07 0:43
professionalGuyThiebaut17-Dec-07 0:43 
Generalhijri calender with sql server 2005 Pin
Ahmad Adnan16-Dec-07 22:38
Ahmad Adnan16-Dec-07 22:38 
GeneralRe: hijri calender with sql server 2005 Pin
GuyThiebaut17-Dec-07 1:30
professionalGuyThiebaut17-Dec-07 1:30 
GeneralMySql database does not store "\" (backward slash) when query using vb.net Pin
Rupesh Kumar Swami16-Dec-07 21:16
Rupesh Kumar Swami16-Dec-07 21:16 
GeneralRe: MySql database does not store "\" (backward slash) when query using vb.net Pin
Giorgi Dalakishvili16-Dec-07 22:00
mentorGiorgi Dalakishvili16-Dec-07 22:00 
QuestionC# : How to get the server machine's current date and time? Pin
kssknov16-Dec-07 20:34
kssknov16-Dec-07 20:34 
AnswerRe: C# : How to get the server machine's current date and time? [modified] Pin
Tobias Schoenig16-Dec-07 21:42
Tobias Schoenig16-Dec-07 21:42 
Generalpopulating Access table field with charater variable Pin
Amanjot16-Dec-07 13:18
Amanjot16-Dec-07 13:18 
GeneralRe: populating Access table field with charater variable Pin
ChandraRam16-Dec-07 23:08
ChandraRam16-Dec-07 23:08 

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.