How to specify a BIGINT literal in T-SQL?

Question

Aside from wrapping my literal in a CONVERT function, is there a way to specify that I want e.g. 12345 represented as a BIGINT and not an INT? In C#, I could specify 12345L, but I'm unaware of equivalent functionality in T-SQL.

Answer 1

select cast(1 as bigint)

IOW you simply cast your value. What would be the purpose?