Using SQL Server, to remove the is identity setting (auto increment) for a table, I have to drop and recreate a table. Is there a way to disable the Idendity Setting for all tables with a simple …
Entity framework query on just added but not saved values
I’m using Entity Framework from a couple of years and I have a little problem now. I add an entity to my table, with and here ok. Then, I’d like to make a query on MyTable, like The code above will query on my MyTable in the db. Is there a way to query also on the just added value,
Access SQL using IN where record must satisfy all values
I have a join statement, like this: SELECT distinct(p.id), p.id, p.first_name as [First Name], p.last_name as [Last Name] FROM tbl_person as p , tbl_person_languages as pl WHERE pl.person_id = …
Joining multiple tables in Access via vba/sql
I have a database of tables, each contains two columns, the first being a code, second being an amount. The tables are pulled from data created on a daily basis, where a code will have data for a …
SQL Server trigger on specific column updated
I have a table with the following columns: ID | CLIENT_SYNCED_TIME | NAME | DESCRIPTION | LM_TIME The LM_TIME column will be set automatically by a trigger when any of the other column values get …
SQL Case insensitive IN search
I have this Table “Table” with content: +——–+ | Serial | +——–+ | d100m | <- expected result | D100M | <- expected result | d200m | <- expected result | d300L | | D400R | +—–…
what is the syntax error in this SQL update query in asp.net c#? [closed]
I am getting error in simple update query for dynamically created table,just can’t understand what the error here is.. c# code: cmd2 = new SqlCommand(“UPDATE ” + tname + “SET ans=@ans, sans=@sans, …
Record “old” not assigned yet
I have created this trigger: CREATE TRIGGER trig_update AFTER INSERT ON “delivery” FOR EACH ROW EXECUTE PROCEDURE premium1(); With this function: CREATE OR REPLACE FUNCTION premium1() RETURNS …
Relation passed to #or must be structurally compatible. Incompatible values: [:references]
I have two queries, I need an or between them, i.e. I want results that are returned by either the first or the second query. First query is a simple where() which gets all available items. @items = …
Access – Change fields in table automatically, if a field changes
Lets say I got a table with an id, pre- and lastname. I made them work as comboboxes in the table. Now if I change 1 field (lets say the id) with the combobox I want that all the other stuff is …