I am trying to attach to a database in my "Users" folder. When I get to the Attach dialog and click "Add", SSMS can't see any files inside my "Users" folder. When I select Open from the File menu it can.
I hate security.
How can I get SQL Server to see my "Users" folder? I'm logged in as myself.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…