I think it is a typo, they probably meant to type '-- = inv.tblSoftware'

Which would mean that inv.tblSoftware is just a comment for clarity, describing something about the...

I think it is a typo, they probably meant to type '-- = inv.tblSoftware'

Which would mean that inv.tblSoftware is just a comment for clarity, describing something about the insert operation.

Setup some test data

CREATE TABLE TestCardData (
    s_Result NVARCHAR(255),
    s_credit_card_type NVARCHAR(50),
    s_credit_tran_type NVARCHAR(50),
    c_amount DECIMAL(18,...

.

• This reply was modified 3 months, 3 weeks ago by  Jonathan AC Roberts. Reason: duplicate deleted

You could use NULLIF or SET ARITHABORT OFF; SET ANSI_WARNINGS OFF;

SET ARITHABORT OFF;
SET ANSI_WARNINGS OFF;

DECLARE @x as int = 1, 
      ...

I used to be a front-end Developer... that's why I don't rebuild indexes all the time   ... The page splits that came after the rebuilds would slow down the...

I've written the script in the link above query and am using it. I've found that for a few of the of the rows it occasionally reports negative statistics. i.e....

It's difficult to say without seeing the actual query.

You could insert the data into a temporary table, create helpful indexes on the temporary table, then query the temporary table. So...

To date, I'm the least impressed with BING AutoPilot and Claude 3.5 Sonnet.  I'm especially disappointed in Claude 3.5 Sonnet because it doesn't seem to provide references like the...

SQL Server uses memory to cache data, if you don't set a maximum it is likely to use all the memory on the machine, including memory required by the operating...

We are adding Java BigInteger support and hence we need underlying database to support this. Oracle supports this and has no issue. I assuming SQL Server's BIGINT is equivalent...

It is preferable to use SCOPE_IDENTITY() instead of @@IDENTITY

SCOPE_IDENTITY() returns the last identity value generated within the same scope (i.e. within the stored procedure)

CREATE procedure GetCounter @tableName...

deleted duplicate

• This reply was modified 5 months, 2 weeks ago by  Jonathan AC Roberts.

Using UPDLOCK and HOLDLOCK

This approach allows you to acquire the necessary locks to ensure serialization without using the SERIALIZABLE isolation level.

CREATE PROCEDURE dbo.sp_GenerateNextNumber (
@SequenceKey nvarchar(10),
@ReferenceNumber nvarchar(25) =...

The first 3 rows out of...