The CHOOSE keyword
G’day,
I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced...
2014-02-17
1,542 reads
G’day,
I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced...
2014-02-17
1,542 reads
TweetG’day,
Well, it’s the first TSQL-Tuesday of 2014 and one of my New Years resolutions for 2014 is to contribute to...
2014-01-14
1,294 reads
TweetG’day folks,
I remember a fair few years ago when I was relativly new to TSQL creating a stored procedure that...
2014-01-13
1,259 reads
TweetG’day,
Just a quick post on a seemingly trivial matter that others may find useful.
The post was prompted by the Simple-Talk...
2013-12-30
1,359 reads
TweetSQL Saturday #252 Christchurch, New Zealand
G’day,
Well, these are exciting times for the Christchurch SQL SERVER User Group.
After a period of...
2013-07-28
1,169 reads
TweetG’day,
As part of any SQL SERVER install that I do, I turn on Remote admin connections (using sp_configure) and open...
2013-04-07
5,175 reads
TweetG’day,
Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.
It’s true, you can!
Mostly...
2013-04-06
4,273 reads
TweetG’day,
Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance...
2013-03-28
1,653 reads
TweetG’day,
I had a recent conversation about data pages. There was some debate about the location of the first record on...
2012-08-06
1,192 reads
TweetG’day,
I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored...
2012-04-22
1,325 reads
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
Comments posted to this topic are about the item How a Legacy Logic Choked...
On one of my database servers, I have a maintenance plan that includes the...
Hi I upgraded to new version of VS2019 to 16.11.49. My original SSIS package...
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers