Forum Replies Created

Viewing 15 posts - 5,011 through 5,025 (of 5,356 total)

  • RE: Decimal versus Money and division

    Hello BillyWilly,

    quote:


    No big deal - I'll just do some casting during division to get the 12 precision I want - just found...

  • RE: Stored Procedures

    Hello Flavio,

    de niente, buoa fortuna!

    Cheers,

    Frank

  • RE: Stored Procedures

    Hello Flavio,

    quote:


    select ....FIELDS_NAME, .... from [SERVER_NAME].[DB_NAME].[dbo].[TABLE_NAME_2]


    does SELECT * FROM [dbname].dbo.table_name_2 also not work?

    Cheers,

    Frank

  • RE: How to corrupt a db

    Hello Mark,

    quote:


    works on SQL2k anyway. You can stop mssqlserver and then play around with a hex editor in the mdf file...

  • RE: Transaction log backup failing

    Hello Mark,

    quote:


    Frank,

    If it's a maintenance plan job, look at the report specified on the plan's reporting tab. If you haven't requested...

  • RE: Searching huge Web database

    Hello nafshan,

    quote:


    Can someone will give me some hints in searching millions and billions of record very fast.


  • RE: Running scripts from scripts

    Hello David,

    quote:


    Ideally I would like to be able to do something along the lines of

    echo off

    cls

    osql -USA -PPassword -iInstall01.sql -oInstall01.Err

    if ErrorLevel==0

      osql -USA...

  • RE: Scheduling DTS Packages...

    Hello Carl,

    quote:


    Any other ideas?


    are you able to figure out where the package hangs (AS400, DB...

  • RE: IMPORTING AN ASCII TEXT FILE DAILY

    Hello Mike,

    quote:


    I receive an ASCII text file daily that contains the current stock levels from our parent company, (CSV type delimited by...

  • RE: Can jsp be used in SQL?

    Hello gzh1111,

    quote:


    Saw an article says that Oracle 8i has a build in JSever, and be able to run JSP. Wondering if SQL...

  • RE: Importing PHP into MSSQL 7.0

    Hello Todd,

    another thought that came to my mind is, that - assuming a 'good' programming - all stuff that is needed to built the new db should be placed in...

  • RE: Decimal versus Money and division

    Hello BillyWilly

    the money type has an accuracy of a ten-thousandth of a monetary unit. That is 1.1234. Any numbers after these 4 digits are rounded. While I think, this accuracy...

  • RE: Importing PHP into MSSQL 7.0

    Hi Todd,

    quote:


    I guess, both? I've a functional MSSQL 7.0 machine. I've a bunch of php scripts which comprise a DB....

  • RE: How Does SQL count lines?

    Hi Antares686,

    quote:


    SELECT

    *

    FRO Test1

    and run. You will get Line 3 as a syntax issue. Click the error in the report section of QA...

  • RE: Importing PHP into MSSQL 7.0

    ???,

    was the question how to get php working with SQL7 or how to create a SQL db when the scripts are all in php?

    Cheers,

    Frank

Viewing 15 posts - 5,011 through 5,025 (of 5,356 total)