SQL Server Other Prefix Identifiers

Asked May 25 '18 at 16:07

Active May 25 '18 at 16:09

Viewed 44 times

My question is somewhat related to :

What is the meaning of the prefix N in T-SQL statements?

I understand the N prefix, but I am curious - are there more I can use? I can only find documentation for this one and for binary constants. I've tried googling in various ways but I have come up empty handed. If there are more I would like to know what they are.

Thanks in advance.

edited May 25 '18 at 16:09

Jacob H

2,455
1
12
29

asked May 25 '18 at 16:07

Doug Coats

6,255
9
27
49

1

No other prefixes (except currency symbols). Some ways that datatype is inferred from literals are in this answer https://stackoverflow.com/questions/7428538/curly-braces-in-t-sql/7428636#7428636 – Martin Smith May 25 '18 at 16:13
1

`money` via the literals £4.95 / $2.00 etc – Alex K. May 25 '18 at 16:14
Thank you very much this was helpful – Doug Coats May 25 '18 at 16:43

SQL Server Other Prefix Identifiers

0 Answers0