Hi.
I was using this:
[code] USE [VrExternal]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[vsInsertSeatOrderNew]
(
@SessionId nvarchar(256),
@LogKeyUsed nvarchar(150),
@SeatQuantity smallint,
@Seats nvarchar(50),
@SeatData nvarchar(max),
@SeatLib nvarchar(max),
@RealAllocated nvarchar(2),
@LibSeatsToRemove nvarchar(50)
)
AS
BEGIN
--- will return one partner on branch , cannot has another partner with same uname,pass.
/****** Script for SelectTopNRows command from SSMS ******/
INSERT INTO vsSeatOrderMid(SessionId,SeatQuantity,DateTimeOrdered,LogKeyUsed,Seats,SeatData,SeatDataLib,RealSeat,LibSeatsToRemove)
values (@SessionId,@SeatQuantity,getdate(),@LogKeyUsed,@Seats,@SeatData,@SeatLib,@RealAllocated,@LibSeatsToRemove)
END [/code]
when i inserted more than 4000chars the column or seatdata became empty.
I tried to use this:
[code] USE [VrExternal]
GO
/****** Object: StoredProcedure [dbo].[vsInsertSeatOrderNew] Script Date: 30/7/2015 6:34:21 μμ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[vsInsertSeatOrderNew]
(
@SessionId nvarchar(256),
@LogKeyUsed nvarchar(150),
@SeatQuantity smallint,
@Seats nvarchar(50),
@SeatData nvarchar(max),
@SeatLib nvarchar(max),
@RealAllocated nvarchar(2),
@LibSeatsToRemove nvarchar(50)
)
AS
BEGIN
declare @s1 nvarchar(max)
set @s1 = Replicate(cast(@seatdata as nvarchar(max) ),10000)
--- will return one partner on branch , cannot has another partner with same uname,pass.
INSERT INTO vsSeatOrderMid(SessionId,SeatQuantity,DateTimeOrdered,LogKeyUsed,Seats,SeatData,SeatDataLib,RealSeat,LibSeatsToRemove)
values (@SessionId,@SeatQuantity,getdate(),@LogKeyUsed,@Seats,@s1,@SeatLib,@RealAllocated,@LibSeatsToRemove)
END [/code]
No i get "Could not allocate space for object 'dbo.Large Object Storage
System object: 422597778210816' in database 'tempdb' because the
'PRIMARY' filegroup is full. Create disk space by deleting unneeded
files, dropping objects in the filegroup, adding additional files to the
filegroup, or setting autogrowth on for existing files in the
filegroup."
I went to db files and used autogrowth to unlimited size but i still get that error.
Basically i have a full theater view in a string that is 8-10000chars
and it must be inserted in an nvarchar column. How do i do that without
issues?
I could try to post the text object below but i am not sure that the site will let me.
A test notepad shows 110kb size. I don't think it is that big, so what
is going on with the " 422597778210816' in database " ? I am not
inserting something that big.
Thanks