Competition: What’s your favorite Redgate tool? Enter now.

row_number() returns bigint, but SQL Prompt displays int

bstrautinbstrautin Posts: 8 Bronze 2
edited April 8, 2015 8:33AM in SQL Prompt
The summary popup for the row_number() function reports that it returns int, but it actually returns bigint.
select row_number() over (order by o.object_id)
from sys.objects o

Comments

Sign In or Register to comment.