Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 8 of 8
Search took 0.01 seconds.
Search: Posts Made By: Graham
Forum: SQL Language June 18th, 2003, 10:02 AM
Replies: 6
Views: 37,820
Posted By Graham
Sorry Jeff That is what it does say, all...

Sorry Jeff

That is what it does say, all down to satellite delay between brain and keyboard!

Regards
Graham
Forum: SQL Language June 18th, 2003, 08:05 AM
Replies: 6
Views: 37,820
Posted By Graham
Thanks Nickie That gives me an error about...

Thanks Nickie

That gives me an error about needing to use correllation to distinguish the columns.

The actual line is: -
update allocations
set allocations.driver_name=drivers.driver_name...
Forum: SQL Language June 18th, 2003, 07:35 AM
Replies: 5
Views: 3,577
Posted By Graham
Hi I'd be interested to see what the others...

Hi

I'd be interested to see what the others make to this one.

MySQL gives you a limits clause so select * from table limit 20,30 (or thereabouts)
Far as I am aware you can't do this with SQL...
Forum: SQL Language June 18th, 2003, 07:30 AM
Replies: 6
Views: 37,820
Posted By Graham
Update inner join question

Hi all

I've recently been moving apps to SQL2k from Access 2k

In access I could do

update table1 inner join table2 on table1.key=table2.key set table1.column1=table2.column1

Which...
Forum: SQL Server ASP June 13th, 2003, 03:54 AM
Replies: 1
Views: 8,874
Posted By Graham
Hi Have you looked at the ASPXMPS8 and...

Hi

Have you looked at the ASPXMPS8 and ASPXMPS85 samples on the Crystal website.

I picked up quite a bit from them

I use the session variables in the activex viewer like so.

Set...
Forum: SQL Server 2000 June 13th, 2003, 03:39 AM
Replies: 2
Views: 1,031
Posted By Graham
Hi Don't know how to do that, probably a...

Hi

Don't know how to do that, probably a little too advanced for me!
Could you point me to any resources that explain or let me have a little more info?

Regards
Graham
Forum: SQL Server 2000 June 12th, 2003, 12:19 PM
Replies: 3
Views: 1,403
Posted By Graham
Hi I've recently been moving Access MDBs...

Hi

I've recently been moving Access MDBs into SQL 2k and hit the same error.

Turned out that SQL DTS was creating Access Date/Times as SmallDateTimes. In the end the only way I could fix this...
Forum: SQL Server 2000 June 12th, 2003, 12:13 PM
Replies: 2
Views: 1,031
Posted By Graham
Backup (newbie question)

Hi

I have an SQL database that I need to backup every evening but to different filenames ie Monday.BAK, Tuesday.BAK etc

Does this mean I need to schedule seven backups each to run weekly and...
Showing results 1 to 8 of 8

 


All times are GMT -4. The time now is 10:36 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.