Forum: MS SQL  Nov 30th, 2005 |
| Replies: 8 Views: 1,953 Re: help with joins
"where table1.userid = X " does definatelly NOT return any users which have NOT userid = X |
| Forum: MS SQL Nov 30th, 2005 |
| Replies: 2 Views: 37,126 Re: datetime format in ms sql
dont think you are right- tried it again, and now it works: you can setup the language of the user which connects to the DB, so that datetime is excepted in the language you have set up.
tried your... |
| Forum: MS SQL Nov 29th, 2005 |
| Replies: 8 Views: 1,953 Re: help with joins
i think it should work like that:
select table1.requiredInfo, table2.optionalInfoValue from table1
left outer join table2 on table1.userid = table2.userid
where table1.userid = X and... |
| Forum: MS SQL Nov 29th, 2005 |
| Replies: 2 Views: 37,126 datetime format in ms sql
anyone has an idea where i can setup the language (the dateformat) for my ms sql database??
Allways thought i can configure the DB user so that the DB accepts german datetime values- any ideas?? |
| Forum: MS SQL Nov 29th, 2005 |
| Replies: 8 Views: 1,953 Re: help with joins
can be easy done with an outher join:
SELECT table1.userid, table1.requiredInfo, table2.optionalInfo
FROM table1 LEFT OUTER JOIN table2 ON table1.userid = table2.userid |
