With SQL Server Management Studio you have the ability to do just about everything you can do using T-SQL commands. One problem with using the GUI is that it is difficult to remember everything you clicked on to reproduce the behavior a second time. Another issue is that most of what you do through the GUI is done immediately which may not always be the best scenario. How can I capture what SQL Server is doing so I can reproduce the behavior or run the commands at a later time.
Ranking functions return a ranking value for each row in a partition. All the ranking functions are non-deterministic. Each of the ranking functions also needs the OVER( ) clause.
We can create variables, parameters, and columns of the xml datatype – if we associate a collection of XML schemas with a variable, parameter, or column of xml datatype. In this case, the xml datatype instance is called typed XML. Continue reading #SqlServer interview question: What is typed XML?→