Cliff Jones (5/31/2012)

---

+1 but like Tom I was wondering...

L' Eomot Inversé (5/30/2012)

---

Until I saw the counts of answers so far I thought that maybe this repetition with tiny variations (this is the third version of this question in...

Like all SQL questions the answer is "It depends". I suggest you do a Google search on "sql server upgrade advisor". Download the available software, run it .......

Good question, help me re-affirm something I thought I knew and as it turned out I did know it.....

Without table definition(s), some sample data and the desired results when using the sample data, providing you with a tested answer is next to impossible.

Please, please post your table definition(s),...

Here is some info with examples (sample code) of what I think you want to accomplish.

http://beyondrelational.com/modules/2/blogs/43/posts/10196/who-created-a-table-ddl-triggers-in-sql-server-2008.aspx

Thanks for a GREAT question .. glad I answered it after my 2nd cup of coffee .....

Now I did a little testing with the BIGINT value to deteremine the maximum BIGINT value that could be converted to DATETIME as follows:

DECLARE @b-2 BIGINT

SET @b-2 = 2958457 ...

Had to reduce the value of you BIGINT (other wise - overflow error)

but here goes

DECLARE @B BIGINT

SET @B = 922337

SELECT convert(VARCHAR(20),CAST(@B AS DATETIME),101)

Result: 04/10/4425

Here is a few to get you started.

DECLARE @d1 VARCHAR(20)

DECLARE @d2 NVARCHAR(20)

DECLARE @d3 VARCHAR(20)

DECLARE @d4 NVARCHAR(20)

DECLARE @d5 VARCHAR(20)

SET @d1 = '2004-06-23'

SET @d2 = '2004-06-23'

SET @d3 = '06/14/2011'

SET @d4 = '06/14/2011'

SET...

Yup time to party .. just got email notification that my seventy-first (71st) accepted QOD is scheduled for mid June (of this year).

SO PARTY TIME ! ! !

Hugo Kornelis (5/18/2012)

---

bitbucket-25253 (5/17/2012)

---

Well my answer was declared to be incorrect, so went to read the explanation, following the link given ..... nada / nothing / not a word to...

Well my answer was declared to be incorrect, so went to read the explanation, following the link given ..... nada / nothing / not a word to support what is...

Use the Depreciated Feature Object in sQL 2008R2

Here is a link to describe its use and limitations

http://technet.microsoft.com/en-us/library/bb510662(v=sql.105).aspx

bitbucket-25253 (5/16/2012)

---

You might use this to find the words to replace.

CREATE PROCEDURE [dbo].[FindWordsInaSP_5K]

@Watchword varchar(50)

AS

SELECT distinct

'type' = case type

when 'FN' then 'Scalar function'...