Questions tagged as 'sql-server'

1
answer

C # hash encryption

I was able to create a registry with encrypted password, but in the method of access (log in) I am in doubt on how to get the password entered and compare it with the password registered with encryption. Here is my code: class FuncionarioDAO...
asked by 16.10.2018 / 04:33
1
answer

ALTER TO - SQL SERVER

In my bank I have 2 stored procedures, dbo.A and dbo.B. in the procedure dbo.A there are the parameters @name, @rua in the procedure dbo.B there are the parameters @cep, @telefone But I also need to have the dbo.A rbo parameter in dbo.B. I ne...
asked by 28.04.2016 / 13:04
1
answer

Date choices

Good afternoon guys, I want to make a iif in sql that if the FLAG field equals "" it will bring the date of the DTDIGIT column and store it in the variable @dataInicio and when FLAG is "S " it brings the dat...
asked by 11.01.2018 / 19:59
1
answer

select data from a sql server procedure in C #

I made a procedure that takes all the data of all the columns of my sql table of interest, in my application asp in C # I can put all the rows in a list, but I need to refine this search by taking only all the data of a column only. I researched...
asked by 11.01.2018 / 12:10
1
answer

PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlsrv.so' - php7. +++

After completing the installation of PHP7. ++ I got the following error after performing all the steps of the SQL Server PDO Driver Configuration Tutorial for php, restart apache2: PHP Warning: PHP Startup: Unable to load dynamic library 'pdo...
asked by 05.08.2018 / 23:49
1
answer

External connection to sql server by android application, C # xamarim [closed]

Well I'm looking for information about what procedure to access a sql server database by android.     
asked by 28.07.2018 / 15:44
1
answer

Reordering AutoIncrement in SQL

Hey guys, I created an ID table with Auto Increment, checking the table I saw that Bugou, has any command in SQL that reorders from the value 1,2,3,4 to the last one? just for the sake of reorganization. Thank you.     
asked by 12.09.2018 / 18:24
1
answer

How to reference the Assembly in Visual Studio?

I was trying to create an application that connects to a database. But the methods of SqlConnection.Open() , SqlConnection.State and SqlConnection.Close() are with errors all appear the message: The type "Component" is def...
asked by 08.06.2017 / 04:43
1
answer

Attribute type varbinary sql server with C #

This DocumentoPDF column so far was not used by the system: HomeIamnotsurewhattodowiththis:Thisistheerrormessage:"já existe um DataReader aberto associado a este command que deve ser fechado primeiro" The error already occurs...
asked by 07.06.2017 / 03:57
1
answer

Search last registered date in cpf_cnpj sql

I have a basis that I need one of the columns to be the search for the lowest date registered in that CPF / CNPJ at the base. In the example would create the column data_anterior : cpf_cnpj | aplicado| data_aplic | data_anterior ---...
asked by 18.05.2018 / 01:31