SQL_scripts

1
declare
2
	@table sysname = 'dbo.[any table]'
3
	,@column sysname = '[any field]'
4
	,@symbols sysname = 'char(10), char(13), char(9)'
5
	
6
declare	@query varchar(max) = '
7
	;with ten as (select * from (values (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) as t(n))
8
	,ord as (select row_number() over(order by (select null)) as N from ten as t1, ten as t2, ten as t3) --1000
9
	select 
10
		t.' + @column + '
11
		,string_agg(concat(unicode(o.[char]), ''['', o.N, '']''), '', '') within group (order by o.N) as [unicode (position)]
12
	from
13
		' + @table + ' as t with(nolock)
14
		cross apply (
15
			select top(len(t.' + @column + '))
16
				substring(t.' + @column + ', o.n, 1) as [char]
17
				,o.N
18
			from ord as o
19
			order by o.N
20
		) as o
21
	where o.[char] in (' + @symbols + ')
22
	group by t.' + @column + '
23
	order by t.' + @column + '
24
	option (maxdop 8)
25
'
26
exec (@query)
27

28