SQL Server, how to merge two columns into one column?

sql sql-server calculated-columns
user3807363 picture user3807363 · Aug 8, 2014 · Viewed 83.6k times · Source

I have a SQL query

SELECT TABLE_SCHEMA + TABLE_NAME AS ColumnZ 
FROM information_schema.tables

I want the result should be table_Schema.table_name.

help me please!!

Answer

Adrian picture Adrian · Aug 8, 2014

Try this:

SELECT TABLE_SCHEMA + '.' + TABLE_NAME AS ColumnZ 
FROM information_schema.tables

Related questions

getting "No column was specified for column 2 of 'd'" in sql server cte?

I have this query, but its not working as it should, with c as (select month(bookingdate) as duration, count(*) as totalbookings from entbookings group by month(bookingdate) ), d as (SELECT duration, sum(totalitems) FROM [DrySoftBranch].[dbo].[mnthItemWiseTotalQty] ('1') …

Read More
Creating date in SQL Server 2008

Is there something similar to DATEFROMPARTS(year, month, day) in SQL Server 2008? I want to create a date using the current year and month, but my own day of the month. This needs to be done in one line in …

Read More
Use value of a column for another column (SQL Server)?

lets say I have a huge select on a certain table. One value for a column is calculated with complex logc and its called ColumnA. Now, for another column, I need the value from ColumnA and add some other static …

Read More