Search results for query: *

Hi I have a table in excel, which either has a date or says emptyCell. HLDR ----- 22/09/1988 emptyCell emptyCell 22/06/1993 1/04/1991 29/03/1990 I am trying to import the data (using the import wizard)into sql server, but even if i set the datatype to varchar or nvarchar for the destination...

Hi Three questions 1. I've got some data (see below) that contains @{}*, how would i escape these characters. I tried using quotemeta but but i get the following error messages if i try to print $testString. Possible unintended interpolation of @Rose in string at prints1.pl line 13...

I've got a document which is about 40,000 characters stored in an ntext field. I have used 'set @@textsize' in query analyser to increase my textsize. I have written a query : DECLARE @Val varbinary(16) SELECT @Val = TEXTPTR([DocumentXML]) FROM [tblDocument] WHERE [DocumentID] = '91'...

Can anybody help me I have a document which appears to be too large for the ntext datatype. When i retrieve the document (using coldfusion or the query analyzer in SQL Server) it's truncated. Is there anything I can do?

I have roughly 400 images of varying sizes some portrait and some landscape. Is there a way I can run a batch process to resize them all so that the longest side whether portrait or landscape is 300 pixels. Kitty

Can anybody help? I'm trying to open tables within sql server 2000 enterprise manager and I keep getting the following message: "The query cannot be executed because some files are either missing or not registered. Run setup again to make sure the required fields are registered" I...