I have a blob file in SQL Server 2000 where I need to find all instances of ':' and replace with '--'. I tried the following SQL statement:select replace(GDTXVC, ':', '-') from proddta.f00165 where gdtxky= '2514|SO|00001|1.000' But, received this error message: Argument data type text is invalid for argument 1 of replace function.Is there a […]
2004-12-21
223 reads
2004-12-08
This should not be the problem. I am the local OLAP Administrator. So is the Service that is running SQL Server. And so is the account that I am impersonating in the connection. If it was a authenication issue, shouldn't fail when I make the connection while terminal serviced into the SQL Server?~ Nick
2004-12-08
While I tend to agree with you in general, I don't consider this a question of laziness, but rather knowledge and competence. Given the possibility to write code in T-SQL or some kind of VB or C#, I guess we agree what the majority will choose. For good or worse be that as it may […]
2004-12-07
your primary key should be artistID/productID (a composite primary key). if not, a unique constraint you have on those two columns, I hope!
2004-12-06
I know how to store the document as a blob in the SQL Server using VB.NET. I guess my primary concern is retreiving the blob data and opening it up in Microsoft Word using VB.NET.
2004-12-06
I had also a connection problem; since I add in the connection string following statement it works:<Network Library=DBMSSCOCN>"PROVIDER=SQLOLEDB;Network Library=DBMSSOCN;DATA SOURCE=your IP;Initial Catalog=your DB;UID=your User;PWD=your PW"
2004-12-04
Please don't cross post. all forums are covered. Answered in other post.
2004-12-03
I have a stored procedure that normally run correctly. As of this week, when trying to run the stored procedure from query analyzer, we get the following error:[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (WrapperRead()). Server: Msg 11, Level 16, State 1, Line 0 General network error. Check your network documentation. Connection Broken I researched the error and found […]
2004-12-03
Even degaussing the tape won't return it to it's 'new out of the box' state. If you really need a 'new out of the box' tape, you'll have to buy a new one.-SQLBill
2004-11-29
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers