What is the best way to get identity of inserted row?
I know about @@IDENTITY and IDENT_CURRENT and SCOPE_IDENTITY in Sql Server but don’t understand the pros and cons attached to each.
Can someone please explain the differences and when I should be using each?
What is the difference between Floating Point, Money and Real types in MS SQL Server?
I have noticed when working in SQL Server that the values I store in column type REAL get changed. For example if I store a value of 32.54, it returns a value of 32.53999878999. Does anyone know why this happens?
Basic SQL Server question
Hello CCD,
I have a basic question on SQL Server: Â What is normalization? Â and is it important? Â Thanks,
Bob
What is the best method to extract a file extension in PHP?
Hello
I am looking for a good efficient method to extract the file extension in PHP. I have read of various methods using substrings, or splits etc but I want to find the best way to accomplish this.
Thanks
Joe from Rockville
SQL Server question from a company in Maryland
Hi. Â As I entered in the topic, I work for a company in Maryland. Â I have considerable experience working with Microsoft Access, but not much with SQL Server. Â Â I have a question on SQL Server: Â What is a stored procedure? Â Is this like a module in Microsoft Access?
JP
SQL Server help in Gaithersburg or Germantown
Hello CCD, LLC,
We are running an HR system in SQL Server 2005 (HROffice, it’s by Ascentis). It runs pretty well, but we don’t know if we should upgrade to SQL Server 2012 or not. What do you think? Do you get questions like this in your computer consulting practice?
Bob in Northern Montgomery County, Maryland
We’re in Maryland as well and have a SQL Server question
Hello CCD,
I’m glad to see that there are local IT companies in Maryland with SQL Server expertise. Â My colleagues and I were wondering how to get rid of duplicate rows in a SQL Server table. Â Do you know about this?
Tom in Maryland