Questions tagged as 'sql-server'

Tagged questions
1
answer

UPDATE according to select

SELECT t1.Descripcion, t1.IdReg, t2.IdReg As IdRegSegIncidente FROM INCIDENTES t1 JOIN (SELECT IdRegIncidente, MAX(IdReg) IdReg FROM SEGUIMIENTO_INCIDENTES GROU...
asked by 19.04.2018 / 01:02
1
answer

Use PDO in PHP to connect to the SQL Sever database

I try to connect to the Microsoft SQL Server Managament Studio database with PDO but it tells me that an error occurred when connecting to the database. Here I attach the code: private $conn; function __construct() { } /** * Establi...
asked by 10.04.2018 / 17:52
1
answer

Use an SQL Query as the source of a Model in the Entity Framework

Good morning! I comment, I'm having the need to add a Model in EF, but with the peculiarity that you use a Query SQL as a source of information instead of a table. I tried to do it by the normal ways in the following way [Table("[dbo]....
asked by 09.04.2018 / 14:39
1
answer

Relational model of an organizational structure, SQL SERVER

if someone can help me .. I am creating a database for an organizational structure of a company that has different levels, that is I have a main node from which more children hang and so on 6 levels. It's saying something like that .....
asked by 10.04.2018 / 15:05
0
answers

Column encrypted in SQL Server?

Hello! I'm a rookie handling this type of situation. I am working with a database in SQL Server, where my application must do a login, without registration. This table has already been created and has been used by other applications. However,...
asked by 10.04.2018 / 21:15
0
answers

Table diagram in SQL Server Management Studio

I am trying to create a diagram but the option does not appear in the object browser inside the database node. Any idea why it can be or how do I solve it? A thousand thanks!     
asked by 12.04.2018 / 04:57
0
answers

Retrieve a database

Delete a database from the object browser, do you know if there is a way to recover it with a program or something like that?     
asked by 02.05.2018 / 20:23
1
answer

Can I update several elements of my table at the same time?

I have a customer table from a bank box. There are different fields, such as Identifier, User_Code, User_Name, User_Current ... I have to modify a field of four different clients but they belong to the same table: update miTabla set Fec_Anulac...
asked by 26.03.2018 / 18:01
0
answers

Lack of data when saving array in a $ _SESSION

I'm doing a program that generates a template automatically, I'm using laravel and PHP 7.2. I am saving an sql query in an array and then saving it in a SESSION, everything up to there works fine, the problem is that when consulting the data...
asked by 30.03.2018 / 17:49
1
answer

Problem when capturing a data by SQL Server stored procedure

I am working with this table in SQL Server 2014: create table suceso ( id int identity (1,1) not null, codMod varchar (10) not null, fecha date not null constraint pk_suceso primary key (id) ); go And this is the stored procedure:...
asked by 21.03.2018 / 13:04