After the last post, I worked on getting a heating system put into the addition. As of last night, that’s done. It only cost 3 grand. (that’s more than i used to make in 7 weeks) I am ever so thankful to have a job that pays me a good wage. If i was still…
Read More Work, work, then some more work.Sooner or later in SQL, you’re going to be asked to change how some text is formatted. Making changes to text is pretty straightforward. First, you need to know that when you’re manipulating text (in SQL it’s stored as a VARCHAR or NVARCHAR), you’re manipulating a string. If you think of the string to the…
Read More String Manipulation — SUBSTRINGWhenever someone starts learning Microsoft SQL Server they always ask for a demo database they can connect to. If you don’t have access to one already there is hope. Search on amazon and see how cheaply you can find a copy of Microsoft SQL Server 2000 Developer edition. I’ve found them as low as $50. …
Read More Sample Databases Available for Download