AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AugSQL
AugSQL
View the Definition...
 
Notifications
Clear all

Idea - Shipped View the Definition of a View or Stored Procedure

 
Votes Received: 0

AugSQL
Last Post by Tim Rodman 2 years ago
2 Posts
2 Users
1 Reactions
57 Views
RSS
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
Topic starter
May 1, 2023 8:51 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Since one of the big benefits of TimSQL is making it easier to create custom SQL View and Stored Procedures, it would be nice if you could easily see the definition of an existing SQL View or Stored Procedure.

 

In SQL Management Studio, I can accomplish this using the sp_helptext command like this:

image

 

I can execute the same SQL code in TimSQL with the EXEC button and it runs, but it doesn't come back with the resulting text:

image

 

Ideally, the EXEC button, would return the text from the execution, but if that's too complicated, maybe we could have another button that would specifically be for running the sp_helptext command.

1 Reply
AugSQL Developer
 AugSQL Developer
Admin
(@augsql)
Joined: 2 years ago

Active Member
Posts: 9
May 3, 2023 11:49 pm
Reply toTim RodmanTim Rodman

@timrodman good use case, solution inbound

Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
Topic starter
May 4, 2023 9:32 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Wow, that was fast!

image
Reply
AugSQL Developer reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,521 Topics
  • 10.9 K Posts
  • 11 Online
  • 2,321 Members
Our newest member: Courtney Wilder
Latest Post: Can UDFs be populated using an Import Scenario?
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×