Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

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

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
paindoookhan
Asked:
paindoookhan
  • 2
2 Solutions
 
SreeramCommented:
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
 
Koen Van WielinkIT ConsultantCommented:
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
 
paindoookhanAuthor Commented:
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
 
Koen Van WielinkIT ConsultantCommented:
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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now