Solved

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

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

867 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

25 Experts available now in Live!

Get 1:1 Help Now