order by

Technical Article

OLE DB provider EDAOLEDB.1

  • Topic

We connect to a mainframe database using EDAOLEDB.1 provider. It has worked for a few years for us with a few small problems. A couple of weeks ago we a developer wrote a simple query to extract all data from a table and insert it into Sql Server 2000.

You rated this post out of 5. Change rating

2004-02-04

3 reads

Technical Article

RE: Finding & removing a space from a string

  • Reply

Here is a method to remove large amounts of White space in a with a single commands that contains multiple REPLACE clauses: http://www.geocities.com/sqlserverexamples/#string2 Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

You rated this post out of 5. Change rating

2003-08-20

1 reads

Technical Article

RE: API Calls

  • Reply

Hi steinie, I don't think, that there is a direct way to call API functions. So you need to write a wrapper round it. Either COM or small exe. What function are you trying to call? Cheers, Frank

You rated this post out of 5. Change rating

2003-08-18

Technical Article

RE: How to convert Character to date

  • Reply

If you want to convert a dd/mm/yyyy string to a datetime value use something like: select convert(datetime, '27/02/2003', 103) or select convert(datetime, BillingDate, 103) The "103" tells the CONVERT function that the string is dd/mm/yyyy format.

You rated this post out of 5. Change rating

2003-07-04

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers