How to Programmatically Determine Which Edition of SQL Server is Installed
Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.
2017-03-02
3,772 reads
SQL Server versions
RE: Using a variable as a field value in a bulk insert
I would load the data into a staging table with bulk insert, then insert the date into the batch table, and finally insert the data from the staging table into your Files table with the identity value from the batch table. BTW, I would use SCOPE_IDENTITY(). From BOL: SCOPE_IDENTITY and @@IDENTITY will return last identity […]
2004-12-29
1 reads
stored proc timeout question
I am using a stored proc to query a database and return values. The stored proc has to utilize several temp tables, including a table cursor. (Too long a story to explain.)The problem I am encountering is that I get a "timeout expired" message.This does not occur all the time...only when the returned record sets […]
2004-05-18
1 reads
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Do entry-level cloud positions exist?
Hello friends. I’m new here, so if this is the wrong place for my...
Configuring Fargate task duration
Hi everyone! I've been working with a Fargate app recently and I've managed to...
Coding Magic Values
Comments posted to this topic are about the item Coding Magic Values
Ask SSC