Skip to content

How to Insert into Identity column with c# code

Yes i know, there is alot of material out there on how to turn on identity insert and turn it off after, which is actually something i want to use. But there is more to my problem, thats why i started …

Hide data for all but first row on left join column

Let’s say I have this query for a view: select a.name as Author,b.name as Book from a left join b on a.id = b.a_id and it produces this output: Brandon Sanderson Mistborn Brandon Sanderson Way of …

Adding SQL Rows from two CTEs

I have two CTEs that I’ve unioned two produce the following result: date serie events 2019-05-09 hello 175 2019-05-02 hello 196 2019-05-09 goodbye 1 2019-05-02 goodbye 1 I want to add …