Sysmail_help_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 10
Hi friends, in this blog of SQL Server database mail stored procedure we will continue with another database mail stored...
2015-06-15
407 reads
Hi friends, in this blog of SQL Server database mail stored procedure we will continue with another database mail stored...
2015-06-15
407 reads
Hi friends, in this blog of SQL Server Database mail stored procedure we will continue with another database mail procedure sysmail_add_principalprofile_sp....
2015-06-13
482 reads
Hi folks, in our previous blog of SQL Server Database Mail stored procedure we added database mail account to database...
2015-06-08
414 reads
Hi friends, in last previous blogs we created database mail profile and database mail account. In this blog we will...
2015-06-04
489 reads
User-defined functions encapsulate T-SQL statement and return a table or a scalar value to the caller. UDFs can not be...
2015-06-01
363 reads
Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp....
2015-05-30
868 reads
Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account...
2015-05-28
964 reads
Hi friends, today we will learn how to get information about database mail profile using stored procedure sysmail_help_profile_sp. Sysmail_help_profile_sp stored...
2015-05-26
332 reads
Hi friends, in this blog I will tell you how can we find blocking using sp_who system stored procedure. Also,...
2015-04-22
287 reads
Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating...
2015-04-18
226 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 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
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