fxferguson, Author at SQLServerCentral

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 ,...

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

fxferguson@chp.org

Blogs

Set a Runtime Variable in an Azure DevOps Pipeline

A New Word: Symptomania

Query Store Keeps Switching Itself Off, Getting it Moving Again

Forums

Is the University of Essex recognised?

Is the University of Essex recognised?

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

Question of the Day

Which is a table?