By tag: PrimaryKey
0
kicks
Returning The Value Of A Generated Key On Insert In MSSQL
I wanted to use GUIDs for a specific table's primary key, but I had no intention of running two queries just so I could get the newly created row's GUID. Here's a great way to get data created within a stored procedure back to the code that called it.
0
kicks
What should I choose for my primary key?
Naturals? Idents? GUIDs? Oh, jeez. Getting an official opinion on which to use is about as hard as getting a lawyer to tell you exactly when its okay to shoot somebody. NOBODY wants to give you a straight up answer. And you can understand why; there are many different things you have to consid...