What are the challenges you face when working across database platforms? Take the survey

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


Sign In or Register to comment.