It's a parse time error, not a run time error.

the sqlist (8/2/2013)

---

How about this way:

SELECT [Month] = datename(mm,min(SomeDateTime)),

Amount = SUM(SomeAmount)

FROM #MyHead

WHERE SomeDateTime >= '2010'...

You can pass the random value to the function via an input parameter:

CREATE FUNCTION dbo.GetRandomNumber (@Lower int, @Upper int, @MyRand float)

RETURNS int

WITH SCHEMABINDING

AS

BEGIN

DECLARE @random int

SELECT @random = ROUND(((@Upper -...

Steven Willis (7/22/2013)

---

--this date MAY or MAY NOT be valid depending on the DATEFORMAT setting

SELECT ISDATE('29-12-2013')

--this is never valid (out-of-range)

SELECT ISDATE('32-12-2013')

--this should always be valid in all formats

SELECT...

The CASE expression will verify that the data string is in YYYY-MM-DD format, and is a valid date. It will return a 1 if the date is valid and...

This code shows how to setup an optional DATE parameter that will use the input passed or default to the current date if it isn't.

go

create procedure sp_MyProcedure

@DateParameterdate = null

as

set...

For 2005, 2008, or 2008 R2, you should check column packagetype=6 to make sure you are only updating maintenance plan packages.

The script below works with 2005, 2008, or 2008 R2...

This will usually work to drop a database that is being used.

use master;

alter database [MyDatabase] set offline with rollback immediate;

alter database [MyDatabase] set online with rollback immediate;

drop database [MyDatabase];

select top 1

a.[Date]

from

(

select top 1 b.[Date] from table1 b order by b.[Date] desc

union

select top 1 c.[Date] from table2 c order by c.[Date] desc

) a

order by

a.[Date] desc

It is not easy to find, but Google is your...

SQL Server Developer Edition is only $50.00, so that SQL Server license cost is fairly small.

jhager (6/20/2013)

---

Hi,

A developer created several tables with PKs but no FKs. I used the Database Diagram feature to "map out" where the FKs should be, but when I saved the...

Trade associations and industry standards tend to function most effectively as tools to limit competition and as barriers to entry, rather than as tools to create and enforce professional standards.

Medical...

The restored DB will be exactly the same size as the database was when you created the backup.

"3MB for the procedure cache"???

Did you really mean 3 GB for the procedure cache?

How many connections are open to the server?