Click here to Skip to main content
15,867,765 members
Home / Discussions / Database
   

Database

 
GeneralRe: pbroblem with smalldatetime Pin
Pete O'Hanlon3-Jan-08 1:12
subeditorPete O'Hanlon3-Jan-08 1:12 
GeneralRe: pbroblem with smalldatetime Pin
GuyThiebaut1-Jan-08 22:55
professionalGuyThiebaut1-Jan-08 22:55 
GeneralProblem in Stored Procedure in SQLSERVER 2000 Pin
Member 30578871-Jan-08 21:07
Member 30578871-Jan-08 21:07 
GeneralRe: Problem in Stored Procedure in SQLSERVER 2000 Pin
Michael Sync1-Jan-08 22:43
Michael Sync1-Jan-08 22:43 
QuestionSQL server is not connecting from client Pin
findtango1-Jan-08 19:41
findtango1-Jan-08 19:41 
GeneralRe: SQL server is not connecting from client Pin
Michael Sync1-Jan-08 22:44
Michael Sync1-Jan-08 22:44 
GeneralRe: SQL server is not connecting from client Pin
findtango2-Jan-08 1:14
findtango2-Jan-08 1:14 
GeneralUpdate 2 tables using triggers.., [modified] Pin
Member 38798811-Jan-08 19:23
Member 38798811-Jan-08 19:23 
Hi guys i need ur help in query...,
If any one knows plz hep mw with query,
See i have 2 tables like this:

Table1:
Key Id name

1 100 Mag
2 101 Kum
Table2:
Id M1 M2

100 50 50
101 60 55

Now i want to that table1 "kum" Id want to 100 & "Mag" Id want to 101..,
So i want to do update the records using key in table1...,
While updating the table1 id and name..,
The changes have to update in Table2 records also (Id,m1,m2)...,
In this case if i update it will affect the both record in same table itself...,
so i need proper updation, How to do that?

Thanks & Regards,
Mageshh,
please don't forget to vote on the post

modified on Wednesday, January 02, 2008 7:21:51 AM

QuestionHow to prevent records from ordering? Pin
Member 41215111-Jan-08 1:12
Member 41215111-Jan-08 1:12 
AnswerRe: How to prevent records from ordering? Pin
vimal_yet1-Jan-08 2:26
vimal_yet1-Jan-08 2:26 
GeneralRe: How to prevent records from ordering? Pin
Colin Angus Mackay1-Jan-08 12:37
Colin Angus Mackay1-Jan-08 12:37 
AnswerRe: How to prevent records from ordering? Pin
Colin Angus Mackay1-Jan-08 12:44
Colin Angus Mackay1-Jan-08 12:44 
AnswerRe: How to prevent records from ordering? Pin
andyharman2-Jan-08 3:59
professionalandyharman2-Jan-08 3:59 
Questionsql server next query Pin
Sonia Gupta31-Dec-07 21:00
Sonia Gupta31-Dec-07 21:00 
GeneralRe: sql server next query Pin
SimulationofSai31-Dec-07 21:24
SimulationofSai31-Dec-07 21:24 
GeneralRe: sql server next query Pin
Paddy Boyd2-Jan-08 1:30
Paddy Boyd2-Jan-08 1:30 
QuestionSuggestions please Pin
sindhutiwari31-Dec-07 19:31
sindhutiwari31-Dec-07 19:31 
GeneralRe: Suggestions please Pin
vimal_yet31-Dec-07 19:38
vimal_yet31-Dec-07 19:38 
GeneralRe: Suggestions please Pin
sindhutiwari31-Dec-07 19:53
sindhutiwari31-Dec-07 19:53 
GeneralRe: Suggestions please Pin
vimal_yet31-Dec-07 20:00
vimal_yet31-Dec-07 20:00 
GeneralRe: Suggestions please Pin
sindhutiwari31-Dec-07 20:27
sindhutiwari31-Dec-07 20:27 
GeneralRe: Suggestions please Pin
vimal_yet31-Dec-07 21:34
vimal_yet31-Dec-07 21:34 
Questionhow can i set password to my database Pin
vahid akbari31-Dec-07 5:31
vahid akbari31-Dec-07 5:31 
GeneralRe: how can i set password to my database Pin
DotNetXenon31-Dec-07 7:27
DotNetXenon31-Dec-07 7:27 
GeneralRe: how can i set password to my database Pin
vahid akbari1-Jan-08 17:43
vahid akbari1-Jan-08 17:43 

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.