Hi John, In the ORACLE Metalink you can find the Note:191368.1: "How to use SQL Analyzer with the Oracle Provider for OLE DB and SQL Server 2000". I had the same problem and this document was very useful for me.Best regards. Javier
2004-01-22
1 reads
2004-01-21
Many of you know that Brian Kelley is our resident security guy. If you didn't, this might prove it! There is a ton of information in this 63 page document worth reading. Let us know what you think.
2004-01-21
774 reads
How about something like...select case when A=B then 1 else 0 end from ( SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*)) as A FROM Table1 ) RC1 , ( SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*)) as B FROM Table2 ) RC2
2004-01-20
2 reads
This looks very interesting. Can we get it uploaded to the Scripts library rather than trying to cut/paste from the Forum?
2004-01-19
1 reads
You might want to take a look at this comprehensive article on dynamic sql http://www.sommarskog.se/dynamic_sql.html
2004-01-19
creating a UDF for returning several rows into one rowSomebody posted this nice solution earlier:create function ValList ( @anID VARCHAR(5) ) returns varchar(500) as BEGIN DECLARE @retval VARCHAR(500) SET @retval = '' SELECT @retVal = @retval + CASE WHEN @retVal = '' THEN '' ELSE ',' END + myVal FROM TestMe (NOLOCK) WHERE myID = […]
2004-01-19
2004-01-19
1 reads
if i thought myself able to pick up on similar but new-to-me technology, i'd say, for example, i've done reporting on db2 and access databases for x nr of years, and so reporting for this other sql db technology would be a logical extension of that... etc.let them know where your strength(s) are and how […]
2004-01-16
2004-01-16
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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