Viewing 15 posts - 301 through 315 (of 1,193 total)
Ok, excellent.
This all makes sense now.
That former screenshot reflects what I expected. Those problematic Romanian letters are NOT in the column in question (I probably didn't...
February 3, 2017 at 2:25 pm
February 2, 2017 at 3:39 pm
USE [NBCC_Search]
GO
/****** Object: Table [dbo].[Professional] Script...
February 2, 2017 at 2:52 pm
USE [NBCC_Search]
GO
DROP VIEW [dbo].[SpecialRomanian]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW...
February 2, 2017 at 2:39 pm
ALTER Function [dbo].[fn_ReplaceSpecialCharacters] (@TempString AS NVARCHAR(100))
RETURNS NVARCHAR(100)
AS
BEGIN
RETURN @TempString COLLATE Latin1_General_BIN
END
GO
USE [NBCC_Search]
GO
SELECT...
February 2, 2017 at 12:19 pm
February 2, 2017 at 12:11 pm
DesNorton - Thursday, February 2, 2017 12:04 PMAlso note that the input parameter to the function should be declared as NVARCHAR
Indeed, as I...
February 2, 2017 at 12:07 pm
Exactly what changes did you make?
It works fine for me.
If you're using Lowell's example, be sure that the string literal is N'ÀAlbèert ËEîin?s?têeiìn ÌInstìitúutëe'.
February 2, 2017 at 12:01 pm
Converting those values to varchar is likely what's getting you here. Those characters get turned into a CHAR(63) in VARCHAR.
Change the parameter and output types to NVARCHAR, and...
February 2, 2017 at 11:49 am
Something like this should do the trick:
WHERE Invoice_Date>=DATEADD(mm,DATEDIFF(mm,0,GETDATE())-12,0)
AND
Invoice_Date< DATEADD(mm,DATEDIFF(mm,0,GETDATE())-11,0)
Cheers!
January 9, 2017 at 3:16 pm
RD Francis (12/16/2016)
Jacob Wilkins (12/16/2016)
So those results show just under 11 GB reserved, 5ish GB data, 5ish GB index with only 192 MB unused.
Could you post the results of...
December 16, 2016 at 2:50 pm
RD Francis (12/16/2016)
- 10762864 KB reserved
- 5440040 KB data
-...
December 16, 2016 at 2:05 pm
Yes.
It's only hinted at in the latest official documentation for RESTORE (the Compatibility Support section was much more explicit about this in the 2012 version of the documentation), but you...
December 15, 2016 at 4:34 pm
That option's opening the door to multi-statement functions also made me suspicious, but ultimately I rejected it for a simpler reason.
There simply is no requirement around what the last line...
December 15, 2016 at 8:39 am
Oh, I wasn't even any kind of thought at that point.
It's less the number of earth-round-the-sun circuits completed and more my lack of any sort of graceful biological aging...
December 14, 2016 at 2:15 pm
Viewing 15 posts - 301 through 315 (of 1,193 total)