I am new to SQL Server 2005. I am debugging a stored procedure that has a statement that starts with Select 'DIV' Region. What is DIV? I can't find it in the book and it is not a column in the table. Region is a column, DIV is not. Any ideas?????

Frank Bartkowski

If the statement is literally:

SELECT 'DIV'

When you execute this in Query Analyzer it will literally return DIV as the output. So, essentially, you are selecting a String Literal through a query.

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

With the query you specified, even if Region is a column in your table, it is being replaced by the 'DIV' literal value in the output (not on the actual table). Region, in this case, is the column name in the output.

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp

Assuming you have the following Regions table with the following data:

RegionID, Region, blah, asdf
-------- ------ ---- ----
1 NW stuff stuff
2 SW stuff stuff
3 NE stuff stuff
4 SE stuff stuff

If you were to run the following query:

SELECT 'div' Region FROM Regions

You would get the following:

Region
------
div
div
div
div

Hope this helps...



Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html