Viewing 15 posts - 1 through 15 (of 382 total)
Is the definition of schemabinding not backwards? i.e. Surely it prevents changes to the underlying objects and not the function?
June 19, 2020 at 5:38 am
A slight variation (although I've not got SQL installed to test it.)
CONSTRAINT ck_xxx CHECK ('' not in (c1,c2,c3,c4,c5))
Would you kindly check and let me know if that works?
March 23, 2016 at 10:48 am
No....I don't see any performance impacts...it's just a valid piece of data for the column's datatype.
That's my view anyway.
March 2, 2016 at 4:41 am
Actually, I was going to suggest using rownumber until I re-read and realised that's what you started with. 😀
So my suggestion is that you return to rownumber and look...
February 25, 2016 at 8:03 am
but the output (DESIRED one) that you see on the top of the first page of the attachment is correct,...
February 24, 2016 at 1:28 am
Very interesting article...having done a little reading recently on Kaggle and analysing massive datasets with Python and R, I wonder if the recent R extensions to SQL Server would not...
February 23, 2016 at 8:50 am
curious....the output you've shown doesn't look like fixed width (rather comma delimited)....are you sure you're looking at the right output file?
February 23, 2016 at 8:06 am
what about simply....
set [add]= 1
where uname IN ('jain', 'baiju')
February 22, 2016 at 6:33 am
one year later, I know....but.....looks like you've got this all wrong....your xsl sheet doesn't change....your data does.
check out http://www.sqlservercentral.com/articles/XSL/2831/
February 18, 2016 at 7:45 am
I suggest you construct some dynamic sql as per below, using the intersect operator instead of the AND.
select id from entitiesFullText eft where eft.word like 'med%'
select id from entitiesFullText eft...
February 18, 2016 at 7:28 am
...or use the SMO from within SSIS as this is where he's doing the rest of his scripting.
February 12, 2016 at 9:14 am
Check out this article [/url]which generates audit tables based on your tables using xsl. If you're already using ssis for the other scripts, you could leverage this to do...
February 12, 2016 at 8:41 am
I would suggest you don't load the data into a float datatype unless you're sure that's what you want. Best to use a high precision numeric.
In the import wizard,...
February 12, 2016 at 4:44 am
I haven't tested this, but something like this should do the trick.
SELECT wh_id as Wh, dateadd(m,datediff(m,0,create_dtim),0),count(*) as Plan FROM Backtest where wh_id in (1,9) group by wh_id, datediff(m,0,create_dtim)
February 12, 2016 at 4:38 am
No great revelations I'm afraid. I can just give you what I think is the Oracle approach.
If I understand you correctly, you're in a query window, rather than a...
January 27, 2016 at 8:24 am