Home Forums SQL Server 7,2000 General Syntax error in Dynamic SQL - SQL Server 2000 RE: Syntax error in Dynamic SQL - SQL Server 2000

  • There's no way to mark it as solved or closed (unless you're an administrator).

    I will make emphasis on avoiding the use of functions in your queries. Your query won't be able to use indexes or multiple processors and that will have a huge impact on performance.

    Beware as well of float types, they can give inaccurate information and you should use decimal (or numeric). As bytes usually won't have decimal positions you could use int or bigint.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2