Quick Tips–Using ii in #SQLPrompt
SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...
2016-10-21 (first published: 2016-09-27)
1,848 reads
SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...
2016-10-21 (first published: 2016-09-27)
1,848 reads
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b)...
2016-10-10 (first published: 2016-09-27)
2,062 reads
I will be writing
this article in four parts because this topic is huge and amount of information
can be overwhelming for...
2016-09-27
511 reads
TSQLCircleLive: What will be the result of the query below? Explai...: select case when null = null then 'True' else 'False'...
2016-09-27
377 reads
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that...
2016-10-11 (first published: 2016-09-27)
1,510 reads
It less than week to SQL Relay - a week long SQL conference that is visiting Birmingham, Cardiff, Reading, Nottingham and...
2016-09-27
507 reads
In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is...
2016-09-27
415 reads
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
160 reads
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
327 reads
UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...
2016-09-26
196 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,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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