Viewing 15 posts - 5,581 through 5,595 (of 8,731 total)
In case anyone wants a link to official documentation in BOL.
November 4, 2014 at 8:24 am
Express will have limited functionality.
Evaluation and Developer will offer the same features as Enterprise edition. The problem with Evaluation would be the time constraint.
How much can you learn from Developer...
November 3, 2014 at 4:10 pm
The books section in this site is a good source.
November 3, 2014 at 3:03 pm
This solution might help you on what you need.
Another quick option would be to use one ForEach Loop for each extension (more work, but easier).
November 3, 2014 at 12:04 pm
You're missing a validation to get only numeric values. A value like 'ABCDE67890' would still pass your test. I'm leaving 2 options that validate for digit-only values.
Information of this function...
November 3, 2014 at 9:53 am
This is a different option using Pattern Splitting (using Lynn's sample data).
select
*
from dbo.TestData td
cross apply (select stuff((select ',' + ca.Item
...
November 3, 2014 at 7:45 am
spaghettidba (11/3/2014)
Now he's trying to set up a virtual lab environment and getting sysprep errors...
You have to give him credit, it's not easy to work with Windows Evolution Edition. :hehe:
November 3, 2014 at 7:14 am
Lynn Pettis (10/31/2014)
Getting a error configuring mirroring. I am a programmer with no administration or network knowledge.Sorry, but this is a little scary at first.
I understand that (s)he is...
October 31, 2014 at 2:04 pm
barry.mcanally (10/31/2014)
This is my Michael Myers outfit complete with movie replica mask. Gave a few folks a fright already and I'm only just walking my husky!
For some reason, I was...
October 31, 2014 at 10:42 am
JJR333 (10/31/2014)
... shrink the database...
Be careful, you shouldn't be shrinking the database.
I can't remember if express version comes with SQL Server Agent. If it does, you should use it to...
October 31, 2014 at 9:52 am
I could get a fancy hawaiian shirt, remove some hair and dress up as Steve Jones :hehe:
October 31, 2014 at 9:38 am
ikjeft01 (10/30/2014)
not a fan of all those magic numbers.... 960? 465? 450? 585?
That's why I included a bunch of comments to know what they're referring to.
ikjeft01 (10/30/2014)
October 30, 2014 at 6:15 pm
From the examples that you posted, I could only test the last one and the problem is with your precision which comes short. Changing it to 11 makes it work....
October 30, 2014 at 2:38 pm
You're describing something that's known as Quirky Update. To get it right, you need to follow some rules or the results can't be guaranteed. Check the following article describing it.
October 30, 2014 at 12:11 pm
You're right, the REPLACE will add a small amount of work to the server which might be unnoticeable in most cases. However, you shouldn't want to add unnecessary work to...
October 30, 2014 at 11:42 am
Viewing 15 posts - 5,581 through 5,595 (of 8,731 total)