How we can convert Comma Separated Value to Rows and Vice Versa?
How we can convert Comma Separated Value to Rows and Vice Versa?
Basic fundamental
While we are working on reporting some circumstances...
2015-10-08
459 reads
How we can convert Comma Separated Value to Rows and Vice Versa?
Basic fundamental
While we are working on reporting some circumstances...
2015-10-08
459 reads
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
404 reads
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
570 reads
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have...
2015-10-16 (first published: 2015-10-07)
1,819 reads
Caution must be exercised when mixing Transparent Data Encryption (TDE) and Availability Groups to ensure databases don't end up in...
2015-10-07
700 reads
I will be speaking this weekend at SQL Saturday #445 - Raleigh, NC. If you are in the area, please come...
2015-10-07
497 reads
Some time we need to know that who is using database as of now or who all are connected to...
2015-10-07
618 reads
It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on...
2015-10-07
669 reads
The Assumption I assume you already have a Hyper-V basic configuration on your system, be it a laptop, server or...
2015-10-16 (first published: 2015-10-07)
1,211 reads
Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services...
2015-10-19 (first published: 2015-10-07)
3,027 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman...
Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec. Cilandak, Kota...
Comments posted to this topic are about the item Switching Schema II
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers