Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: Check if a file exist in a Query!

    some code that can be used in DTS package to check if a file exists:

    Function Main()

    Dim objFSO

    Dim cFilePath

    Dim cFileName

    cFilePath = "<file path>"

    cFileName = "<file name>"

     

     -- instantiate the Scripting Object

      set...

  • RE: Help with first dynamic SQL attempt

    CREATE PROCEDURE Z_Billing_Payment

    (@GetWhat as Varchar(15),

    @PaymentID as int)

    --set @GetWhat = 'something'

    --set @PaymentID = 1

    as

    Declare @SQL VarChar(1000)

    SET @SQL = 'SELECT '+@GetWhat+' From Payments Where PaymentID = '

    +cast(@PaymentID as varchar (10))

    --PRINT @SQL

    Exec...

  • RE: Convert 2003-01-08 00:00:00 into 08/01/2003

    select convert(varchar,cast('2003-01-08 00:00:00'as datetime),103)

  • RE: SQL Injection in stored procedure

    a

  • RE: SQL Injection in stored procedure

    New to this this forum so dont know if this is appropriate to ask for email addresses but I have a great document about SQL injection attacks in SQL Server and...

  • RE: Creating Relations with T-SQL

    Beth

    What exactly do you mean by creating relationships between tables in T-SQL ?

    When you write any T-SQL you can relate tables together using join syntax - post what you would...

  • RE: Getting MAX value

    when you insert the new batch instead of setting the

    GL_Control=0

    set it to = 1 then others will sequentially be in the correct order

    otherwise you could

    Update Yourtable

    set GL_Control= GL_Control +...

  • RE: Question of the Day for 05 Oct 2004

    I agree with a previous reply that you can set the ansi nulls on either before or after the creat proc statement.

    One point though - if the correct answer SP...

Viewing 8 posts - 1 through 8 (of 8 total)