Exploring the Varbinary Type
A brief look at the Varbinary data type and its uses in SQL Server for beginners.
2013-02-07
12,670 reads
A brief look at the Varbinary data type and its uses in SQL Server for beginners.
2013-02-07
12,670 reads
The way variable scoping works in SQL Server has been well documented on MSDN, but I have seen related issues...
2013-01-18
2,832 reads
Purpose and introduction A Python program will not be able to take advantage of more than one core or more...
2012-12-21
4,752 reads
Intro Recently, I came over Cython and started experimenting with it. After some basic testing, I found several things of...
2012-11-23
1,186 reads
The differences and interactions between class variables and instance variables are well described in the Python 2.x documentation, but they...
2012-10-06
2,346 reads
Not long ago I wrote about how to write well about SQL Server, and one major point was that jargon...
2012-09-04
1,124 reads
I. Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me. Being a...
2012-07-29
5,685 reads
My article Plotting SQL Server Data for Data Visualization is up on MSSQLTips now and discusses using PyQt and Matplotlib...
2012-07-21
818 reads
A look at the performance of SQL Server compared to SQLite for single user applications.
2012-07-19
7,049 reads
I. Introduction I recently submitted my entry for a writing competition as part of my continuing education. While I was...
2012-07-09
1,424 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