Sometimes, initials can be a problem. My parents didn't consider mine. This lead to me, as a second grader, knocking the top two front (permanent) teeth from a bigger, third-grader's...

Sean Lange (9/5/2013)

---

IIF is not valid syntax for SQL.

--begin edit--

IIF was added to SQL 2012 :angry:

--end edit--

The first statement would be something like this:

SELECT case Field1 when NULL then 'NULL'...

I'm not clearing my cookies, either, but this is a work machine, so there is likely to be a policy in place. Haven't been able to check on that, yet.

Well, not knowingly. I'll check to see if a new policy has been implemented here. Thanks for the response.

Off the top of my head...

In the ORDER BY clause, immediately before the 'MyDate' column, add this CASE statement:

CASE WHEN MyDate IS NOT NULL THEN 1 ELSE 2 END

That will...

Since you are running a SQL Server Agent job, you can use SQL Server Agent tokens.

The one for date the Job started running is: $(ESCAPE_NONE(STRTDT))

Here's a link to the...

You keep mentioning the 'initial size'. That only matters at the beginning. How big was the log when the failed increase was attempted? 10 percent of *that* amount is what...

Thank you, Scott! With the addition of a WHERE clause on the first SELECT, I end up with an empty table without a IDENTITY property, which is EXACTLY what I...

Thanks Jeff. I was hoping for something which could use "SELECT *", so knowledge about the extant columns wouldn't be necessary. Neat technique, though, if the column names and the...

I want a clone of the table (with 3 addition, preceeding, columns), with the original column sequence, if possible. I'd rather not have to resort to dynamic SQL to define...

You can have as many 'duplicate foreign keys' as there are rows in the table. It is just a value, after all. It appears that you were actually talking about...

Actually, the date rounds up from noon, onwards, not just after noon.

@@ROWCOUNT refers to the number of rows affected by the immediately-previous SQL statement. If you have any activity (like a SET statement, or an IF clause) between the statement you...

As far as the contents of a function, or stored procedure, it would seem that the LIKE comparison operator is what you need.

CASE

WHEN SSSNO LIKE '[0-9][0-9][0-9][-][0-9][0-9][-][0-9][0-9][0-9][0-9]'

THEN 'valid'

ELSE 'invalid'

END

When the Attachment column was created, the ANSI_PADDING setting was most likely 'OFF'. This causes trailing blanks to be automatically trimmed from varchar and nvarchar columns. The same thing happens...