Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    7

    Unanswered: Executing stored procedures

    Hello,

    I know that syscomments stores the stored procedures in chunks of 4000 characters. Some of my Stored proc's are >4000 characters.I use a temporary table to stock them after some modifications made to them.How can I execute them one by one, do i need to concatenate one whole stored proc's text in one single line(if yes, how can that be done?) Can variables be dynamically created, assigned values and then destroyed? Please help.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Huh?

    What are you doing?

    You should have your sprocs scripted out and saved in some type of change control

    To execute a sproc

    EXEC @rc=mySproc99

    want to eloborate?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    May 2004
    Posts
    7

    executing stored procedures

    thanks for replying..i can't change the way i'm doing this since it's only a part of the final picture, but if u cud just let me know the way to concatenate multiple TEXT lines(the maximum number of lines can change) stored in multiple rows into one single line in one single row.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    DECLARE @x varchar(8000)

    SELECT @x = ISNULL(@x,'') + Comments FROM Syscomments
    WHERE id =...

    But that'll be good for just 2 rows...

    All I can say is I have no idea what you're trying to do...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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