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...

Hello,

In the past I created a number of search routines.

This was quite a jumble in different styles.

Now I have bundled the search routines in a stored procedure and the master...

Sorry at the moment I do not see a feasible way to do this within a limited amount of...

Just did a checkup on the tables which inspired this thread.

The actual number of columns in the 'covering index' was 10. And yes they are all used in the actual...

GilaMonster (11/1/2015)

Columns included are in the leaf level only, not the key, so the index is smaller than if they were in the key.

They also don't count towards the 900...

Jeff Moden (10/31/2015)

---

To be honest, I'd say the quote about "half full" is incorrect, at least about the implementation for Microsoft's interpretation of the Rushmore Engine (the basis of SQL...

Alexander Suprun (10/30/2015)There is only one way to force optimizer to do want we want, but we have to use table twice in our query, which becomes cumbersome and not...