devxlogo

Adding Records to a Table in an SQL Database

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-admin

Share the Post: