Viewing 15 posts - 5,086 through 5,100 (of 8,416 total)
CirquedeSQLeil (3/18/2010)
This may be of use as well
SELECT SERVERPROPERTY ('edition'),serverproperty('productversion')
Also:
SELECT CONVERT(INTEGER, SERVERPROPERTY('EngineEdition'));
This returns a value of 4 for Express (all variations). The 'edition' version distinguishes between Express and...
March 19, 2010 at 5:22 am
Using sqlcmd mode in SSMS is as easy as turning it on (there's even a toolbar icon in SSMS 2005).
An example script producing a simple output can be found here:
March 19, 2010 at 5:15 am
WayneS (3/18/2010)
...the FIRST table in the FROM clause needs to be the table being updated.
That is not the case as far as I know Wayne 🙂
The order of the listed...
March 19, 2010 at 5:05 am
JC-3113 (3/16/2010)
...is there a way to copy over my Maintenance Plans from my SQL Server 2005 server to my SQL Server 2008 server?
Connect to Integration Services using SSMS. ...
March 19, 2010 at 4:58 am
tesker (3/18/2010)
My final SQL that worked was...
Another way, just for interest:
SELECT CDR1.*
FROM dbo.vCrystalDailyReport1 CDR1
WHERE CDR1.case_parties_sk =
(
...
March 19, 2010 at 4:54 am
fiaolle (3/19/2010)
SELECT fldPriceFROM dbo.tblPrice
WHERE (fldPrice BETWEEN '10 000' AND '100 000')
Fia,
If fldPrice contains prices,...
March 19, 2010 at 4:47 am
The Dixie Flatline (3/18/2010)
You might want to do some research into full-text indexing
Absolutely, yes. LIKE is not the way forward here. Full-text is easy, fast, and free! ...
March 19, 2010 at 4:31 am
bramanthe (3/19/2010)
here is the script I'm going to use for my application. I've just added some additional rows to @meters, @ti and @tu tables with different ParentId.
Are you asking me...
March 19, 2010 at 4:27 am
BrainDonor (3/19/2010)
We don't let him near customers.
Very wise! :laugh:
March 19, 2010 at 4:23 am
peleg k (3/19/2010)
what makes the diffrence between the current index, and the one that is recommand? which of the parameters will make the improvment?
You have two indexes at present that...
March 19, 2010 at 4:22 am
BrainDonor (3/19/2010)
I just saw it as an interesting puzzle to solve as I've been playing with the LIKE command recently.
It's even more fun to solve with a Regular Expression (available...
March 19, 2010 at 4:15 am
Very creative.
BrainDonor
It works for this specific example, but I haven't tested it further.
It is reasonable easy to find examples that break it. Nice though, as I say.
The sequence of...
March 19, 2010 at 4:01 am
Your FREETEXTTABLE query returns just the top 5 matches by rank. There is no guarantee that these five will match the condition in your WHERE clause.
Also, the search term...
March 19, 2010 at 3:56 am
You can also write the output directly to a file from SSMS.
Choose 'output to file' instead of 'output to grid'.
You might also like to check the option to 'quote strings...
March 19, 2010 at 3:51 am
Viewing 15 posts - 5,086 through 5,100 (of 8,416 total)