Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2014-02-02
5
244 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
5 Comments
 
LVL 3

Accepted Solution

by:
Sreeram earned 125 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 125 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…

839 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