Solve single quotation marks in SQL Server Stored Procedures

I. Purpose: To insert the ''number in the SQL statement, for example, select count (*) from user where name = 'Tom'
A) Use escape characters: Select char (39) or select char (39) +''
The query result is :'
Example: Select char (39) + '000000' + char (39)
The query result is: '20140901'
B) use special characters to replace: ''' <===>''
For example:

Alter procedure [DBO]. [test]
@ I _name nvarchar (10)
As
Declare @ sql1 nvarchar (100 );
Begin
Set @ sql1 = 'select * from users where name ='
Set @ sql1 = @ sql1 + ''' + @ I _name + ''''
Exec (@ sql1)
End
The SQL statement output after execution is:
'Select * from users where name = 'Tom'