tim.short (8/3/2011)

---

Has the US got the 2 parter of DR Who where the sleeping angels return?

...and do you know who River Song is yet? You'll fall off your chair -...

LightVader (29/07/2011)

---

I found Doctor Who at the beginning of series 5, there was a free clip on iTunes and I got hooked. And I have to agree with link in...

Steve mentioned Doctor Who, which I love. Torchwood is now filling the gap in the current Doctor Who series. I think the current Torchwood series seemed to off...

John Mitchell-245523 (12/15/2010)

---

I got this right, but I think the question should have been qualified with something like "on an instance installed with the default settings". Otherwise the answer...

Good question and good illustration of one of the common pitfalls when using Nulls. 🙂

The card & password used my the US military sounds like a good idea. I presume this is very similar (though, maybe more sophisticated) to the chip & PIN...

Craig-315134 (11/8/2010)

---

Revenant wrote:

'Security based on biometric data is not a good idea because just like any other data, your biometric data can stolen - and if it is, you cannot...

It is pretty cool :-). It's a text representation of the Mandelbrot Set.

I ran it in SSMS, then right clicked the results...

I agree with bitbucket. It seems that even doing a clean install of the same version of SQL Server produces different results for some people. It's probably due...

In hindsight, the question may seem bad. But the default behaviours of SSMS should be...

Dave62 (3/24/2010)

---

That's interesting since a number of people have posted that with SSMS 2008 no pop-up happens. Are you using 10.0.2531?...

I use SSMS 2008 and I get the pop-up.

My default browser is Chrome. The web-page still shows in an SSMS tab, but I think it's using IE to render...

Another quick note. To make sure that the function works, even if there are no rows in the table yet, change the Select statement to:

SELECT @intLookupTextId = IsNull(max(Id),0) from...

Firstly, you don't need the parameter because this can be defined as a local variable:

CREATE FUNCTION GetTextId ()

RETURNS int AS

BEGIN

Declare @intLookupTextId int

SELECT @intLookupTextId = max(Id) from schema.tablename

SET @intLookupTextId = @intLookupTextId...