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!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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