Curly braces in T-SQL

by

These are ODBC escape sequences. See Date, Time, and Timestamp Escape Sequences for more details.

There is also similar syntax for uniqueidentifiers

SELECT {guid '00000000-0000-0000-0000-000000000000'},

as well as procedure calls and some other constructs detailed off that link.

With regard to the rest of your question I’m not aware of any way of having an integer literal treated as a bigint or of any particular resource that lists all the ways of influencing how literals are assigned datatypes by SQL Server. Some ways are below.

;WITH cte(thing) AS
(
SELECT CAST(1 AS SQL_VARIANT) UNION ALL
SELECT $1 UNION ALL
SELECT 1e0 UNION ALL
SELECT 1.0000 UNION ALL
SELECT 2147483648 UNION ALL 
SELECT {ts '2011-09-15 01:23:56.123'}  UNION ALL
SELECT {d '2011-09-15'} UNION ALL
SELECT { t '13:33:41' }  UNION ALL
SELECT {guid '00000000-0000-0000-0000-000000000000'} UNION ALL
SELECT 'Foo' UNION ALL
SELECT N'Foo'
)
SELECT thing, 
       sql_variant_property(thing,'basetype') AS basetype,
       sql_variant_property(thing,'precision') AS precision, 
       sql_variant_property(thing,'scale') AS scale, 
       sql_variant_property(thing,'maxlength') AS maxlength
FROM cte

Returns

thing                          basetype            precision   scale  maxlength
------------------------------ ------------------- ----------- ------ ---------
1                              int                 10          0      4
1.00                           money               19          4      8
1                              float               53          0      8
1.0000                         numeric             5           4      5
2147483648                     numeric             10          0      5
2011-09-15 01:23:56.123        datetime            23          3      8
2011-09-15 00:00:00.000        datetime            23          3      8
2011-09-15 13:33:41.000        datetime            23          3      8
00000000-0000-0000-0000-000000 uniqueidentifier    0           0      16
Foo                            varchar             0           0      3
Foo                            nvarchar            0           0      6

More Related Contents:

  1. How do I perform a GROUP BY on an aliased column in SQL Server?
  2. SQL dot notation
  3. Syntax of for-loop in SQL Server
  4. Convert text to system date format [duplicate]
  5. SQL where clause odd behavior [closed]
  6. How do I escape a single quote in SQL Server?
  7. Simple way to transpose columns and rows in SQL?
  8. Only inserting a row if it’s not already there
  9. Unpivot with column name
  10. Selecting data from two different servers in SQL Server
  11. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  12. SQL JOIN vs IN performance?
  13. Most efficient way in SQL Server to get date from date+time?
  14. Convert varchar into datetime in SQL Server
  15. TSQL Pivot without aggregate function
  16. How to generate a range of dates in SQL Server
  17. SQL RANK() versus ROW_NUMBER()
  18. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  19. Check if a row exists, otherwise insert
  20. SQL : BETWEEN vs =
  21. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  22. How do I make a composite key with SQL Server Management Studio?
  23. TransactSQL to run another TransactSQL script
  24. Best equivalent for IsInteger in SQL Server
  25. Store multiple bit values in a single table column
  26. SQL Server equivalent to MySQL enum data type?
  27. SQL – Call Stored Procedure for each record
  28. COALESCE Function in TSQL
  29. Convert bigint to datetime
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment