| |
| |
| |
|
Comments:
<0> - I want to believe.
<1> hey guys ...quick question ...i have 3 records in my database..but i want the most recent one to show up ....how would my SQL statement be...for example ...i shopped at walmart on three different days ..but i want to know when i went to walmart the last thats closest to today ...
<2> max
<1> select max (date) ?
<2> well, you could do a subquery
<2> or you could order by the date
<2> and perhaps use select top 1 blahblah
<1> cool :)
<1> has anyone connected four tables before to get information out using inner joins ?
<2> probably
<3> anyone here know how to sql injection?
<2> ahh, the wannabe hackers. so cute
<0> hehe
<4> what is SQL Reporting Service? i need some information. i am an ASP, MS Access and MS SQL Server developer.
<4> please........ and one here to help?
<5> it is what it sais
<5> reporting :)
<5> it creates reports
<5> google for more info
<4> my client wants to generate an webbased invoice system where items are transferred........ and receipts are generated and the data is stored in 4 tables
<4> he says to generate reports using sql reporting system..... i dont understand this part of his project
<4> i can show him data through asp and sql queries...... do i still need sql reporting system?
<2> can probably get an overview from Books Online
<2> or, as alone said, google :)
<4> aaaaaaaaaaaaaaaaaaaaa
<6> hi guys
<6> what is the limit on VARCHAR ?
<6> is it better to use files for large text?
<7> 8000 - sizeofothercolumns on mssql 2k
<6> what about mysql?
<7> no idea
<6> I guess the use of files is necessary for using large data
Return to
#sql
or
Go to some related
logs:
#allnitecafe
pcemde
#india
#allnitecafe
#india
dowilita
#india
#india
#allnitecafe
#chat-world
|
|