T-SQL Integer Data-Type Conversions
This article will show some common integer data-type conversions using T-SQL.
2012-06-26
7,453 reads
T-SQL
2012-06-25
3,097 reads
2012-06-22
2,834 reads
2012-07-03 (first published: 2012-06-21)
1,386 reads
10 tips on converting MS SQL queries to MySQL
The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax.
2012-06-01
6,041 reads
2012-05-24
3,169 reads
2012-05-22
3,143 reads
The T-SQL of CSV: Comma-Delimited of Errors
Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewhat magical. Just to prove it is possible, Phil Factor creates a CSV version of AdventureWorks as a linked server.
2012-05-11
5,604 reads
2012-05-10
3,685 reads
2012-05-09
2,994 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers