Questions tagged as 'sql-server'

Tagged questions
1
answer

Compares sqlsrv_query with text

I'm starting PHP with SQL Server 2008. The code below makes a query in the database and displays what has been obtained. <?php $serverName = "DESKTOP-B8EB4SG\SQLEXPRESS"; $connectionInfo = array( "Database"=>"contas", "UID"=>"sa",...
asked by 03.05.2018 / 00:33
0
answers

Questions about user and remote connection SQL Server

Good morning, I created a remote connection from my database here at work, where I can access from home feathers by entering the company's fixed IP . So far so good, everything is running perfectly. But now, I need to know if it is possibl...
asked by 03.05.2018 / 14:23
0
answers

Error while doing restore Database Application Windows Forms

I'm creating the database backup, but I can not restore it. It shows the following error: Thisismycodetoperformtherestoreofthebanktomyapplication.try{var_with1=openFileDialog1;_with1.Filter=("DB Backup File|*.bak;"); _with1.FilterIn...
asked by 26.04.2018 / 20:52
0
answers

Executing a Procedure within a Function or Select

I need to register every time a SELECT is run on my system, if the user is logged in, this process would be done inside my ERP that allows this type of Customization, however I tried within SELECT to insert a function to call a procedure that do...
asked by 25.04.2018 / 20:31
1
answer

Recursive query does not return records when the parent product and the child product have the same code

I have a table that maps a production line. Home The fields are: Product: Output product of the machine. Home ParentProduct: Input product. Home Machine: Machine code. Home I'm using CTE's to get the data recursively. This works when the Produc...
asked by 23.04.2018 / 15:00
1
answer

How to calculate mean and show the highest and lowest values? [closed]

I started to study SQL SERVER and faced with the following problem:    create a function that calculates the average of the students and if it is GREATER THAN 7 the student should be considered approved; if not, disapproved. How do I do t...
asked by 22.04.2018 / 17:56
1
answer

Message Appears When Selecting Value in a Dropdownlist

I created a dropdownlist in asp.net linked to a database. Now I want a message to appear as soon as one of the db values is selected. (Ex: A dropdownlist with three values "A", "B", "C".) When I click on "B", a message appears saying: "You ch...
asked by 28.04.2018 / 02:00
0
answers

Change field format in excel to import into sql server wizard

I need to do a data import from an excel to sql server. My big problem is that the data coming from the source of an excel column is being interpreted by this wizard as varchar, even though I make all the changes that I can imagine. Basica...
asked by 24.04.2018 / 14:17
0
answers

INNER JOIN with a SELECT TOP

While generating a script, I tried to modify a where for inner join . However, the time when running with inner join was more than 10 minutes and with the where, it was in a matter of seconds, as the example below. I would like to know why th...
asked by 24.04.2018 / 15:01
1
answer

Best way to ensure query isolation

I have the following scenario: A table in SQL Server that contains records of processes that can be run across multiple services ( Windows Services in C # ). Something like: CREATE TABLE Processo ( Id INT IDENTITY NOT NULL,...
asked by 18.04.2018 / 19:00