Viewing 15 posts - 1 through 15 (of 35 total)
You might want to create a small test database, take a full backup, then a differential, then restore both - to tell whether a failure you are seeing is due...
http://90.212.51.111 domain
August 22, 2019 at 10:07 pm
Click on the text of your userid (in my case "neil-560592") on the top right of the page to go into your profile, then scroll down and left of centre...
http://90.212.51.111 domain
December 18, 2018 at 3:59 pm
Another use for 1=1 is where you are running ad-hoc sql and want to make several changes. For example you can replace:
where firstcol = firstval
and secondcol = secondval
http://90.212.51.111 domain
December 18, 2018 at 8:19 am
Instead of using CROSS JOIN you could instead use: INNER JOIN ON 1=1
or even: select columns from table1, table2
Is there any difference in the output between these three,...
http://90.212.51.111 domain
December 18, 2018 at 6:46 am
Just tried:
select EntityID, secondcol, thirdcol
from dbo.Entity
order by 1+2
Doesn't order by thirdcol - gives a syntax error. So the number (1) is an alias for...
http://90.212.51.111 domain
December 18, 2018 at 4:56 am
Thanks for your replies.
Yes I think I tried to bite more than I was able to chew. So I will study for exam 70-461 first, and maybe 70-462, and then...
http://90.212.51.111 domain
October 6, 2015 at 3:16 am
The same thing happens on SQL 2005, so I suspect it is universal to all versions.
Any ideas as to the cause?
http://90.212.51.111 domain
November 23, 2012 at 6:23 pm
Thanks for the replies so far.
laurie: SQL does handle multiple value like that - you can see this if you comment out the ORDER BY clause. (you'll get: StartGBPEURUSD )
Chris...
http://90.212.51.111 domain
July 26, 2012 at 8:03 am
LutzM (2/23/2012)
I've been talking about replacing the view with an itvF.And yes, you can call the itvF with a parameter that is used inside the function.
I understand, and I'll have...
http://90.212.51.111 domain
February 23, 2012 at 11:28 am
LutzM (2/23/2012)
If the time interval is a variable, I would consider...
http://90.212.51.111 domain
February 23, 2012 at 10:42 am
Thanks Eugene, that's a bit tidier.
I am talking to the client about removing the DISTINCT requirement. This will allow the fast view over the 10-minute timescale, but triples the time...
http://90.212.51.111 domain
February 23, 2012 at 7:03 am
Try running a SQL Profiler on the server, with all login objects selected, to see whether SQL Server sees any attempt to log on.
Check the security event log too.
http://90.212.51.111 domain
February 10, 2012 at 5:15 am
forerolui (2/1/2010)
But I´m not geting error messages, I´m just geting a blank result page.
OK so you're getting a blank results page, so you need to work out where it is...
http://90.212.51.111 domain
February 1, 2010 at 8:03 am
forerolui (1/29/2010)
I just don’t get it. I run the script in a Database that has tables with indexes but after the script ends no results are showing.
Can anyone help...
http://90.212.51.111 domain
January 29, 2010 at 4:51 pm
Hmm well it looks like these servers may have been compromised by a virus or similar:
When I try to add a new publication to the publishing server (server A), I...
http://90.212.51.111 domain
February 25, 2009 at 5:49 am
Viewing 15 posts - 1 through 15 (of 35 total)