Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Posts
    19

    Unanswered: how can i find the parameters in dinamic sql statement

    hello
    i have statement which has @ as a parameters ....
    how can i find the values of thesee parameters ?
    please help

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Without seeing the statement I'm going to venture a guess. The @ symbol in Transact-SQL denotes a user variable and the @@ denotes a system function which behaves like a read-only variable.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Aug 2010
    Posts
    19
    i get this
    (@Param000004 int,@Param000005 int,@Param000006 varchar(29))INSERT [app].[INFO_TABLE]([ID1],[ID2],[NAME]) VALUES(@Param000004,@Param000005,@Param000006)
    i need to get the values of parameters

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •