Posts Tagged ‘T-SQL’

3 Jun 2011

by ElMansy

1 Comment »

SQL Query, SQL Scripts, Stored Procedure

, ,

T-SQL Script To Drop all Stored Procedures

Early today i faced issue of deleting all stored procedure in Backup database . The normal action is to open SQL Mangement Studio and try to delete them the Problem in this solution That you can’t select all stored procedure and delete them on one click You must selecte the stored procedures one by one […]

More »

30 May 2011

by ElMansy

No Comments

SQL Query, SQL Scripts, SQL Server

, ,

SQL SERVER–Comma Separated Values From Table Column

This T-SQL query will get value of  Table  Column in comma separated string — declare variable to hold data and  set it to null DECLARE @Countries VARCHAR(MAX)=NULL SELECT @Countries = COALESCE(@Countries + ‘,’, ”) + ”” + s.Name + ”” FROM HumanResources.Shift s SELECT @Countries — Result : ‘Day’,’Evening’,’Night’

More »