Data to test:
CREATETABLE [dbo].[emp]( [emp_id]
[nchar](10)NULL, [emp_name]
[nchar](10)NULL, [salary]
[int] NULL)ON [PRIMARY] insert emp( emp_id,emp_name,salary ) select'1','ABC',-20000 insert emp( emp_id,emp_name,salary ) select'2','XYZ',-5000 insert emp( emp_id,emp_name,salary ) select'3','PQR',-7800 insert emp( emp_id,emp_name,salary...
2013-02-04
773 reads
Welcome to Day 3 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-03
1,622 reads
Welcome to Day 2 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-02
1,873 reads
Say you have a simple data transfer class that looks like this:
Public Class Employee
Public Property Name As String
Public...
2013-02-02
1,172 reads
Here is the February 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-02-01
1,017 reads
Earlier this week, I wrote a quick blog post on a throw-away script I had written. The blog post was DETERMINING...
2013-02-01
643 reads
It’s not too hot, it can be fun, and after a full day of SQL Server learning, there are lots...
2013-02-01
1,237 reads
Do you use the FLOAT datatype? If so you had better read this……
Today I came across an issue somebody posted...
2013-02-01
5,156 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-01
920 reads
Welcome to Day 1 of my “A Month of PowerShell” series. PowerShell is one of those things that I know...
2013-02-01
2,218 reads
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
Comments posted to this topic are about the item Switching Schemas 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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers