Results 1 to 4 of 4

Thread: ms sql

  1. #1
    Join Date
    May 2010
    Posts
    2

    Unanswered: ms sql

    how to convert ms access code to ms sql code with examples? plz help me its urgent.

    thanks,
    Debasmita

  2. #2
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    Can;t give examples 'cause very SQL statement is different.

    Some Access SQL will run directly on MSSQL with no modification.

    Other Access SQL will require extensive modification.

    It all depends upon the actual SQL.


    Any Access SQL which uses Access functions will probably require modification.
    Ken

    Maverick Software Design

    (847) 864-3600 x2

  3. #3
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Quote Originally Posted by tripathydebasmita View Post
    how to convert ms access code to ms sql code with examples? plz help me its urgent.

    thanks,
    Debasmita
    Smells like homework/finals preparation.....Show us the access code and some sample data. It might not be too bad.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    A homework assignment on translating MS SQL to TSQL?
    I should hope not.

    Trip, if you supply us with one of your Access SQL statements we can help you out.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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