How to write an INSERT query
My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....
2017-05-31
392 reads
My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....
2017-05-31
392 reads
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
163 reads
When we want to retrieve information from a database, we query the structure with language appropriate to the database. Remember...
2017-05-17
103 reads
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
236 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
95 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
97 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
113 reads
A friend of mine in the filmmaking business, who is exceedingly bright but has never worked with SQL Server before,...
2017-04-12
101 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
112 reads
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...
2017-03-29
314 reads
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
I have table: t1 in schema1 with 19 billion records. I have another table...
Comments posted to this topic are about the item Minimally Viable Security
Comments posted to this topic are about the item Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers