Viewing 15 posts - 2,236 through 2,250 (of 8,731 total)
Sean Lange (8/25/2016)
Grant Fritchey (8/25/2016)
Sean Lange (8/25/2016)
Grant Fritchey (8/25/2016)
Lynn Pettis (8/25/2016)
Got to the following from a LinkedIn email. Not sure about a few of the answers.https://intellipaat.com/interview-question/sql-interview-questions/
I posted a comment....
August 25, 2016 at 2:18 pm
Maybe something like this:
SELECT *, (LEN(str) - LEN(REPLACE(str, 'fox', '')) ) / 3
FROM #t;
But I'm not sure if it causes a problem with the result. What would you expect if...
August 25, 2016 at 1:46 pm
The Dixie Flatline (8/25/2016)
But isn't the problem with just replacing spaces is that it doesn't deal with other special characters?
It depends on what you're doing.
August 25, 2016 at 1:27 pm
BLOB_EATER (8/25/2016)
GilaMonster (8/25/2016)
August 25, 2016 at 1:22 pm
Are you serious? I think they're perfect. They're great to identify cheaters from people that actually know what they're talking about.
I couldn't get past the 3rd question, it's full of...
August 25, 2016 at 12:05 pm
I'm sorry, I'm lost. What's the problem that you have?
August 25, 2016 at 12:01 pm
Sean Lange (8/25/2016)
Steve Jones - SSC Editor (8/25/2016)
August 25, 2016 at 11:01 am
Other than using basic operations, you just need to use DATEDIFF and a CASE expression, maybe ISNULL to prevent NULL values. What are you having problems with?
August 25, 2016 at 10:56 am
Alvin Ramard (8/25/2016)
Would this work?
LEFT(REPLACE(CAST(NEWID () AS NVARCHAR(MAX)), '-', '') , 15)
I'm not sure if that will return unique strings. Although, the chance for duplicates is low.
August 25, 2016 at 10:34 am
waxingsatirical (8/25/2016)
I don't know what unnecessary work later is incurred by using floats, but I know of...
August 25, 2016 at 9:41 am
As each database is a container on itself, you need to loop into every database. One easy way to do it is with the sp_foreachdb shared in here: https://www.mssqltips.com/sqlservertip/2201/making-a-more-reliable-and-flexible-spmsforeachdb/
There's one...
August 25, 2016 at 8:54 am
djj (8/25/2016)
Ed Wagner (8/25/2016)
Alan.B (8/25/2016)
BWFC (8/25/2016)
Prefectday
Night
Dark
Knight
August 25, 2016 at 7:44 am
Something like this applied to your code:
DECLARE @sql_files_path varchar(100) = '\\SomeServer\Somepath\'
DECLARE @BulKInsert nvarchar(300)
SET @BulkInsert = '
BULK INSERT #fileContent FROM ''' + @sql_files_path + 'receipt_header.sql''
WITH (FIELDTERMINATOR ='' | '',ROWTERMINATOR =''...
August 25, 2016 at 7:18 am
waxingsatirical (8/25/2016)
Luis Cazares (6/3/2016)
using float is just lazy programming.and by 'lazy' you mean??? Not doing unnecessary work?
If by unnecessary work you mean analysis and planning, yes it's lazy programming. Some...
August 25, 2016 at 7:00 am
An easy way to understand it, is that JOINs add columns while UNION/EXCEPT/INTERSECT only handle rows.
Of course, if you see a Venn diagram, they'll be the same. The difference come...
August 25, 2016 at 6:48 am
Viewing 15 posts - 2,236 through 2,250 (of 8,731 total)