Questions tagged as 'sql-server-2008'

Tagged questions
0
answers

How to change from sql server 2005 to 2008 and from collection

I am migrating my database that is located in Sql server 2005 with collection SQL_Latin1_General_CP850_CI_AS and I want to migrate it to Sql server 2008 R2 with collection SQL_Latin1_General_Pref_CP850_CI_AS, when I change the collection in prop...
asked by 29.10.2018 / 14:34
0
answers

Connect website with sql server 2008

I'm starting to learn a bit of programming, and I try to make a record that connects to a sql manager studio 2008 r2 database. Everything is fine in terms of the local environment, the registry works just like the sql, but as soon as I upload th...
asked by 12.06.2017 / 00:13
3
answers

Make a DISTINCT only in one column?

I want to do a DISTINCT but only apply in a column because I consult two things, an ID and an image and I just want you to show me an image of that product. I try to keep it that way. | producto | imagen | |----------|--------------...
asked by 06.08.2017 / 02:36
4
answers

Do not insert form in the Database

Good afternoon. I am doing an inventory system with PHP AND SQL SERVER 2008, when making the connection it is successful but when inserting data and consulting them in the database I verify and it does not insert anything. $serverName = ("...
asked by 07.03.2017 / 18:14
1
answer

Update database with Entity Framework 6

Well I'm using Visual Studio 2017, I have a project in C # which has installed Entity Framework in version 6.2.0 in addition to using SQL Server 2008. (I'm not using MVC but Web API) What I need is to be able to map my database model in the V...
asked by 26.01.2018 / 01:46
1
answer

Failed to execute statement in SQL Server 2008 [duplicate]

I need to run this MYSQL statement in SQLServer CREATE TABLE venta ( idVenta INTEGER PRIMARY KEY, Fecha DATE NOT NULL, Cliente_Cedula INTEGER NOT NULL, producto_idProducto INTEGER NOT NULL, empleado_Cedula INTEGER NOT NULL, can...
asked by 02.03.2018 / 17:14
1
answer

If I execute a second stored procedure within the first stored procedure, does the first wait until the second stored procedure ends?

What happens is that I want to send a table-like parameter to a stored procedure that is called inside the body of another stored procedure. The second process takes a little more time so I wanted to know if the first one waits for the second...
asked by 01.12.2016 / 15:05
2
answers

How to filter repeated series in SQL

I'm using SQL 2008 to query using inner join: SELECT t2.intencion_id,t2.numpago,t3.orden,t2.importe ,SUM([importeaplicado]) AS importeaplicado ,t3.intfinanciamiento_interes ,t1.[estatus] FROM [APLICACIONES] as t1 inner join movcargos as...
asked by 01.11.2016 / 20:05
1
answer

Search for fields in sql server 2008 from C # [closed]

My problem is this: I have a connection with a data base sql server 2008 which extracts a number (manufacturing order) only if that number is in the database, if the number is not found send me a Messagebox where it indicates th...
asked by 17.11.2016 / 15:41
1
answer

Display data from a SQL Server 2008 stored procedure in PHP

Good afternoon everyone, I need to make 3 graphs with data from a SQL Server 2008 database, this data is subtracted from 3 stored procedures respectively and since the solution is only one page with the 3 graphics joined in 1 large one, I dec...
asked by 30.09.2018 / 19:40