I have a table aspnet_Users with columns UserId (uniqueidentifier) and UserName varchar(256).
What I would like to do is copy all the UserName values from this table to my UserProfiles table that also has also has UserId and UserName columns so that the UserName values match the UserId values in the new table - i.e. username jsmith in record with UserId=xxyx in aspnet_Users is copied to the record in UserProfiles that has a UserId of xxyx
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful.
Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …