database queries. pls keep your scripts ready.

Printable View

Jan 22nd, 2004, 11:55 PM
abhijit

database queries. pls keep your scripts ready.

Hi Folks,

Please follow a simple rule when posting database queries. Post the table creation script and a few insert statements to create a sample records. This will help others to get to the root of the problem quicker.

Cheers,
Abhijit
Jan 23rd, 2004, 04:18 PM
The Hobo

:confused:
Jan 27th, 2004, 03:17 AM
abhijit

Hi Hobo,
Didn't you understand my simple request?

-Abhijit
Jan 27th, 2004, 04:31 AM
TomGibbons

I understood. But what's it doing here and why does it need a poll? :confused:
Jan 27th, 2004, 06:41 AM
abhijit

Quote:

Originally posted by TomGibbons
I understood. But what's it doing here and why does it need a poll? :confused:

The poll is just for me. :)
Jan 27th, 2004, 02:22 PM
The Hobo

Shouldn't this have gone in a forum where the questions are being asked? 98S% of this forums users probably don't even view this forum.
Jan 29th, 2004, 06:38 AM
plenderj

No but the moderators do, and we have the power to create sticky threads in forums ;)
Jan 29th, 2004, 08:32 PM
Danial

Re: database queries. pls keep your scripts ready.

Quote:

Originally posted by abhijit
Hi Folks,

Please follow a simple rule when posting database queries. Post the table creation script and a few insert statements to create a sample records. This will help others to get to the root of the problem quicker.

Cheers,
Abhijit

Yes it would be useful. A lot of user dont want to upload entire database. And it is hard to answer question without having the database schema. So if the script is supplied then it would be much easier to answer questions and test them properly.

Jamie, do you think it would be a good idea to put a note(sticky) on Database, ASP and other database related forum?

Thanks

Danial
Jan 30th, 2004, 03:37 AM
plenderj

Possibly, except that not everyone uses scripts to generate DB tables.
Personally, if I'm using MySQL, I use the mysql command line locally, and create the tables by hand.
Then I use phpMyAdmin to generate the table creation scripts.

But do such scripts exist for Access and MS-SQL? :confused:
Jan 30th, 2004, 07:01 PM
Danial

Quote:

Originally posted by plenderj
Possibly, except that not everyone uses scripts to generate DB tables.
Personally, if I'm using MySQL, I use the mysql command line locally, and create the tables by hand.
Then I use phpMyAdmin to generate the table creation scripts.

But do such scripts exist for Access and MS-SQL? :confused:

True, i doubt any one would bother to post the script even if they do, but it would been nice if they did :)