| Author: Vidhya 07 Aug 2008 | Member Level: Gold | Rating:  Points: 5 |
hi,
sp_rename: Changes the name of a user table in the current database. Currently, sp_rename support in SQL Server Compact 3.5 is limited to tables.
sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name' [ , [ @objtype = ] 'object_type' ]
In the following example I will demonstrate it's use (using the VS 2008 beta 2 Server Explorer):
The current tablename is Test.
Run the sp_rename command, with the 2 parameters: Old name and new name
The query parser complains.
Do a refresh...
And voila... all from plain old T-SQL!
Happy programming!
|
| Author: G.Joychandrasekaran 08 Aug 2008 | Member Level: Silver | Rating: Points: 3 |
First of all thanks for your response,
Actually i tried this in SQL server its working fine,
But i cannot do this same in SQL server CE.
Actually i am using SQL CE 3.5 in my mobile.
I expecting more on this.
|
| Author: syed shakeer hussain 01 Dec 2008 | Member Level: Gold | Rating: Points: 5 |
Hi.
You can you tell me how to store data permenanly in a mobile database.
Actually my problem is ,when i insert values using sqlce ,it is storing in mobile and i can see what values i had inserted.but when my mobile application is closed completly and re-opend again the previous data what i had stored in mobile that data is not present.
why it is happening can you send a little code for inserting data
|