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