Tag Info

New answers tagged


DECLARE @toCheck INT; DECLARE @countoftables INT; DECLARE @Qry NVARCHAR(100); DECLARE @name VARCHAR(100); BEGIN IF object_id('TEMPDB.DBO.#temp') IS NOT NULL drop table #temp; SELECT ROW_NUMBER() OVER(ORDER BY name) AS ROW,CountStatement = 'SELECT @toCheck = COUNT(*) FROM ' + name,name INTO #temp FROM SYS.TABLES WITH (NOLOCK) --SELECT * FROM ...


This is revolves around COLLATION rules (which are part of your locale). Per documentation: The C and POSIX collations both specify "traditional C" behavior, in which only the ASCII letters "A" through "Z" are treated as letters, and sorting is done strictly by character code byte values. Bold emphasis mine. These internal operators: ~<~, ...

Top 50 recent answers are included