Solved

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

Posted on 2014-02-02
5
239 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 12

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 12

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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…
Creating and Managing Databases with phpMyAdmin in cPanel.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now