CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Wrong query?

  1. June 13th, 2001, 03:16 PM #1
    Andrew R.'s Avatar
    Andrew R.
    Andrew R. is offline Member
    Join Date
    Aug 2000
    Location
    Ottawa, Canada
    Posts
    469

    Wrong query?

    This query works fine with MS Access db, but gives me error with SQL Server 7.
    '
    "DELETE * FROM tbMyTable"
    '
    I try to delete all records from the table.
    Why it doesn't work with SQL Server?


    Reply With Quote Reply With Quote
  2. June 13th, 2001, 03:22 PM #2
    nilch
    nilch is offline Member
    Join Date
    Aug 1999
    Location
    India, West Bengal
    Posts
    36

    Re: Wrong query?

    In Sql Server just give
    "Delete from <tablename>"
    instead of "delete * ...."

    I guess that is the difference.



    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

Featured