My understanding of how public/private keys work is a little different.  The sender uses the public key to encrypt and send the data to the receiver.  The receiver uses the...

If Douglas hadn't caught it, I would have mentioned your public/private error.  In your image, (Figure 4) you have "Marian Rejewski beings work...1932" That would be "...begins work..."

As you pointed out, I don't see any advantage to a DistanceFrom "operator" over creating it as a UDF.

And how do these fit in to that one purpose?:

public int PhysicalStock

public int SystemStock

public int Difference

The one purpose is the storage of stock information.  Those are attributes of the dataType.

I take it, these two commands should work:

UPDATE Items

 SET InStock = CAST( InStock.PhysicalStock AS VARCHAR) + '|' + CAST( InStock.SystemStock*.9 AS VARCHAR)

WHERE InStock.PhysicalStock < InStock.SystemStock

UPDATE Items

 SET InStock = CAST( InStock.SystemStock*.9...

FYI, your article has a bug:

 //Returns the difference between physical and system stock. This is a read-only property

public int Difference { get { return _physicalStock -...

Speaking of middle tier, ADO.NET's SqlDataAdapter's wizard INSERT statement by default retrieves @@IDENTITY.  (At least with my version.)  That makes sense, because it's disconnected with the version of SQL Server...

Basically I wanted a procedure that would return a GUID when all the other fields in the table were matched because all the other fields should define a natural key.

If...

Wrong Answer #1 - Select max(contactid) from Test.

There are more reasons than the ones mentioned that this is the wrong answer.  This assumes that the identity field is going in...

Steve, you really should check out those plagurist sites someone else mentioned.  Plagurism is a huge problem in school.  They have web tools that allow you to submit an article written by a...

As far as free shipping at Amazon, I got that months ago after reading an article review of Ken's newest book on sqlservercentral.  At the same time, I ordered the...

"It just seems more logical and easier to follow."  You do know that some people oppose this kind of idea, just for this reason.  If it's not logical and it's...

Jeffery Williams talked about naming conventions for the primary key.  First and foremost, your company should set up a standard for naming conventions.  If that standard said the primary key...

There's a lot of quotes in this script.  Using pubs as a DB, the 900 character @sql will look like:

use [pubs]

set NOCOUNT ON

declare @sql nvarchar(500)

create...

This is my third iteration on this idea.  Produces 1 result set, documents the DB and table so this could be used on several DBs to produce a joined list:

declare...