When i analyzes some databases, i can see differences in stored procedures. SSMS 2012 suggests me to change CR/LF new line type. What would it can be?
To analyze differences, i wrote very simple code to see all SQL module definition characters together with their ASCII code values.
To analyze differences, i wrote very simple code to see all SQL module definition characters together with their ASCII code values.
DECLARE @Object_Name VARCHAR(256)= 'Your object'
DECLARE @Definition NVARCHAR(MAX)
SELECT @Definition = m.definition
FROM sys.all_sql_modules M
WHERE OBJECT_NAME (M.object_id) = @Object_Name;
;
WITH H AS ( SELECT SUBSTRING(@Definition, 1, 1) AS Char ,
ASCII(SUBSTRING(@Definition, 1, 1)) AS Code ,
1 AS Position
UNION ALL
SELECT SUBSTRING(@Definition, H2.Position + 1, 1) AS Char ,
ASCII(SUBSTRING(@Definition, H2.Position + 1, 1)) AS Code ,
H2.Position + 1 AS Position
FROM H H2
WHERE H2.Position < LEN(@Definition)
)
SELECT *
FROM H
OPTION ( MAXRECURSION 0 )
The result should look like this:
No comments:
Post a Comment