T-SQL 101: #14 Using two part names for SQL Server tables and other objects

added by DotNetKicks
4/25/2019 1:12:30 PM

1 Kicks, 163 Views

If you look carefully at the following simple query: you'll notice that I didn't just say FROM Cinemas, I said FROM dbo.Cinemas. The "dbo." part is the name of the schema. I talked about schemas in an earlier post. And all through these T-SQL 101 blog posts, I keep mentioning that you should always use ...