Questions tagged as 'sql-server-2008-r2'

Hello Good morning I hope and you can help me please I need your help, I am new in programming and the truth still costs me to program. I have a project where I make entry and exit records through a scanner using the barcode. My problem is that...

I have a problem when making a record of entries and exits of equipment, when doing an insert of my table Registro_Eq apparently I am not recovering correctly the data of my foreign key or maybe some step before inserting I am wrong. Someone cou...

I try to connect to a local database with the connection string that offers Visual Studio in the object browser SQL . The code is as follows: private void Form1_Load(object sender, EventArgs e) { SqlConnection myCon = new S...

I have a table with these fields: I need to create a table of type view where there is an additional column called Balance. The function of this column is to add or subtract the value of the column amount based on whether the value of N...

I have a table called Registers with this structure: What I do is add a new column to the right where a balance is going to be calculated (either add or subtract) based on the value of each record in the Concept column; something like t...