October 10, 2018 at 5:29 pm
In the column properties, there is a property called "Default Value or Binding." What is meant by binding. I presume that means a column can be connected to something else. For example, in MS Access, a field in a form is bound or connected to a column in an underlying table.
But what is binding in terms of SQL? When is it used? How is it used? I can't find documentation on this.
October 10, 2018 at 5:42 pm
michael.leach2015 - Wednesday, October 10, 2018 5:29 PMIn the column properties, there is a property called "Default Value or Binding." What is meant by binding. I presume that means a column can be connected to something else. For example, in MS Access, a field in a form is bound or connected to a column in an underlying table.But what is binding in terms of SQL? When is it used? How is it used? I can't find documentation on this.
I checked in SSMS and cannot find this anywhere. Where are you seeing it?
--Edit: OK, tracked it down.
Have a read here. It appears to be an outdated way of giving a column a default value, which has been superseded by DEFAULT constraints. In fact, it's so outdated that I didn't know it even existed until today!
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
October 10, 2018 at 8:29 pm
Phil Parkin - Wednesday, October 10, 2018 5:42 PMmichael.leach2015 - Wednesday, October 10, 2018 5:29 PMIn the column properties, there is a property called "Default Value or Binding." What is meant by binding. I presume that means a column can be connected to something else. For example, in MS Access, a field in a form is bound or connected to a column in an underlying table.But what is binding in terms of SQL? When is it used? How is it used? I can't find documentation on this.
I checked in SSMS and cannot find this anywhere. Where are you seeing it?
--Edit: OK, tracked it down.
Have a read here. It appears to be an outdated way of giving a column a default value, which has been superseded by DEFAULT constraints. In fact, it's so outdated that I didn't know it even existed until today!
Thank you. I am seeing this in SQL Server 2017. For any table, if you right click on the Columns folder and select New Column, then select any column that appears in the table definition. On the bottom half of the screen, under Column Properties it still says Default Value or Binding. Not sure why the 2017 version would still have this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply