You have to create a Default object, then bind it to an appropriate Column object using the Default object's BindToColumn method. I quote from BOL:

To create a SQL Server...

Steve's solution will (of course) work but I would question whether your specified output set is actually what you want. As stated, you are losing information about which figure corresponds...

Not sure why people are offering examples with sysobjects etc. What you want here is just a correlated subquery:

Assuming View A has columns PersonName, PersonID

View B has columns PersonID, DiaryEntry,...

If you just want VB to display a certain number of decimal places, you should use something like

Format(variable, "0.0000")

Assembler is faster than VB. Which would you rather use to code a Windows app?

Personally, I would prefer the NULL conversion to be done in a data access layer of some kind - after all, who is to say there will never come a...

You need to decide what your business rules dictate should happen. For instance, with Mr E G Ford, what do you want to end up with in firstname? 'E', and throw...

noeld, your solution has produced the correct answer this time but is assuming properties of the data that we don't know for sure - with the sample data shown it...

'Cheating' way: Define a unique index that includes all columns. Insert your records one by one. When you get a 'unique index constraint violated' error, ignore it and go on...

I would be interested to see the relative performance of the article's method versus the following approach, which is equally powerful but (I think) can be optimised much more easily...

That is exactly the problem. The 'ON' clause has no knowledge of the aliasing done on other tables.

I did have a lengthy rewrite in progress here, based on the general...

Conceptually I am not sure there is any way to do this. After all, the point of an update trigger is to make a certain set of operations appear to...

I know you have an answer; I would just like to say that on purely aesthetic grounds I would prefer

select A.pId from tblPrp A

inner join FacilityText F1 on A.pId =...

For simple cases the db engine might well build the same execution plan for two syntactically different T-SQL statements that arae semantically equivalent. But in general it takes experimentation with...

Oh sure, if this is a development 'play' server go right ahead and put everything on it - I'm sure I'm not the only developer out there whose machine is...