SQL for 8-year-old Math…But Be Careful of Implicit Type Conversion
How we can use SQL to solve a math problem published in The Guardian...but with a caution about implicit type conversion.
2015-07-14
7,364 reads
math
Integer left and right shift
3 functions that implement the left (<<), right (>>) and unsigned right (>>>) shift operators, commonly found in C-style languages.
2012-02-15 (first published: 2011-12-30)
6,999 reads
Stairway to T-SQL DML Level 5: The Mathematics of SQL: Part 2
Joining tables is a crucial concept to understanding data relationships in a relational database. When you are working with your SQL Server data, you will often need to join tables to produce the results your application requires. Having a good understanding of set theory, and the mathematical operators available and how they are used to join tables will make it easier for you to retrieve the data you need from SQL Server.
2019-05-29 (first published: 2011-11-30)
17,225 reads
Stairway to T-SQL DML Level 4: The Mathematics of SQL: Part 1
A relational database contains tables that relate to each other by key values. When querying data from these related tables you may choose to select data from a single table or many tables. If you select data from many tables, you normally join those tables together using specified join criteria. The concepts of selecting data from tables and joining tables together is all about managing and manipulating sets of data. In Level 4 of this Stairway we will explore the concepts of set theory and mathematical operators to join, merge, and return data from multiple SQL Server tables.
2019-05-22 (first published: 2011-11-16)
23,215 reads
2010-05-12 (first published: 2009-07-09)
2,822 reads
RE: Merging 2 tables?
It is to run over an Internet connection. Can you please tell me why Merge Replication is the better choice in this instance then if for the other scenerios it is such a bad choice.thanks
2004-07-20
RE: convert float to string
I'm getting this as xml and transforming using xslt. If someone can show me how to do the formatting in xslt that would be cool.
2004-07-16
RE: Memory question
We are running SQL Server 2000, SP3 Standard Edition on Windows Server 2000 SP4 with 4 gig of memory and a 4 gig swap file. My current settings in EM on the Memory Tab are Dynamically configured SQL Server Memory with a minimum of 0MB and a maximum of 3712MB. Sql Server is the only […]
2003-11-18
2 reads
2003-08-20
1 reads
RE: Finding & removing a space from a string
Here's a simple one. It will only remove one space, but it will work for mulptiple spaces if you run it multiple times. declare @strName varchar(100) select @strName = 'St James' select left(@strName,(charindex(' ',@strName)-1))+right(@strName,(len(@strName)-charindex(' ',@strName)))
2003-08-20
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers