Solved

Help me decipher this SQL query

Posted on 2010-11-30
1
246 Views
Last Modified: 2012-05-10
Select name into ##TestFields from syscolumns where Id = object_id('" + @tablename + "') and xtype in (167,231)
0
Comment
Question by:spirose
1 Comment
 
LVL 6

Accepted Solution

by:
hyphenpipe earned 50 total points
ID: 34242419
It appears to be part of a stored procedure where you supply the name of a table (@tablename) and it will insert into a global temporary table, hence the ##, the name of every varchar (167) and nvarchar(231) column in that table.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Consolidating oracle query results to a single line 8 53
all records from previous month 6 45
Dimension table indexes 8 14
sql Total query 2 17
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

862 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

24 Experts available now in Live!

Get 1:1 Help Now