Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    India
    Posts
    37

    Lightbulb Unanswered: Need some Tips & Tricks..

    Hi all...
    I am sai..I am a ORACLE DBA for the last 3 years ...now suppose to work on SQL Server...so all the people out there...please throw some light on Critical issues in sql server, Features, Tips, Tricks and also some sitre links through which i can get some white papers/ Pdf's kinda stuff....


    Thanks and Regards
    SAI SREENIVAS

  2. #2
    Join Date
    Aug 2002
    Location
    UK
    Posts
    87
    Look at the 'Information_Schema.<Object>' tables. These are very useful when writing dynamic TRANSACT scripts

    i.e

    Select Table_name from information_schema.tables

    or

    Select column_name from information_schema.columns

Posting Permissions

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