Passing column name as argument to procedure in SQL

By the following way you can pass the column name as a parameter/argument to the procedure in SQL.

create proc PROCEDURENAME

as

begin

declare @CoumnName varchar(30),@Query varchar(100);

set @ColumnName=’ColumnName’;

set @Query=’select FoodName,ImageUrl,Price from tblFood where ‘+@ColumnName+’=condition’

exec sp_executesql @Query

end

 

Read only Database

To make a database as read only,

ALTER DATABASE [Database name] SET READ_ONLY

To remove read only property of database,

ALTER DATABASE [Database name] SET READ_WRITE