Viewing 15 posts - 871 through 885 (of 8,761 total)
December 12, 2018 at 1:43 am
Recommend that you use CONVERT with the style parameter matching the content when converting character string to XML, CAST is equal to the default (0)
😎
December 12, 2018 at 1:39 am
Jeff Moden - Tuesday, December 11, 2018 8:32 AMORDER BY (SELECT NULL)
Find ORDER BY @@VERSION simpler and somewhat more efficient 😉
😎
December 11, 2018 at 10:24 am
December 11, 2018 at 3:02 am
If you look at Aaron Bertrand's article, he comes to the conclusion that...
December 10, 2018 at 9:09 am
December 10, 2018 at 9:05 am
If you look at Aaron Bertrand's article, he comes to the conclusion that...
December 10, 2018 at 8:44 am
This code runs but displays one result and stops. The table has about 40 rows. ...
December 10, 2018 at 12:08 am
Thanks for the write-up Steve.
😎
One thing, there are performance references but no mention of the fastest non CLR string splitting function (on SQL Server 2012...
December 9, 2018 at 11:36 pm
December 8, 2018 at 7:18 am
December 8, 2018 at 4:12 am
December 8, 2018 at 3:29 am
December 7, 2018 at 6:37 am
Here is a quick example, which does not use a CASE statement.
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @DEFECT TABLE
(
December 7, 2018 at 2:27 am
Viewing 15 posts - 871 through 885 (of 8,761 total)