Answer Posted / Nagpal Singh
To find the columns used in a stored procedure in SQL Server, you can use the following query:n```sqlnUSE your_database;nEXEC sp_helptext your_stored_procedure;nGOn``` This will return the text of the stored procedure, including the SELECT statement that defines the columns used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you index views?
How to remove duplicate rows from table except one?
What are the kinds of subquery?
What is an indexed view?
How to convert numeric expression data types using the cast() function?
How do I find query history in sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
List the ways in which dynamic sql can be executed?
Why should you use or avoid select * statements?
Can sql servers link to other servers like oracle?
What is the difference between upgrade and migration in sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Why use identity in sql server?
Disadvantages of the indexes?
