Questions tagged as 'sql-server'

Tagged questions
2
answers

How to Validate Logeo sql server in store procedure with input variables

> Buenas noches quisiera que me puedan ayudar estoy realizando una > validación : Bueno la verdad estoy realizando un Logeo que todos los usuarios van tener 3 intentos al ingresar con lenguaje c# con **sql > server y procedimie...
asked by 13.05.2017 / 07:44
1
answer

Debug StoreProcedure from SqlServer Management

Good day everyone today I have a question since I have never used the sql server management debugger and I need debugge a stored procedure in which I make several insert to different tables and when executing it for a single record it st...
asked by 04.04.2017 / 17:26
1
answer

Send parameters for SQL command as parameterized variable

I need to send the parameters that I will use in a sql command, I know that it can be done with Dim paramater As New SqlParameter("@fptemp", serializedTemplate) but now the problem comes when I use a parameterizable function to execute th...
asked by 28.02.2017 / 21:20
2
answers

download sql server 2014 w8.1 [closed]

I run out of a computer and I'm using another, one with window8.1 and I can not install sql server 2014. I open the microsoft page and the page is down ... I'll download and it's blank .. two days ago I'm wanting to install the sql server and I...
asked by 12.03.2017 / 07:03
3
answers

Automated Date

I have the following question: How to put an automatic date in SQL Server or in C #? For example in this query : SELECT id,Registration FROM tbl_CRs WHERE Registration BETWEEN '20170201' AND '20170216' and [Status]='OPEN' In C # it woul...
asked by 16.02.2017 / 19:52
1
answer

How to send data from a dataGrid that is constantly changing to an SQL table

is constantly changing because it gets its information with different excel files.  with this code. public partial class PM : Form { private BindingSource bindingsource1 = new BindingSource(); private SqlDataAdapter dataAdapter = new S...
asked by 30.03.2017 / 18:48
1
answer

Get OUTPUT of Stored Procedure

I have for example this stored procedure ALTER PROCEDURE dbo.PersonaDoc @cDocumento varchar (20) AS SELECT Ruta_Line FROM Persona WHERE (documento= @cDocumento) What difference would there be to consuming it in C # using ExecuteNonQuery, E...
asked by 03.02.2017 / 20:05
1
answer

Do SELECT with 20 different Monsters IDs in SQL server 2008 R2

I have the following SQL server structure: ROW Monstruo MobID Fecha 1 Feo 4001 14-12-2016 22:22:03 2 Horrible 4002 12-12-2016 22:22:03 3 Espanto 4003 11-12-2016 22:22:03 4 Espanto 4003 17-12-2016 22:22:03 5...
asked by 30.12.2016 / 16:20
1
answer

INNER JOIN query on Android with SQL Server [closed]

I need to make a select query with two different databases. How could I? From the database Xtraining I have the table dbo.tbUsuarioOperario with the field idOperario . From the database Workflow I have the...
asked by 14.11.2016 / 15:58
2
answers

Group records in ranges of 15 in 15 in SQL Server 2014

I have the following table: I need a script that returns the data in the following way from FECHA_INGRESO and GETDATE() : I can get the number of records, but I have no idea how to get them grouped from 15 to 15. I...
asked by 27.10.2016 / 20:25