Blogs

Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox

By

Are you ready to take your SQL skills from theoretical to tactical? If you've...

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Read the latest Blogs

Forums

Log Reader Agent error

By Meera

Dear all, What is the reason and fix for the below error? The Replication_User...

how to see the effect of Enable Scalar UDF Inlining in query plan

By rajemessage 14195

hi, i read this artical https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver16 but could not reproduce  the following results ,...

Protecting Schools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Protecting Schools

Visit the forum

Question of the Day

Which is a table?

Of these items, which are tables according to the relational model from Dr. Codd? 

CREATE TABLE dbo.Customers_a
(
    CustomerID INT IDENTITY(1, 1) NOT NULL,
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NOT NULL,
    Email NVARCHAR(100) NOT NULL,
);

CREATE TABLE dbo.Customers_b
(
    CustomerID INT IDENTITY(1, 1) PRIMARY KEY,
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NOT NULL,
    Email NVARCHAR(100) NOT NULL,
);

CREATE TABLE dbo.Customers_c
(
    CustomerID INT NULL IDENTITY(1, 1),
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NOT NULL,
    Email NVARCHAR(100) NOT NULL UNIQUE,
);

CREATE TABLE dbo.Customers_d
(
    CustomerID INT NOT NULL ,
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NOT NULL,
    Email NVARCHAR(100) NOT NULL,
);

See possible answers