Regarding SELECT @@INDENTITY

IDE: Visual Studio 2008
DB: SSCE 3.5
OS: WinXP SP2 (CHS)
.....



Code Snippet
String str_sql_insert = "INSERT INTO Person (Name, ShortName, Description, Tag) VALUES ('" + this.TextBox.Text.Trim() + "', '" + this.ShortNameTextBox.Text.Trim() + "', '" + this.DescriptionTextBox.Text.Trim() + "','" + this.TagComboBox.SelectedValue.ToString().Trim() + "); SELECT @@INDENTITY";

SqlCeConnection tempConn = dbman.getConn();
SqlCeCommand tempComm = new SqlCeCommand(str_sql_insert, tempConn);
tempConn.Open();
Object ob = tempComm.ExecuteScalar();

.....

When I run the application there is a error report on the last line of the code above:
[ Token line number = 1,Token line offset = 127,Token in error = SELECT ]

When I copy the SQL string into the QueryBuilder in the VS2008 it is works and returned a correct value.

I want to know is there something wrong with the sql string or the ExecuteScalar() cant execute 2 steps command?

thanks