Question: I will essentially have a table with data like

```
id, parent_id, child number
1, 5, 1
2, 5, 2
3, 5, 3
4, 5, 4
5, 6, 1
6, 6, 2

```

What I need is an SQL Query that would be able to add a row representing a new Child of parent id 5, so would be told something along the lines of 

```
INSERT INTO `table` (`parent_id`)
VALUES ('5')
SET `child_number` = 1 + MAX(`child_number`) WHERE `parent_id` = '5'

```

But i doubt that that sql would work.
Any help would be greatly appreciated, thanks.

Answer: 
If I read correctly this post from the Microsoft website <http://msdn.microsoft.com/en-us/windows/bg162891.aspx> you can use the SDK and compile with a different version of Visual Studio but for debugging you need the 2013.

`The Windows SDK now includes support that enables the Visual Studio "Graphics Debugging" and "Graphics Frame Analysis" features for both Windows 8.1 and Windows Phone 8.1.
Note: These features require Visual Studio 2013 Update 2 or later.`
There is no Seprate Sdk for `windows phone 8.1` unlike `windows phone 8.0` but instead of that The Windows Phone 8.1 development tools are included with `Visual Studio 2013 (Update 2 or later)`. so you are needed to go for `Visual Studio 2013`. If you already have Visual Studio 2013 installed, use [this download link](http://go.microsoft.com/fwlink/?LinkId=394245) to install Visual Studio 2013 Update 2 RC. If you don’t have Visual Studio 2013, you will need to install Visual Studio Express 2013 for Windows, which includes Update 2 RC, by using [this download link](http://go.microsoft.com/fwlink/?LinkId=395053)

If you want to use the Windows Phone 8.1 emulators you will need to install the [Windows Phone 8.1 Emulators package](http://go.microsoft.com/fwlink/?LinkId=394354), which will adds six emulator images to an existing installation of Visual Studio.