How to write an UPDATE query
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This...
2017-06-07
124 reads
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This...
2017-06-07
124 reads
My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....
2017-05-31
385 reads
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
157 reads
When we want to retrieve information from a database, we query the structure with language appropriate to the database. Remember...
2017-05-17
98 reads
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
224 reads
By now you will have heard that the next version of SQL Server has been announced. There’s no release date yet,...
2017-05-03
86 reads
You’re reading this series of posts because you want to learn about databases and how to use them. What you...
2017-04-26
92 reads
Taking a short break from the Database Fundamentals series of the last few weeks, I’d like to mention some upcoming...
2017-04-19
110 reads
A friend of mine in the filmmaking business, who is exceedingly bright but has never worked with SQL Server before,...
2017-04-12
94 reads
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...
2017-04-05
104 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers