Viewing 15 posts - 5,086 through 5,100 (of 8,415 total)
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
Tara,
In case that logic is not obvious to you, the idea is that although the end date of the month is variable, it is always the day before the first...
March 19, 2010 at 4:14 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
First thing I notice is that SQL Server is suggesting you create exactly the same index I mentioned earlier:
CREATE NONCLUSTERED INDEX nc1
ON dbo.Con_RecipientToMessages (Id)
INCLUDE...
March 19, 2010 at 3:46 am
Viewing 15 posts - 5,086 through 5,100 (of 8,415 total)