RAISERROR and BIGINT
Thanks to Ted Krueger (onpnt if you’re on twitter or use lessthandot.com), I now know how to display a BIGINT in RAISERROR. You just used %I64d. It’s documented in BOL as a sidebar note, but you still have to wade through the RAISERROR documentation.
So, our code would look like this:
DECLARE @i AS BIGINT; SET @i = 1; RAISERROR('%I64d is a very big number', 0, 43, @i);
Here’s the link to the BOL entry: RAISERROR.
Thanks, twitter, for making this all possible!
This is Jeremiah
I live in Portland, OR. I have two dogs.
I recently received a Master's of Science in Computer Science from Portland State University.
I'm was Microsoft MVP from 2009 - 2018 with a pile of certifications. Somewhere along the way, I wrote a database client for Riak and then handed it off to the community.