SQL Server 2008 entering data into a table

Hi

I am sure that I am making a simple error here but in SQL Server 2008 Express R2 I right click on a table as per the image below but can't seem to find an option to enable adding data in the "spreadsheet" style view

1
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Olaf DoschkeSoftware DeveloperCommented:
Your screenshot reveals you are connected to an SQL Server Compact database. And the context menu of tables obviously offers less options, here.

SSMS offers no editing of SQL Server Compact tables data. SSMS is concerned with real deal databases, mainly, not CE databases.

Use a query window and INSERT SQLs to insert data or some other tool for compact databases/tables.

Google sql ce database viewer for example.

Bye, Olaf.
0
 
AshokCommented:
Under the table, if you see Fast Forward button (to go to last record), just press it.

Then press DOWN arrow key.  This will create empty record where you can specify values for all fields.

HTH
Ashok
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi Thanks but I can't see where you mean
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks. Had done that in the meantime. Thanks for clarifying that no manual entry system exists
0
 
8080_DiverCommented:
You might want to create a stored procedure that would let you provide the dta to be inserted as the input parameters to the stored proc.  Executing that would then let you enter a row's data.  The SP would also let you do some preliminary validity checking on the data being entered.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.