SQL Tips #20 - Showing All Table Data for a Specified User

Sometimes you just want to see everything stored against a specific user.

Replace the userguid below with the one you want.

The Query

DECLARE @userguid nvarchar(128)
SET @userguid = 'AED66C1F-3D63-4EE1-AB23-D5D087652DA3'
SELECT * FROM aspnetusers WHERE id=@userguid

Disclaimer

These queries are provided as a guide, and are by no means perfect. I didn't write all of these - many are collated from MSDN documentation and community sources over the years.

Tags