Viewing 15 posts - 31 through 45 (of 454 total)
The underlying problem, of course, is that CHAR() is both a data type and a function.
Add to that the fact that AS can be used in declaring the type of...
November 10, 2017 at 6:10 am
October 20, 2017 at 12:44 pm
Good question, but you're asking for trouble with the phrase "the right SQL Server platform"!
August 29, 2017 at 8:18 am
Sean Redmond - Monday, August 21, 2017 12:35 AMWe have a universal ID — our DNA....
There are a few problems with using...
August 21, 2017 at 10:29 am
August 9, 2017 at 1:21 pm
I'm uncertain if having the ANSI_PADDING OFF will net you any savings on space for char columns, though. I'll leave that to someone who's better at generating large sample...
July 24, 2017 at 6:06 am
paul s-306273 - Thursday, June 29, 2017 3:38 AMTwo thirds right, but assumed the data wouldn't get switched.
This question came about because...
June 29, 2017 at 6:20 am
June 21, 2017 at 6:55 am
In the last case, certainly whoever sets up a system is responsible for using the correct credentials. While it's easy to say that a developer or tester shouldn't know...
June 19, 2017 at 6:06 am
I always get the order of these two confused, because it's one of the places where SQL diverges from English.
In English, DISTINCT TOP 5 would mean "get the distinct...
June 19, 2017 at 5:55 am
Or you could use PIVOT:
-- Create the temp table #TempAgeAnalysisReport
CREATE TABLE #TempAgeAnalysisReport ([Account No] varchar(1),
[Current] money default 0, -- Period...
June 13, 2017 at 4:21 pm
My strategy is to turn a repetitive task into a programming one.
Instead of manually running all of those tests, write a framework which runs those tests for...
May 11, 2017 at 5:57 am
Viewing 15 posts - 31 through 45 (of 454 total)