Does stored procedure functionality exist in SQL Server Mobile 2005 From looking at the books online I'm thinking no since I can't find a reference to a Create Procedure command. Thanks.
No. SQL Server Mobile does not support stored procedures.
The 'next best thing' is to use the Prepare method in your SqlCommand object, so that the sql statement only needs to be compiled once by your application:
SQL Server Mobile Stored Procedure?
Nima Amin
Binita
The 'next best thing' is to use the Prepare method in your SqlCommand object, so that the sql statement only needs to be compiled once by your application:
http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.prepare(VS.80).aspx