Viewing 15 posts - 871 through 885 (of 8,760 total)
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
Here is an example that should get you passed this hurdle.
😎
USE TEEST;
GO
SET NOCOUNT ON;
declare @table table
(
December 7, 2018 at 1:06 am
Viewing 15 posts - 871 through 885 (of 8,760 total)