2009-05-25
3,309 reads
T-SQL
2009-05-25
1,377 reads
2009-05-21
4,582 reads
2009-05-20
4,540 reads
2009-05-19
3,685 reads
Swap column data due to inserting data into wrong columns for SQL Server table
This article is for newbies who have just started their career in SQL development. Everyone might have faced this problem when importing or inserting data into tables when they accidentally put the data in the wrong columns. The first thought would be to delete the data and start over, but in this tip we look at a simple solution to swap the data.
2009-05-13
2,356 reads
ROW_NUMBER(): An Efficient Alternative to Subqueries
The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.
2010-01-29 (first published: 2009-05-12)
72,794 reads
2009-05-11
4,533 reads
2009-05-07
4,153 reads
2009-05-06
3,965 reads
Blogs
The Cost of Not Having a DBA
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
Who are you? Building an identity map.
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Call a Fabric REST API from Azure Data Factory
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
Forums
How to update using data from three tables?
I am in the process of migrating from MySQL to SQL Server. I have...
Select Returning Blank Rows
I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...
How to update a history table with changes.
Good morning to all. I am a novice when it comes to SQL so...
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers