Connect to SQL Azure database from SSMS
In this article I'll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-06-17
326 reads
In this article I'll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-06-17
326 reads
Until SSMS 2014 there were the two standard authentication options for connecting to a SQL Server instance: Windows Authentication and...
2016-06-14
4,741 reads
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...
2016-06-13
273 reads
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...
2016-06-13
317 reads
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...
2016-06-13
11 reads
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...
2016-06-13
3 reads
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
634 reads
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
394 reads
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...
2016-06-11
6 reads
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...
2016-06-11
11 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Hello SSC, Has anyone encountered this before??? I have an odd issue that I...
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...
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
exec etl.GettheProduct
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