Forum Replies Created

Viewing 15 posts - 646 through 660 (of 851 total)

  • RE: retrieving all customers whose surname begins with a certain letter

    [font="Verdana"]Perfect! :D[/font]

  • RE: A fun SQL bug

    [font="Verdana"]Indeed.

    Actually, the place I saw this more commonly was in unions, which have the same effect. The first statement within the union defines the types for the columns.

    [/font]

  • RE: retrieving all customers whose surname begins with a certain letter

    [font="Verdana"]I suggest you look at LIKE. Look it up in SQL Server Books Online. It should do what you want.[/font]

  • RE: A fun SQL bug

    Paul Harvey (2/15/2009)


    Any idea why the late binding? You think this late binding introduces much of an overhead?

    [font="Verdana"]Scratches head

    I think it's early binding.

    If it were late binding, it would...

  • RE: Are the posted questions getting worse?

    Adi Cohn (2/13/2009)


    I noticed that many people write about the importance of backing up the databases. For some reason, I hardly see remarks about importance of testing the restore...

  • RE: Are the posted questions getting worse?

    Michael Earl (2/13/2009)


    Roy Ernest (2/13/2009)


    Allright... Thanks for the explanation..

    Did you see this question?? :ermm:

    Don't you regularly export relational database systems to an Excel file?

    [font="Verdana"]Absolutely. One table per tab, and...

  • RE: Odd characters in output file?

    [font="Verdana"]You're welcome. I'm glad SSIS did the trick![/font]

  • RE: Convert Oracle ctl files to BCP fmt files

    [font="Verdana"]The poster mentioned that they are migrating their data warehouse from Oracle to SQL Server. So yes, I would agree that rebuilding their entire ETL would be a requirement.

    My...

  • RE: SQL or Oracle

    Max (2/14/2009)


    I thought people got that impression because Unix was a slim, unbloated platform whereas windows was FAT :w00t:

    [font="Verdana"]Wow, what version/brand of Unix are you using? I wanna meet...

  • RE: Design Question

    Bob Hovious (2/15/2009)


    By the way, where are you in New Zealand? My son currently lives in Dunedin.

    [font="Verdana"]Auckland. So other end of the country. Dunedin's a nice...

  • RE: How to convert INTEGER to TIME

    Jeff Moden (2/13/2009)


    Do you have an upper limit of 3599 seconds on this? What do you want to display if you hit 3600 seconds? What do you want...

  • RE: SQL 2005 64 bit - oracle 10g X64 - does not work..please help

    iqtedar (2/13/2009)


    i got the solution..thanks for answering...

    [font="Verdana"]...and the solution was?[/font]

  • RE: migration of sqlserver20005 to oracle10g

    [font="Verdana"]I'm wondering whether:

    Maybe the SQL Server table got created under a schema? In which case schema.table would the the correct form.

    Maybe the SQL Server table got created with the...

  • RE: SQL or Oracle

    Roy Ernest (2/13/2009)


    Bruce W Cassidy (2/12/2009)


    Roy Ernest (2/11/2009)


    One thing I have seen is that Unix (Linux or Sco or what ever) has a better File system. This made Oracle much...

  • RE: Why do people need to do this?

    [font="Verdana"]Okay, not exactly sure this is related. I await correction with trepidation. However...

    In a company that shall not be named for which I had the misfortune to work...

Viewing 15 posts - 646 through 660 (of 851 total)