There are Different symbols in SQL Server useful while writing the Dynamic SQL Query.
The total list in SQL 2012 are 255.
You get to know the all Symbols while running below Query.
;WITH X AS(
SELECT 0 CharNumber, CAST ('' AS VARCHAR) Symbol
UNION ALL
SELECT X.CharNumber+1, CAST(CHAR(X.CharNumber+1) AS VARCHAR) FROM X WHERE X.CharNumber<=255
)SELECT * FROM X OPTION (MAXRECURSION 1000)
Few Symbols showing below.
The total list in SQL 2012 are 255.
You get to know the all Symbols while running below Query.
;WITH X AS(
SELECT 0 CharNumber, CAST ('' AS VARCHAR) Symbol
UNION ALL
SELECT X.CharNumber+1, CAST(CHAR(X.CharNumber+1) AS VARCHAR) FROM X WHERE X.CharNumber<=255
)SELECT * FROM X OPTION (MAXRECURSION 1000)
Few Symbols showing below.
No comments:
Post a Comment