Suppose we have a table emp_plan which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:-
Create table emp_plan (empid nvarchar(200),planid...
2015-08-03
3 reads
Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of...
2015-07-11
1,474 reads
Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of distinctively decent competitors they have within the space of...
2015-07-11
3 reads
Below script will help in finding the complete months within the 2 given dates. In the below script we takes...
2015-07-10
812 reads
Below script will help in finding the complete months within the 2 given dates. In the below script we takes below dates as exampleStartdate =2015-07-05Enddate =2016-01-06
/**********************Script Start**************************/IF (object_id('tempdb..#month') is...
2015-07-10
5 reads
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the...
2015-07-10
789 reads
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given dates. In this script,...
2015-07-10
5 reads
For any programming language, just writing the code is not well enough. It should be written using the best practices....
2015-02-01
4,148 reads
For any programming language, just writing the code is not well enough. It should be written using the best practices. This article will try to explain the disadvantages of...
2015-02-01
4 reads
Right():- This function returns the specified number of characters from the Right part of the given character string.Syntax:- Select RIGHT ( character_expression , integer_expression ) For example, the below query will...
2015-01-26
4 reads
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
The thread for the league in 2026. Players from last year have priority.
The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...
hi , i know this is a sql server forum but i think my...
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
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