SCOPE_IDENTITY() or @@IDENTITY
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...
2017-01-27
19 reads
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...
2017-01-27
19 reads
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation...
2017-01-27
288 reads
I am so happy to share the news that as of today, the new community CloudProPT (as in Cloud for...
2017-01-27
463 reads
I’ve been wandering through the dbatools set of cmdlets, trying to see where various cmdlets are useful, and also practicing...
2017-01-27
520 reads
Here is a list of the upcoming PASS Virtual Groups and SQLSautrday Events.
January, 2017
Tuesday,January,31
Introduction to Oracle SQL and PL...
2017-01-27
674 reads
I've seen a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from...
2017-02-01 (first published: 2017-01-27)
3,248 reads
Is it really still January? It seems like this month is dragging on a bit. Anyway, this week I’ve been...
2017-01-27
410 reads
Microsoft just announced Microsoft SQL Server 2016 Cumulative update 1 (CU1)
Microsoft reference: [Click Here]
Ganapathi varma ChekuriLead SQL DBA, MCPLinkedin
2017-01-27
322 reads
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran...
2017-02-03 (first published: 2017-01-26)
1,747 reads
The day begins and you find yourself going through a list in your mind of things that need to be...
2017-02-02 (first published: 2017-01-26)
1,917 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