Viewing 8 posts - 1 through 8 (of 8 total)
A similar post was made a few years ago on experst exchange. Here is the link: http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20130720.html
Specifically the post by AngelIII "How do you connect to Oracle (ODBC/OLEDB)
I assume...
June 6, 2005 at 7:35 am
January 13, 2005 at 8:19 am
According to your logic, Mr. Burrows, the only "actions" applicable for the SCM utility are in using the -Action flag, 1 - 7, (Star, Restart, IsRunning, Delete Service, Install Service,...
January 10, 2005 at 7:17 am
The majority of the articles that returned when I 'googled' the error message have to do with known bugs with ADO. Some of these articles delt with SQL Server CE, other articles...
December 15, 2004 at 8:24 am
Try this:
SELECT a.date, a.fromid, a.toid, a.body
from Stocks a
where a.date IN (select max(b.date) from Stocks b
where datepart(hh, b.date) < 10
group by convert(varchar(10), b.date, 112))
December 10, 2004 at 12:58 pm
select CAST(foo1.date AS nvarchar(12)) "Date Of Activity", users2b.email AS "SENT TO USER",
foo1.body AS "CONVERSATION DETAILS"
FROM foo1, users2 as users2a, users2 as users2b
WHERE foo1.fromid = users2a.userid and foo1.toid = users2b.userid...
December 10, 2004 at 9:18 am
declare @FirstofYear as datetime
set @FirstofYear = '01/01/2005'
select Case
when DATEPART(dw, @FirstofYear) <= 4 then Datepart(wk, @FirstofYear)
else Datepart(wk, dateadd(day, -1, @FirstofYear))
end
This assumes that Sunday is the 7th day of the week. (BOL:...
December 10, 2004 at 8:40 am
You might want to look into the execution plan that is used. I've seen similar differences in performance from running the same stored procedure from various sources. It was using...
December 3, 2004 at 1:04 pm
Viewing 8 posts - 1 through 8 (of 8 total)