57 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
2
answers
81
views
Searching a text column for keywords very slow
I have a SQL Server database that only has a single table with a few columns. There are a few thousand rows currently. The columns are as follows:
id (nvarchar(35))
path (nvarchar(255))
body (ntext)
...
0
votes
1
answer
126
views
Remove unnecessary control character when exporting record to Excel to SQL
I am currently doing system decom for a ASP.NET system and plan to have all the system data stored in Excel file. The challenge I face is that there is a column of ntext data type and the data is ...
0
votes
1
answer
173
views
Unable to Search for Specific Russian Text in SQL Server ntext Column Using LIKE Operator [duplicate]
I'm currently working on an ASP.NET Core application that uses Entity Framework Core to interact with a SQL Server database. I have a specific issue where I'm unable to search for Cyrillic text in a ...
1
vote
1
answer
879
views
Sql-server – Convert all ntext columns to nvarchar(max)
I'm trying to convert all ntext columns in my database to nvarchar(max).
This is the code:
DECLARE @command NVARCHAR(MAX);
DECLARE @numberOfRecordsToUpdate as int;
DECLARE @...
0
votes
1
answer
1k
views
Update ntext column
I'm having an article table which has a ntext column called SearchText which contains the whole article stripped for html.
When iterating through our +60000 articles I forgot to add a column to the ...
0
votes
1
answer
727
views
Excel Destination [140]: An error occurred while setting up a binding for the column. The binding status was "DT_NTEXT"
I have SSIS package that takes data from OLE DB source and loads to an Excel. The Field in the SQL table is nvarchar(max) and the data conversion I put for it when it goes into the excel is DT NTEXT. ...
-1
votes
1
answer
403
views
Stored procedure cut value of ntext parameter
I have a strange issue: i created a simple stored procedure in Microsoft SQL Server:
@id INT,
@ntextParameter NTEXT,
...
UPDATE xxx SET [Field] = @ntextParameter WHERE ID = @id
but when i execute it ...
0
votes
2
answers
4k
views
SQL Server reducing the length of the string to 8000 characters
I am trying to insert data in a table with column datatype as NTEXT. Ideally it should store more than 8000 characters, but the in my case it is reducing it to 8000 characters.
I am making the Insert ...
0
votes
1
answer
4k
views
Why Data Type DT_NTEXT from SQL Command OLE DB Source?
In our SSIS package, in the Data Flow OLE DB Source Editor, the Connection Manager is a SQL Command, and the SQL Command text is this:
With Managers AS (
select distinct t1.ID,
STUFF((SELECT ...
2
votes
1
answer
715
views
Load data from Table with column NVARCHAR(MAX) - Cannot convert to string as value is getting truncated
I have a DFT with OLEDB Source - sql table with column named description data type NVarchar(Max)
select max(len(description)) from tbl_Test -- returns 10,000
script transformation editor to perform ...
0
votes
0
answers
38
views
SQL Server 2014 Backup Performance and NTEXT columns
I run a database that has a tables with several NTEXT columns that contain short lived data. We would normally only keep a few weeks of data in those tables but in an effort to reduce disk usage this ...
1
vote
2
answers
3k
views
MS SQL Server cannot call methods on ntext
I am trying to create a view in MS SQL server from a table. The table name is Account_Plan and I am trying to create a view as Account_Plan_vw. While executing the DDL to create the view, I am getting ...
0
votes
2
answers
467
views
Parameter query on nvarchar(max) shows as ntext error
I recently converted all ntext column types in my database to nvarchar(max).
I then ran EXECUTE sp_refreshview for the related views.
Yet when I run the following Parameter query (from classic ASP) ...
0
votes
0
answers
192
views
After changing a column from ntext to varchar(max) a query becomes slightly slower
After changing a column from ntext to varchar(max) a query becomes slightly slower.
I'm doing a
select * from table_with_ntext
vs
select * from table_with_nvarchar_max
I thought that since the lob ...
0
votes
1
answer
2k
views
SQL converting NTEXT -> VARCHAR -> FLOAT and doing a difference
I have two fields, one that is int and one that is ntext. I need to subtract the ntext field from the int field. Im taking Hours_Current which is the int field and dividing it by 60. I've debugged ...