Discussion Board

SQL Server Identifiers may have between 1 and 128 characters. The first character of the identifier must be a letter, underscore ( _ ), at sign (@), or number sign (#). The first letter must be defined in the Unicode 2.0 standard. Among other letters, Latin letters a–z and A–Z can be used as a first character. Some characters (@ and #) have special meanings in T-SQL. They act as signals to SQL Server to treat their carriers differently. Subsequent characters must be letters from the Unicode 2.0 standard, or decimal digits, or one of the special characters @, #, _, or $. SQL Server reserved words should not be used as object identifiers. Identifiers cannot contain spaces or other special characters except for @, #, _, or $. Prajakta Pandit 03-3-2017 05:49 AM

Details found here... https://msdn.microsoft.com/en-us/library/ms175874.aspx The database object name is referred to as its identifier. Everything in Microsoft SQL Server can have an identifier. Servers, databases, and database objects, such as tables, views, columns, indexes, triggers, procedures, constraints, and rules, can have identifiers. Identifiers are required for most objects, but are optional for some objects such as constraints. Both regular and delimited identifiers must contain from 1 through 128 characters. For local temporary tables, the identifier can have a maximum of 116 characters. Jose R 02-1-2017 10:51 AM

query how u solved this problem ?? pz explain nd give me details in my mail id chudinayak@gmail.com chudi 05-13-2015 02:48 PM

query plz explain about the identifier smita ram 06-29-2014 06:56 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*