Results 1 to 4 of 4

Thread: Transact SQL

  1. #1
    Join Date
    Jul 2006

    Unanswered: Transact SQL

    Hi: Can any one please tell me the difference b/w TSQL and simple SQL. Also there is a a TSQL use in my VB6 Program, how to i find that SQL in SQL Server?
    cnADOSQL.Execute "DBCC CHECKIDENT ('tbl_distlist_balrange', RESEED, 0)"


  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    Quote Originally Posted by mustish1
    Hi: Can any one please tell me the difference b/w TSQL and simple SQL.
    T-SQL is a lot more complicated

    however, T-SQL can also do a lot more

    is that what you were looking for? | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2003
    Provided Answers: 1
    TSQL is simply Microsoft SQL Server's version of the ANSII SQL Standard. Mostly, it differs in having additional functionality that has not (yet) become part of the ANSII standard. I think that any ANSII compliant code will execute as TSQL, but TSQL code will not necessarily execute on other engines.

    The statement you are looking at is a DBCC command, which stands for "Database Consistency Check". It is functionality that is built in to SQL Server and the code cannot be viewed. You can look up what it does in Books Online.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  4. #4
    Join Date
    Jan 2007
    Sacramento, CA
    FYI, DBCC CHECKIDENT ('tbl_distlist_balrange', RESEED, 0) is reseeding the tbl_distlist_balrange table. This is normally run after you delete data from a table and want the counter on the table to restart from what ever settings you have on the IDENTITY field.

Posting Permissions

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