Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Nov 23, 1999

Adding Records to a Table in an SQL Database

Question:
My question is simple, yet I can't seem to find any help on it. I cannot add records to any of the tables in my SQL database. All the login permissions are set to allow me to do it, but the tables still remain un-updatable.

Answer:
Is the database in read-only mode? Is this database a replication subscriber? How are you trying to accomplish the update?

 
Update mytable 
set mycolumn 
to mynewval where myoldval=x
?

Sorry I couldn't be more helpful.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date