Viewing 15 posts - 2,476 through 2,490 (of 8,753 total)
I would go directly to Sql Server 2016, it is IMHO by far the best ever and so far I haven't heard of any serious bugs.
😎
January 15, 2017 at 11:10 pm
January 15, 2017 at 5:50 am
January 15, 2017 at 3:27 am
Question, are you trying to find all the entries containing an underscore character?
😎
Note that replacing the underscore character in brackets will only work with the LIKE operator,...
January 15, 2017 at 3:08 am
This update operation is elementary using the XML modify operation, here is a quick example
😎
USE TEEST;
GO
SET NOCOUNT ON;
-- Sample XML
DECLARE...
January 13, 2017 at 4:08 am
Looks like there is a bug in the subscription/notification part, after the upgrade I'm getting lots of notifications from threads I haven't subscribed to.
😎
January 12, 2017 at 5:47 am
January 12, 2017 at 5:20 am
This should get you started
😎
SELECT
SPART.object_id
,OBJECT_SCHEMA_NAME(SPART.object_id) AS SCHEMANAME
,OBJECT_NAME(SPART.object_id) AS TABLENAME
,SPART.partition_number AS PARTITION_NO
,SDSPC.name ...
January 12, 2017 at 3:30 am
You will have to Configure Windows Service Accounts and Permissions
😎
January 12, 2017 at 12:12 am
Looks like a problem with the data where the group by clauses in the sub-queries of the second query suppress the problem.
😎
Try running these three queries with and without the...
January 11, 2017 at 10:25 pm
Suggest you read up on the CONVERT function!
😎
Example
DECLARE @DSTR VARCHAR(50) = '20151025'; -- ISO FORMAT
SELECT CONVERT(VARCHAR(30),CONVERT(DATE,@DSTR,112),101) -- US OUTPUT
January 11, 2017 at 9:45 am
Rechana Rajan (1/9/2017)
we have json getting stored in one of the tables and how can we search inside the json.
As Tom pointed out, there is no JSON parsing support on...
January 11, 2017 at 5:22 am
GilaMonster (1/11/2017)
I really would like to attend Bits this year (hint, hint)
Got it 😉
😎
January 11, 2017 at 3:47 am
ben.brugman (1/10/2017)
Hello All,I want to write a varchar(max) string to a file.
The file should be UTF-8 (and not in a multi byte character format).
Thanks for your time and attention,
Ben
You will...
January 10, 2017 at 7:07 am
Quick thought, you can probably simplify the calculation, something like this maybe?
😎
INSERT INTO @Sample
SELECT '2017-01-07 07:28:01.917',1 UNION ALL
SELECT '2017-01-07 07:28:05.210',1 UNION ALL
SELECT '2017-01-07 14:06:21.840',1 UNION ALL
SELECT '2017-01-07 14:06:24.227',1 UNION ALL
SELECT...
January 9, 2017 at 10:04 pm
Viewing 15 posts - 2,476 through 2,490 (of 8,753 total)