I tried to reduce the total number to 111111.11 I'm still getting the same error.

this is how I created my table:

CREATE TABLE [dbo].[Product](

[ProductID] [int] IDENTITY(1,1) NOT NULL,

[Code] [nvarchar](max) NOT NULL,

[Qty] [int] NULL

)

I don't understand what do you mean when you say "Remove the TEXTIMAGE_ON...

It won't get to billion.

I tried [Code] [nvarchar](10) NOT NULL and I get this error:

Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), non-FILESTREAM varbinary(max), xml...

Database already exist, with those users, this logic has to be implemented on already existing database and tables .

This is what I have but it errors

DECLARE @Product_Id VARCHAR(50), @Fund_Id VARCHAR(50),

@NewFund_Id VARCHAR(50),@NewProduct_Id VARCHAR(50)

SET @Product_Id = 'PIC2'

SET @Fund_Id = ''

SET @NewProduct_Id = 'PCCV'

SET @NewFund_Id = ''

IF @NewFund_Id = '' THEN...

so far I wrote it in PL\SQL:

UPDATE CUSTOMER

SET recently_purchased = 'Y'

WHERE...

@a.guillaume

I'm trying to shy away from creating a View or Table for that matter specifying the columns, because if there are any changes to a Table I will...

@ChrisM@Work

The end to end process is pretty much what I have said, I have products I need to clone. I have 10 tables, in any table I might...

On this case, RETURNS_ID is a PK with IDENTITY(1,1). I could do this:

SELECT * INTO #TempTable

FROM Hosea_tblDef_RETURNS

WHERE Product_Id = 'AGP1'

AND (Fund_Id = 'E016' or Fund_Id is null)

ALTER TABLE #TempTable

DROP...

Data change.

I have TableA, it has IDENTITY(1,1) on the PK. I need to clone some of the rows in this table, with only two columns changing. what I decided to...

here's the idea behind Dynamic SQL:

The user will be passing table name to make changes to it, as they past table name, I'm creating another table in the same structure...

I have this code:

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Hosea_tempTable]') AND type in (N'U'))

DROP TABLE [dbo].[Hosea_tempTable]

GO

DECLARE @SQLStatement NVARCHAR(MAX),@TableName NVARCHAR(MAX), @Product_Id VARCHAR(50), @Fund_Id VARCHAR(50),

@NewFund_Id VARCHAR(50),@NewProduct_Id VARCHAR(50), @InsertSQL...

Without listing the columns??

I had this code

I see my error was select, I had to insert.

I'm still learning dynamic sql, thanks for help.