You're in the wrong forum, I'm afraid: this one is for SQL Server 🙂

Here's one way. Not sure if there's anything more elegant.

declare @d date = '20081221'

select @d

,replace(convert(char(11), @d, 13), ' ', '/')

And presumably you...

Sridhar-137443 (2/19/2015)

---

Hi, I am trying to find out an efficient way to determine if employee meets a criteria. We have employee table that has following information

Company, Empno, Level1, Level2, Level3,...

If the database file has been corrupted and you have no backups, and no one has scripted out the procs you are talking about (check with the developers), I am...

A side point. Char(50) is probably not the optimal datatype to use here, as your names have varying lengths. I would recommend that you switch to Varchar(50) to save space.

NO NEED TO SHOUT.

Once again, if your database is under source control, you can retrieve the definitions there...

From source control?

In my experience, developers do not have the same big-picture view of server health and performance that DBAs have (and need to have to do their work). Seasoned DBAs know...

Bizarre. Haven't used Ignore_dup_key for a while, but this looks wrong to me.

How hard did you try?

How about this.

Jason-299789 (2/18/2015)

---

Ok, I would ask why the change from SSIS to SQL.

IN SQL check out the HASHBYTES function.

eg

SELECT

COL1,COL2, HASHBYTES('MD5',COL1+'|'+COL2+'|')

FROM aTable

One other thing there's no guarantee that you will...

Nice article Andy. I have never seen it all set out so clearly before, well done.

I am not familiar with the verb 'chive'. What do you mean?

This is not a valid SQL datatype.

What would you expect?