Viewing 15 posts - 16 through 30 (of 944 total)
Hi,
You have two choices;
SELECT OBJECT_SCHEMA_NAME(T.[object_id],DB_ID()) AS [Schema],
T.name AS table_name, AC.name AS column_name,
TY.name AS system_data_type, AC.max_length
FROM sys.tables AS T...
March 21, 2019 at 8:12 am
Sorry should have said you can follow the links via the schedule for last week
but
SQL Bits - Main
March 7, 2019 at 10:14 am
nice day in the office today.
Change pushed through after being delayed for weeks. And we are getting permission issues. For permissions that appear to have been set.
Had a...
March 7, 2019 at 9:43 am
March 7, 2019 at 7:04 am
JW,
Good to hear you are winning.
I ended up with no time to take a look last night.
Rodders...
March 7, 2019 at 4:39 am
JW,
As others have said you just have a mess of bad data there.
Using ISDATE can get round the fact that someone has put in a Feb 29...
March 6, 2019 at 8:43 am
You could also look at this as a replacement from Aaron Bertrand;
But to answer your question, the ? is a...
March 6, 2019 at 6:15 am
Hi as you have posted in the 2008 forum, I'm going to take it that is the version you are using.
From 2012 upwards there is a TRY_CONVERT built in...
March 6, 2019 at 4:22 am
No kidding. It took me close to an hour to fall asleep after...
March 4, 2019 at 2:54 am
In other news...
I see Hugo made it to the end of his 24 hr Pool marathon. Congrats Hugo.
In the UK today we have the second day...
February 27, 2019 at 3:12 am
February 26, 2019 at 2:24 am
I received a call this morning (2019-02-15) at approximately...
February 15, 2019 at 5:20 am
I would have thought QA would have done one, but apparently not.
Hopefully Data Movements will come back with something positive.
Also worth checking Plurasight - I know it...
February 14, 2019 at 5:28 am
Hi,
I'd take a look at this;
Unfortunately, having just checked, there aren't any scheduled this year yet, I'd drop...
February 14, 2019 at 4:10 am
Viewing 15 posts - 16 through 30 (of 944 total)