Excel

hours:minutes:seconds yyyy-mm-dd (hh:mm) float (days)

24:00:00 ...

pwalter83 (12/8/2015)

---

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Upon assigning the datetime datatype to SQL, the issue still is not resolved as now if the value in EXCEL is 885:39:35 it is displayed as '1900-02-05...

pwalter83 (12/8/2015)

Upon assigning the datetime datatype to SQL, the issue still is not resolved as now if the value in EXCEL is 885:39:35 it is displayed as '1900-02-05 21:39:35' in...

But you are still missing the point.

The datatype in Excel does NOT vary. (ONLY the format is different).

What is important is the datatype of the field in SQL-server. (Again not...

Excel

format display

:mm:ss ...

What...

Examples of a computed column in a table.

Source for the computed column in this case is varchar or datetime.

In excel time and/or date is just presented as the number of...

Using the Copy...

Thanks, I will not put an efford in this then. I'll solve this when I encounter them, without generating code for this. (Timestamps are rare...

JustMarie (12/1/2015)

---

Why not use _sp as a suffix? It still shows that the code is a stored procedure and lets you group things by name much more easily.

I've advocated...

DECLARE @olddate datetime = '20141124 19:50'

SELECT

convert(float,GETDATE()-@olddate) ...

Jack Corbett (11/10/2015)

---

Doesn't this defeat the purpose of having a trigger to track changes? If I were an auditor I'd certainly question the validity of the change...

Thank you Jack and Gail,

Jack Corbett (11/9/2015)

---

I'm not sure why you need to rename the existing table in order to create the history table. I'd just leave...

I am preparing a script to test the above.

Problem 1:

If a default is defined in a table, and insert is done on the View, where the trigger uses the 'INSERTED'...

The refereced site gives a compact search 'tool'.

I got some errors and have made some changes to the code.

Now: Searches are only done on...