SQL 2012 evaluate installation requirements
As part of my preparations for 70-462 Administering SQL Server 2012 today I have created a blog post covering "evaluate...
2012-07-24
1,299 reads
As part of my preparations for 70-462 Administering SQL Server 2012 today I have created a blog post covering "evaluate...
2012-07-24
1,299 reads
You can enforce referential integrity (ensure you don't get orphans) by adding Foreign Key Constraint and in this tutorial you...
2012-07-24
928 reads
In this blog psot we show how to restrict users from entering duplicated data by using SQL UNIQUE Constraint. In...
2012-07-24
780 reads
One of the PowerPivot advantages is flexibility of changing measure aggregation for instance changing average to minimum. PowerPivot applies default...
2012-07-23
685 reads
In this PowerPivot tutorial I show how to improve user experience by hiding fields from PivotTable (client tool) so user...
2012-07-23
813 reads
We have now added SQL CHECK CONSTRAINT to Exam Guide 70-461 Querying SQL Server 2012 and SQL Tutorial
2012-07-23
914 reads
This time we show how to use SQL DEFAULT CONSTRAINT to provide values for fields that are not given a...
2012-07-23
617 reads
In this tutorial we show how to use ALTER TABLE and add Primary key constraint. This tutorial support our Exam...
2012-07-23
744 reads
In previous lessons we create basic PowerPivot model now it is time to see how it looks in Excel 2013...
2012-07-22
1,263 reads
We continue creating our PowerPivot model using Excel 2013 by adding relationships. We use two methods "manage relationships" dialog box...
2012-07-22
886 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers