It seems to me that there is only one right answer and that would be SELECT * FROM #test1 WHERE col1 LIKE '%5[%]%' The reason is because the query should return a row with the value 5% in col1. But suppose you have the value fjf5j%fjf in col1. SELECT * FROM #test1 WHERE col1 LIKE […]
2004-01-22
If I use the following statement: CASE WHEN ISNUMERIC(Field) = 1 THEN CAST(Field as Numeric) ELSE 0 END. So when the field has a numeric expression I convert it. Otherwise I put the value zero. This work as long as the field doesn't contain the values . , + and -. Because for these values […]
2004-01-21
2 reads
Hello,I'm having some trouble with a small app that I have been given to work on.I'm trying to retrieve records based on a date range.The dates are stored in the Access database as textWhen I try to retrieve the records (ex. Between 01/01/2003 and 12/31/2003)I still get all of the records dated in the 2004 […]
2004-01-14
I suggest another solution if you are interrested. If you want import iis log files to sql server database - ok, but when you must import for example 1 GB log files per day I suggest Log Parser 2.0. It's Microsoft tool and the most important thing it's free (I was reading license 6 months ago). You can […]
2004-01-14
1 reads
Have you tried accessing the data in the linked server using a view and then trying to access the view from the remote servers?
2004-01-14
Steve,Thank you for covering this important part of a products lifespan. I would like to recommend that the demo data that the system is running, is as close as possible to a very recent total copy of the live data. This will give the prospect a realistic view of the performance, and he'll be impressed […]
2004-01-14
1 reads
But if you have two or more log files this SP will not work. Read about it there http://qa.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp and there:http://qa.sqlservercentral.com/scripts/contributions/599.asp
2004-01-14
Please post your sp here.
2004-01-08
2004-01-05
I ran this from one session: CREATE TABLE [dbo].[tbltest] ( [Pkey] [int] IDENTITY (1, 1) NOT NULL , [fname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [lname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] go CREATE VIEW dbo.vwTest AS SELECT fname, lname FROM dbo.tbltest go grant select on tbltest to public go grant insert, update […]
2004-01-02
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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