All Rows value into comma seprated values into one single variable

declare @SQLCol nvarchar(max), @TableName nvarchar(max)
select @SQLCol = COALESCE(@SQLCol+’,’,”)+ sc.COLUMN_NAME FROM information_schema.columns sc
where sc.COLUMN_NAME like ‘%ColumnName%’ and sc.TABLE_NAME = @TableName
order by sc.COLUMN_NAME asc

Print @SQLCol

Note:
COALESCE() : This function returns single value of collect all the values with user defined format. Here for each records i used ‘,’ but you can use anything you want for seperation. This is very good function provided by SQL server.

Get All tables infromation from the database

SELECT * from sysobjects where xtype =’U’

Enter register key into the system

  Microsoft.Win32.RegistryKey ckey =
Microsoft.Win32.Registry.LocalMachine.OpenSubKey(@”SYSTEM\CurrentControlSet\Services\service1″, true);
            if(ckey != null)
            {
                if(ckey.GetValue(“Type”) != null)
                {
                    ckey.SetValue(“Type”, ((int)ckey.GetValue(“Type”) | 256));
                }
            }

Krugle developer search engine

You can search source code/project in any language through this search engine. 

Please click on below link.

Developer search engine

Free SMS in all over india

You can sent daily two sms in all over india through this below link.

Free SMS in all over india