sql server 2008 - Insert to table column string value containing ' ' ' -

I need to insert a value for the table column and the string has' '' in it. For example how to do this in Al-AAAK and SQL Server 2008 R2?

All this is to do with ASP.NET.net and I'm trying to SQL myself.

@tab value ('al', 1)

Insert in 'tab (id, x, varchar (50)) #tab values ​​(1,' alka 'of'), from # tab to <* select *