Improve company productivity with a Business Account.Sign Up

x
?
Solved

I have a stored procedure and need to know what fields it belongs to

Posted on 2014-02-02
5
Medium Priority
?
258 Views
Last Modified: 2014-02-07
Hi

I have a stored procedure and need to know which fields is it referencing to and the corresponding tables

Unfortunately I don't have a lot of knowledge in advanced sql please help urgently


Thanks
DATASCRUB-STORProcedure.xlsx
0
Comment
Question by:paindoookhan
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
Sreeram earned 500 total points
ID: 39828805
Hi .

        Do  you need the functionality of the statement you have listed out in the Excel?

Example :

@p_cycle int    -->   Declaring the variable as integer.
@p_plans varchar(100)   -->  Declaring the variable as integer.


ep.EMPLOYEE_ID   -->  Employee_ID is the column name and ep is the table name .

       Select Employee_ID from Employee   can be written as Select EP.Employee_ID from Employee ep

If you are doing join it will be useful to select the particaular column form the table .
0
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 39828806
What is the attachment referring to? Looks like an export of some kind, but it doesn't make a whole lot of sense.
Can you open/edit the main stored procedure in your query editor?
Also, I assume you're workign with MSSQL and not MySQL? You've marked both in your topic list.
0
 

Author Comment

by:paindoookhan
ID: 39828813
I need to know the fields in question. What are the fields. I was given this stored procedure and asked to list all the fields and their corresponding tables. I wanted to know which fields is the stored procedure referring to and its corresponding table
0
 
LVL 13

Assisted Solution

by:Koen Van Wielink
Koen Van Wielink earned 500 total points
ID: 39828817
Sorry, but what you've attached doesn't look like a stored procedure. They're chunks of SQL referencing to a column name or something, but it does not form a stored procedure as a whole.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question