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 …
Tag: sql
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,
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 …
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 …
I keep getting 1064 error in phpmyadmin
I am trying to create a table in phpmyadmin with the following SQL : CREATE TABLE `umOrder`.`Bill` ( `Id` INT(5) NOT NULL AUTO_INCREMENT , `userID` VARCHAR(255) NOT NULL , `product` …
I’m trying to write a SQL statement in VBA to concatenate first and last name
I’m getting errors. SELECT [FirstName] & ” ” & [LastName] AS FullName, TblMembers.Position FROM TblMembers WHERE (((TblMembers.Position)=”Lt #1″)); This is the original…. SQL = “SELECT […
Export one field from access to specific cell in excel
I want to place a name from a table/query to a specific cell from access. I have a check sheet with lots of data in other cells that at the top has the persons name at the top. I would like a button …
Passing value from the textbox to “TOP n” clause in SQL query
I believe I have quite simple question, that would help me finish my project. I don’t usually work with Access, but I was asked to help someone so here I am. My problem: I have a Form1 called “Start”…
Access VBA Find Records using Search Critera in Recordset
I have an Access database connected to excel. I need to find records using Search criteria in recordset from Excel Table name in MS Access is MyTable with more than 10 columns with data User enters string data in Excel cell, let us assume Worksheets(“Sheet1”).Cells(1, 1) My need is, macro has to l…
Does Rails submit form need protection from SQL injections or XSS attacks?
I am developing a secure Rails app on a secure internal server, though I still want to protect it from any kind of SQL injections or XSS attacks. I know that if I have a search box I can use something …