Is there a way to not use square brackets in SQL Server?

by

I know alot of people don’t like this, but I always use prefixes or suffixes for everything in sql.
tbl for tables, stp for procedures, v for views etc’.
In column names the table name itself is the prefix: person_id, person_fkvalue etc’.

This way I never have to deal with reserved words, and can immediately know to what table the column belongs to.
This also eliminates the need of using aliases for table names in joins.
I’m a big fan of using meaningful names, so even derived tables usually gets a name and not a letter.

More Related Contents:

  1. How to multiply column in Sql
  2. how to select next n letters after one specific letter using function in sql server by giving function name,specific letter, no of letters next
  3. What is the best way to create and populate a numbers table?
  4. Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
  5. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  6. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  7. How do you clear the SQL Server transaction log?
  8. Order Of Execution of the SQL query
  9. What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
  10. How Can I Log and Find the Most Expensive Queries?
  11. How to drop a table if it exists?
  12. Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0
  13. SQL Server truncation and 8192 limitation
  14. Is there a Boolean data type in Microsoft SQL Server like there is in MySQL? [duplicate]
  15. How to list all dates between two dates [duplicate]
  16. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  17. How to write UTF-8 characters using bulk insert in SQL Server?
  18. Number of times a particular character appears in a string
  19. SQL Server variable columns name?
  20. How to: Create trigger for auto update modified date with SQL Server 2008
  21. SQL Server BCP export corrupted file?
  22. How to query for Xml values and attributes from table in SQL Server?
  23. Avg of float inconsistency
  24. Setting up maven dependency for SQL Server
  25. Getting a warning when using a pyodbc Connection object with pandas
  26. How can I get the list of tables in the stored procedure?
  27. How to find the boundaries of groups of contiguous sequential numbers?
  28. SQL Server 2008 can’t login with newly created user
  29. Update SQL with consecutive numbering
  30. Nested transactions in Sql Server

Leave a Comment