You can use row_number() to sort and number the results. This can be useful for creating a view that shows a custom sorting order. But first, here are some different ways you can work with this function.
So you downloaded the AdventureWorks2012 database, and want to know what to do with the 190MB MDF file. You cannot just go to New Database or Attach Database in the GUI. Instead you need to run a query to create the database using the MDF file.
If you are new to Microsoft certifications but interested in Database Administration, this exam is perfect for you. It doesn’t count towards your MCSA but it gets you ready for a much harder exam.
How boring is it to learn a page full of data types just for an exam? That’s like learning the periodic table inside out. Besides, you can always google these things when you need them. Wrong answer! If you want to be a master of this you should knows these things blindfolded.
Decimal and Numeric are functionally equivalent according to documentation. https://msdn.microsoft.com/en-us/library/ms187746.aspx
If you are studying for the 70-461 exam like myself, then purchase Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 from Amazon. So far I have waddled through the first 150 pages, some parts requiring more time to absorb than others. I’ve been stuck on chapter 4 for quite some time as the concepts start to build on each other slightly, but nevertheless moving forward.
Here we are going to learn a little more about how queries are written and processed. Please note that SQL queries should be written in a certain order of operation (known as “keyed-in order”), and this order is not the same as the order the query is processed in.
SQL was based on the Relational Model, but is not necessarily confined by all the rules of the relational model.
SQL evolved from two branches of Mathematics – Set Theory and Predicate Logic. Here are some key points to understand.
If you are going to be working with SQL Server then you will need this for starters. The Express Edition is FREE and contains much of the functionality needed to experiment in a non-production environment. Download it and keep the setup files handy on your jump drive.