Viewing 15 posts - 211 through 225 (of 315 total)
Also see why isdate is not fully reliable
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/09/24/handle-isdate-with-care.aspx
Failing to plan is Planning to fail
October 4, 2008 at 1:26 am
amfps (10/3/2008)
Hello,Madhivanan, your example help me to solve my problem.
Thank you,
Augusto
You are welcome 🙂
Failing to plan is Planning to fail
October 3, 2008 at 7:13 am
indraprakash (10/3/2008)
Hi All,Is there any way to identy that procedure last modified date in SQL Server 2000?
Thanks
No until you document it
Failing to plan is Planning to fail
October 3, 2008 at 7:07 am
Try
selectcase
when col between 0 and 5 then '[0-5]'
when col between 6 and 10 then '[6-10]'
when col between 11 and 100 then '[11-100]'
end as Limits,
count(*) as Total
from
your_table
group by
case
when col...
Failing to plan is Planning to fail
October 3, 2008 at 5:17 am
garethmann101 (9/25/2008)
My SQL statements crash when I want to select where a string value equals something that contains an apostrophe ('). I.e the name "O'Conner".
What is the simplest way...
Failing to plan is Planning to fail
October 3, 2008 at 4:01 am
r.hensbergen (10/3/2008)
Failing to plan is Planning to fail
October 3, 2008 at 3:45 am
Failing to plan is Planning to fail
September 26, 2008 at 9:49 am
Steve Jones - Editor (9/24/2008)
It's likely a transient error. The nHibernate stuff flips out at times. We did have issues this morning, but things seem to be running better now.
Thanks...
Failing to plan is Planning to fail
September 26, 2008 at 9:48 am
smunson (9/26/2008)
Failing to plan is Planning to fail
September 26, 2008 at 8:06 am
Gayathri.Varadarajan (9/25/2008)
select convert(datetime,convert(varchar(12),getdate(),101),101)
This will remove all time portions
Failing to plan is Planning to fail
September 26, 2008 at 8:04 am
Also search for Array+sql server in google for some more methods
Failing to plan is Planning to fail
September 26, 2008 at 8:04 am
Suresh B. (9/23/2008)
Becuase the subject saysscript needed - to lists all the tables without a clustered index - sql2k5/2k
Well. I did nto see the title...
Failing to plan is Planning to fail
September 26, 2008 at 8:03 am
jacob sebastian (9/24/2008)
Try this:
-- '2008-09-24 14:19:56.293' I WANT '2008-09-24 14:00:00.000'
DECLARE @d DATETIME
SELECT @d = '2008-09-24 14:19:56.293'
SELECT DATEADD(hour, DATEPART(hour, @d), DATEADD(d, 0, DATEDIFF(d, 0, @d)))
/*
output:
-----------------------
2008-09-24 14:00:00.000
*/
This can be simplied as...
Failing to plan is Planning to fail
September 26, 2008 at 8:01 am
See how single quote works in sql server
http://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx
Failing to plan is Planning to fail
September 26, 2008 at 7:19 am
skottikalapoodi (9/26/2008)
MY DATA TYPE IS DECIMAL ONLY.ACTUALLY WHAT I WANT IS, I DON'T WANT IT TO BE ROUNDED
Can you post the table structure?
Failing to plan is Planning to fail
September 26, 2008 at 7:08 am
Viewing 15 posts - 211 through 225 (of 315 total)