View Poll Results: Have you asked help for solving SQL queries?

Voters
5. You may not vote on this poll

  • Yes

    4 80.00%

  • No

    1 20.00%
Results 1 to 10 of 10

Thread: database queries. pls keep your scripts ready.

  1. Jan 22nd, 2004, 11:55 PM #1
    abhijit
    abhijit is offline

    Thread Starter
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Red face 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
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog
    Reply With Quote Reply With Quote
  2. Jan 23rd, 2004, 04:18 PM #2
    The Hobo
    The Hobo is offline
    Stuck in the 80s The Hobo's Avatar
    Join Date
    Jul 2001
    Location
    Michigan
    Posts
    7,256
    My evil laugh has a squeak in it.

    kristopherwilson.com
    Reply With Quote Reply With Quote
  3. Jan 27th, 2004, 03:17 AM #3
    abhijit
    abhijit is offline

    Thread Starter
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228
    Hi Hobo,
    Didn't you understand my simple request?

    -Abhijit
    Reply With Quote Reply With Quote
  4. Jan 27th, 2004, 04:31 AM #4
    TomGibbons
    TomGibbons is offline
    Frenzied Member TomGibbons's Avatar
    Join Date
    Feb 2002
    Location
    San Diego, CA Previous Location: UK
    Posts
    1,345
    I understood. But what's it doing here and why does it need a poll?
    Last edited by TomGibbons; Feb 9th, 2004 at 04:41 AM.
    Reply With Quote Reply With Quote
  6. Jan 27th, 2004, 06:41 AM #5
    abhijit
    abhijit is offline

    Thread Starter
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228
    Originally posted by TomGibbons
    I understood. But what's it doing here and why does it need a poll?
    The poll is just for me.
    Reply With Quote Reply With Quote
  7. Jan 27th, 2004, 02:22 PM #6
    The Hobo
    The Hobo is offline
    Stuck in the 80s The Hobo's Avatar
    Join Date
    Jul 2001
    Location
    Michigan
    Posts
    7,256
    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.
    My evil laugh has a squeak in it.

    kristopherwilson.com
    Reply With Quote Reply With Quote
  8. Jan 29th, 2004, 06:38 AM #7
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    No but the moderators do, and we have the power to create sticky threads in forums
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
  9. Jan 29th, 2004, 08:32 PM #8
    Danial
    Danial is offline
    Big D Danial's Avatar
    Join Date
    Jul 2000
    Location
    ASP.Net Forum
    Posts
    2,877

    Re: database queries. pls keep your scripts ready.

    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
    [VBF RSS Feed]

    There is a great war coming. Are you sure you are on the right side? Atleast I have chosen a side.

    If I have been helpful, Please Rate my Post. Thanks.

    This post was powered by :
    Reply With Quote Reply With Quote
  11. Jan 30th, 2004, 03:37 AM #9
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    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?
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
  12. Jan 30th, 2004, 07:01 PM #10
    Danial
    Danial is offline
    Big D Danial's Avatar
    Join Date
    Jul 2000
    Location
    ASP.Net Forum
    Posts
    2,877
    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?
    True, i doubt any one would bother to post the script even if they do, but it would been nice if they did
    [VBF RSS Feed]

    There is a great war coming. Are you sure you are on the right side? Atleast I have chosen a side.

    If I have been helpful, Please Rate my Post. Thanks.

    This post was powered by :
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width