locked
Reference Database Tables Syntax RRS feed

  • Question

  • User748051115 posted

    Simple question: When referencing a database, say: [xxx].[xxx].[xxxx]...when is it appropriate to use the square brackets?

    Friday, June 3, 2011 11:57 AM

Answers

  • User-294030300 posted

    Hey,

    It's generally good anytime; ultimately, anytime your table/view/etc is the same as a reserved/special word, or the table has spaces in the name.

    HTH.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, June 3, 2011 11:59 AM

All replies

  • User-294030300 posted

    Hey,

    It's generally good anytime; ultimately, anytime your table/view/etc is the same as a reserved/special word, or the table has spaces in the name.

    HTH.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, June 3, 2011 11:59 AM
  • User748051115 posted

    Thank you bmains.

    Friday, June 3, 2011 12:13 PM