When generating the query for the dates in SQL the result is correct, but when I put it in separate queries, when I want to see it in XtraReport only shows me the first one, my question is how could I solve this problem ? either fr...
I would like to know if it is possible, and how it is done, to update data from one table by others from another.
For example:
Table 1:
id_tabla1 | Nombre | Descripcion
Table 2:
id_tabla2 | Nombre | Descripcion
The difference be...
I need to pass variables to the SQLCMD command. I have the following script:
#! /usr/bin/perl
use strict;
use POSIX qw(strftime);
use Config::IniFiles;
my $TODAY = strftime "%Y%m%d", localtime;
my $cfg = Config::IniFiles->new( -file =>...
I try to install sql server x64 in windows 8 but it presents me the errors (attached image). help please choose the first attempts to de-install and re-install, to change installer.
I could not correct the error, but confirm that the e...
When the Entity Framework creates fields by default in a table of type string, use nvarchar . But I understand that nvarchar takes more space than varchar . Can the use of nvarchar double the size of a table? Is it reco...
I need to do, a backup of my database in sql server 2000, but only of the physical part, because I modified some tables, and add some new SP, well thank you very much from now, very happy with this community. Greetings
I have the following query:
Realize a trigger of type update in the table "x" and verify if the new data of the name and appelled already exist, if they do not change, otherwise modify the information.
create trigger ActualizarInfo
on tabla1
f...
I explain in database how I do if in the database users.dbo.Users_Master I have 18,000 accounts or more and made the mistake of adding 2,000,000 points in the points column but before I had a backup which shows that the maximum of any user was 6...