sql server – Page 3 – 60 Second Dev

SQL Server Flatten and Unflatten

Assuming you have a table type named SingleColumnText which contains (obviously) a […]

Rather than try to make it happen in one big command, here’s […]

If you have a large string, possibly with line breaks, it may […]

Here are my favorite date formats in SQL Server. These work with […]

declare @people table (id int, name varchar(50));insert @people values (1, ‘John’);insert @people […]

private static SqlDataRecord CreatePersonRecord(int id, string name) { var metaData = new[] […]

var conn1 = new SqlConnection(cs); conn1.Open(); var comm1 = conn1.CreateCommand(); comm1.CommandText […]

WITH cte AS ( SELECT s.name + ‘.’ + t.name AS TableName, […]

Refresh Views: create procedure util.RefreshViewsasbegin declare @msg nvarchar(1000); set @msg = ‘————- […]