What does this give you?

SELECT

o.name AS TableName,

c.name AS ColumnName,

t.name AS DataType

FROM

sys.objects o

INNER JOIN

sys.columns c

ON o.object_id = c.object_id

INNER JOIN

sys.types t

ON c.user_type_id = t.user_type_id

WHERE

o.name = 'Countries'

AND c.name = 'Country_Area'

Please show us the HTML code that executed (sic) successfully in a query window.

Please show us the HTML code that executed (sic) successfully in a query window.

What version of SSMS are you using to connect to the SQL Server 2012 instance?

You could always submit your own question.

Dan Guzman - Not the MVP (9/29/2014)

---

I have an execution plan that is huge, the pdf it generates if I print it is over 1000 pages. Is there a...

So reading the SQL will give you...

And this relates to SQL Server how? I am not here for maths lessons.

You have only shared a small piece of your code, so we need to guess.

Is your code selecting into a table? i.e. Maybe the following code example will show what...

http://en.wikipedia.org/wiki/Side_effect_(computer_science)

In computer science, a function or expression is said to have a side effect if, in addition to returning a value, it also modifies some state or has an observable...

Columnstore Indexes Described

MSDN only refers to tables and does not mention the columns.

http://msdn.microsoft.com/en-us/library/ms187926.aspx

A procedure can reference tables that do not yet exist. At creation time, only syntax checking is performed. The procedure...

ramchand.repalle (9/10/2014)

---

Hello All,

I have created one table and one stored procedure for to insert/delete/update the data in that table.

So,I was trying to move the scripts from one database to another...

Internal Tables

http://technet.microsoft.com/en-us/library/ms366343(v=sql.105).aspx

SELECT

it.name,

ind.name

FROM

sys.indexes ind

INNER JOIN

sys.internal_tables it

ON ind.object_id = it.object_id

SELECT

o.name,

ind.name

FROM

sys.indexes ind

INNER JOIN

sys.all_objects o

ON ind.object_id = o.object_id