Querying Microsoft SQL Server : Defining Variables
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2013-03-13
846 reads
Find Transaction Log information
Transaction Log in SQL server records all operation on database.This recoring depends on Recovery Model selected for database.You can find...
2013-03-08
636 reads
Search all running SQL Server instances over LAN
Sometimes you need to know how many and what instances of
SQL Server running in your organization over Network. You can...
2013-02-22
2,365 reads
Generate Random Passwords using T-SQL
Use following script to generate random Passwords
DECLARE @id int,@list varcharSET @list ='abcdefghijkmnopqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ23456789.,-_!$@#%^&*'selectreplace(SUBSTRING(CONVERT(varchar(255),NEWID()),8, 8),'-','')as RANDOM
Example:
Suppose you have a table tblUser with columns[id],[userid],[password].
CREATETABLE [dbo].[tblUser]( ...
2013-02-12
4,861 reads
Handling Null Values in SQL Server
What is NULL?
In SQL, A Null is an unknown or undefined value. Some interesting
operations on NULL.
--query --resultselect 3*NULL --NULLselect 3+NULL ...
2013-02-05
529 reads
Frequently asked SQL Server Queries
Data to test:
CREATETABLE [dbo].[emp]( [emp_id]
[nchar](10)NULL, [emp_name]
[nchar](10)NULL, [salary]
[int] NULL)ON [PRIMARY] insert emp( emp_id,emp_name,salary ) select'1','ABC',-20000 insert emp( emp_id,emp_name,salary ) select'2','XYZ',-5000 insert emp( emp_id,emp_name,salary ) select'3','PQR',-7800 insert emp( emp_id,emp_name,salary...
2013-02-04
752 reads
DBCC Commands for SQL Server
DBCC Commands:
DBCC commands are most useful for
performance and troubleshooting.
The DBCC Commands are used in Maintenance, Informational use, Validation on a
database,...
2013-01-28
2,033 reads
SQL Server
What is SQL Server?Microsoft SQL Server is Relational database management system (RDBMS) developed and owned by Microsoft. It is a software...
2013-01-28
425 reads
Frequently asked Scripts during Interviews
1.Select no of Months between two dates:
SELECT DATEDIFF(MONTH,'4/1/2011','01/23/2013')+ CASE WHENDAY('4/1/2011')<DAY('01/23/2013') THEN 1 ELSE 0 END
Output:
----------------
22
2.What will be the
output of following...
2013-01-24
497 reads
FOR XML Clause
FOR XML CLAUSE: Sometimes we need to data in form of XML from
Database.SQL Server provide FOR XML Clause. For XML clause...
2012-12-26
773 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
How Good Is Pench National Park for First-Time Wildlife Travelers?
Pench National Park is one of the best places to visit for the first...
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Question of the Day
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