Hi Sahil, you are correct... .. The is possible to usage the above characters in Table name and Column Name making use of SSMS/TSQL square brackets..

You are watching: Which of the following symbols is used to qualify column names?

The common rules:

The rules because that the layout of consistent identifiers count on the database compatibility level. This level deserve to be collection by usingALTER DATABASE . Once the compatibility level is100 , the adhering to rules apply:

The an initial character should be one of the following:

A letter as identified by the Unicode traditional 3.2. The Unicode meaning of letters consists of Latin personalities from a with z, indigenous A with Z, and additionally letter characters from other languages.

The underscore (_), at authorize (
), or number authorize (#).

Certain signs at the beginning of an identifier have actually special definition in SQL Server. A consistent identifier that starts v the at sign constantly denotes a local variable or parameter and also cannot be supplied as the surname of any type of other type of object. An identifier that starts with a number authorize denotes a short-lived table or procedure. One identifier that starts with double number signs (##) denotes a global temporary object. Return the number sign or double number sign characters can be supplied to begin the surname of other varieties of objects, we execute not introduce this practice.

Some Transact-SQL features have surname that start with double at indicators (
). To stop confusion through these functions, you need to not usage names that start with
.

Subsequent characters can incorporate the following:

Letters as defined in the Unicode conventional 3.2.

Decimal numbers from either basic Latin or other nationwide scripts.

The in ~ sign, dollar authorize ($), number sign, or underscore.

The identifier must not be a Transact-SQL scheduled word. SQL Server make reservation both the uppercase and lowercase execution of booked words.

Embedded spaces or special characters are not allowed.

Supplementary characters are not allowed.

When identifiers are used in Transact-SQL statements, the identifiers that perform not comply v these rules must be delimited by twin quotation marks or brackets.

Hope this assist you Sahil

thanks....

- M S (We room what we repeatedly do, Excellence, then, is no an act, but a habit.)
Tuesday, November 23, 2010 10:56 AM
*

*

0
sign in to vote

We had actually a comparable thread a when ago concerning characters that allowed in table name & shaft name. Check sysname subject in BOL.

You may likewise want to review this blog

Do not use spaces or various other invalid characters in your pillar namesPremature optimization is the root of all angry in programming. (c) through Donald KnuthNaomi Nosonovsky, Sr. Programmer-Analyst mine blog
Tuesday, November 30, 2010 8:44 PM
Answerer

every replies


*

*

2
authorize in to vote

Hi Sahil, you are correct... .. That is possible to usage the over characters in Table name and Column Name using SSMS/TSQL square brackets..

The typical rules:
Rules for regular Identifiers

The rules for the style of consistent identifiers rely on the database compatibility level. This level have the right to be collection by usingALTER DATABASE . As soon as the compatibility level is100 , the following rules apply:

The an initial character need to be among the following:

A letter as identified by the Unicode traditional 3.2. The Unicode an interpretation of letters contains Latin characters from a v z, from A with Z, and additionally letter personalities from various other languages.

The underscore (_), at authorize (
), or number sign (#).

Certain icons at the start of one identifier have special definition in SQL Server. A regular identifier the starts v the at sign always denotes a regional variable or parameter and also cannot be used as the surname of any type of other form of object. An identifier that starts with a number authorize denotes a temporary table or procedure. An identifier the starts with dual number indications (##) denotes a an international temporary object. Back the number sign or dual number sign personalities can be provided to begin the name of other types of objects, we execute not introduce this practice.

Some Transact-SQL functions have name that start with double at indications (
). To protect against confusion through these functions, you should not usage names that begin with
.

Subsequent characters can incorporate the following:

Letters as identified in the Unicode traditional 3.2.

Decimal numbers from either simple Latin or other national scripts.

The in ~ sign, dollar authorize ($), number sign, or underscore.

The identifier must not it is in a Transact-SQL scheduled word. SQL Server make reservation both the uppercase and lowercase version of scheduled words.

Embedded spaces or special personalities are not allowed.

Supplementary characters are no allowed.

When identifiers are supplied in Transact-SQL statements, the identifiers that carry out not comply through these rules must be delimited by double quotation marks or brackets.

Hope this help you Sahil

thanks....

See more: What Is 40 Percent Of 26 Is What Percent Of 40 Percent Of What Number? = 65

- M S (We are what we repetitively do, Excellence, then, is no an act, yet a habit.)
Tuesday, November 23, 2010 10:56 AM
*

0
authorize in to poll

We had actually a comparable thread a when ago concerning characters that enabled in table name & tower name. Inspect sysname subject in BOL.

You may additionally want to evaluation this blog

Do not use spaces or various other invalid characters in your shaft namesPremature optimization is the root of all angry in programming. (c) by Donald KnuthNaomi Nosonovsky, Sr. Programmer-Analyst mine blog
Tuesday, November 30, 2010 8:44 PM
Answerer
Terms the Use|Trademarks|Privacy Statement|Site Feedback