SQL Coding Naming convention: Variable same name as Columns

Question

Is there a coding naming convention principal for SQL variables? Can variables be named the same as column names, I heard in different companies, this may cause confusion. However in C# below, its a generally accepted principle, resource below.

create table dbo.Product
( 
    ProductId int primary key null,
    ProductName varchar(25) not null,
    ProductDescription varchar(255) not null
)


create procedure dbo.ProductNameUpdate 
@ProductId int, @ProductName varchar(255)
as

update dbo.Product
set 
ProductName = @ProductName
where ProductId = @ProductId 

https://msdn.microsoft.com/en-us/library/ms229060(v=vs.100).aspx https://www.dotnetperls.com/constructor

public Product(int ProductId, int ProductName)
        {
            this.ProductId= ProductId;
            this.ProductName= ProductName;
        }

Answer 1

Different languages have different naming conventions. For example, in Python fields should be formatted using snake case like product_id and product_name. If you ignore such conventions your code is going to be less idiomatic, and unless you use camel case for fields everywhere it is going to be inconsistent. Both of these will hurt readability. Of course, if you happen to only ever use a single language and a single database which happen to have the same naming conventions, go for it.

Answer 2

Not only is it acceptable to have column names the same as variables, most ORM tools will do so by default, following the naming conventions of whatever language is building the application.