Concatenate strings in Database SQL

I'm proud of my hands-on practices, and I'm ashamed to watch and not practice.

Be proud to print logs, and be ashamed to make mistakes

Be proud of local variables and be ashamed of global variables

Proud of unit testing, shame on manual testing

ToCodeBe proud of reuse, and be ashamed of copying and pasting

Proud of multi-State applications, shame on Branch judgment

Alter procedure [DBO]. [A]
(
@ Tblname nvarchar (255), -- table name
@ Fldname varchar (255), -- primary key field name
@ Maxid varchar (50) Output -- maximum id value
)
As
Declare @ WWW nvarchar (255)

Set @ WWW = 'select' + @ maxid + '= max (' + @ fldname + ') from' + @ tblname
Exec (@ www)