Viewing 15 posts - 211 through 225 (of 314 total)
Also see why isdate is not fully reliable
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/09/24/handle-isdate-with-care.aspx
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 🙂
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
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...
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...
October 3, 2008 at 4:01 am
r.hensbergen (10/3/2008)
October 3, 2008 at 3:45 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...
September 26, 2008 at 9:48 am
smunson (9/26/2008)
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
September 26, 2008 at 8:04 am
Also search for Array+sql server in google for some more methods
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...
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...
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
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?
September 26, 2008 at 7:08 am
Viewing 15 posts - 211 through 225 (of 314 total)