Merge Command In Sql Server
Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and...
2012-04-17
1,761 reads
Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and...
2012-04-17
1,761 reads
For me, conference season begins with the new year, and ends with the PASS Summit (sorry, November and December SQL...
2012-04-17
691 reads
Microsoft’s Corporate Vice President Brad Anderson announced today at the Microsoft Management Summit 2012 in Las Vegas that the next...
2012-04-17
1,029 reads
While attending a recent Windows Azure Quick Start, the presenter, Mike Benkovich (@mbenko) happened to show a table on his...
2012-04-17
603 reads
This morning, Microsoft released SQL Server 2008 R2 SP1 CU6, which is Build 10.50.2811.0. This Cumulative Update lists 20 fixes...
2012-04-17
2,753 reads
I have a confession to make. I like to meet people who also work with SQL Server. There are so...
2012-04-17
706 reads
In the land of Oracle, if you want to prevent user access to your database, you stop the listener. Without...
2012-04-17
1,763 reads
I spotted a new task in SSIS 2012 – Execute T-SQL Statement Task. It executes T-SQL statements, only Transact-SQL statements against...
2012-04-17
1,205 reads
American Icon: Alan Mulally and the Fight to Save Ford Motor Company ($18 at Amazon) was a good read, with...
2012-04-17
800 reads
In part five of this on going series about choosing the right reporting tool we will discuss the newest of...
2012-04-17
1,636 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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