SELECT INTO with IDENTITY

This is a fun one because I’ve seen numerous people struggling with identity columns in temp or freshly generated tables. For example, let’s take a look at the Person.Person table in AdventureWorks: Now, if we just want to make a copy of this table then it’s nice and simple:

That’s it… we’re done. BUT …

SELECT INTO with IDENTITYRead More »

Row Level Security Example

This follows on from the last post in which we discussed Row Level Security.  This post provides a nice and simple example based on the example proffered in the previous blog post. We have the following query:

What we now want is to allocate managers to some of the staff and seamlessly, behind the …

Row Level Security ExampleRead More »

Scroll to Top