Questions tagged as 'sql-server'

Tagged questions
1
answer

Insert values from C # text boxes in (ASP.NET) to SQL Server

Good I am new in the subject for development, work in a project, the code was provided to me, my case is that I have to capture values of 3 text boxes and store them in a database in SQL Server, mainly they are 3 values to store as E-Mail type a...
asked by 04.10.2018 / 19:26
1
answer

Validate if there is a record in a DB table and store in a variable

I am making a query to validate if there is a record in the database, for this I used the following I declare variable decimal serie= 10002;//este valor corresponde a un ejemplo, la variable puede tomar cualquier valor I make the query...
asked by 20.09.2018 / 15:53
1
answer

Take value of a field from an identifier of a table

I have the following instructions with which I intend to obtain a value of a field from an identifier of a table. idFac = Convert.ToDecimal(Request.QueryString["id"]);//Capturo el Id del registro sql.Append("SELECT codigo from factu...
asked by 19.09.2018 / 18:51
1
answer

Divide result of a query with many fields in 2 lines

I have a table with these fields: Usuario1 Nif1 Nombre1 Telefono1 Usuario2 Nif2 Nombre2 Telefono2 1 213 Pepe 123456 2 546 Juan 89173 3 456 Miguel 43434...
asked by 21.09.2018 / 16:54
1
answer

I can not connect to my server in SQL Server 2014 network

Hello everyone I have the following problem: I am connecting to my server sql server (use sql server 2014) and is able to connect using the ip address of the server (eg 192.168.1.x \ SQLEXPRESS). But when I try to connect to using the server nam...
asked by 01.09.2018 / 07:40
4
answers

select with condition if null grab another column in a FUNCTION

I try to make a query in a FUNCTION but this time with a condition that if in my table the "Strnttr" field is null grab the value of another column I show them my FUNCTION is from the OJDT table where I want to apply it ALTER FUNCTION [dbo]...
asked by 13.08.2018 / 19:49
1
answer

Restarurar DataBase Data NOT Pre-Existing SQL

I have current records in a database called A_Restaurate I have Pedro, Jose, saul, Mengano, So and so in order over a thousand Old Accounts records I want to restore all that data to a New Data Base called EN_USO but this has some records wi...
asked by 20.10.2018 / 23:27
1
answer

What is the Script to move a Base data already CReada in SQL server 2008 R2?

Good day afternoons or evenings. I have a BATABASE already created in manager studio of SQL server 2008 R2, I want to move the BASEDATA (extention files .mdf and .ldf) the question is Is there a MOVE script that moves me to a new physical locati...
asked by 16.08.2018 / 04:46
1
answer

How can I filter data with dates in C #?

In a form I have two datetimePicker, and I want to filter the data using the dates of the datetimePicker, but it does not work out. Can you tell me what I'm wrong with? I'm programming in three layer model, I leave my code. BUSINESS LAYER (BU...
asked by 07.08.2018 / 19:17
1
answer

Execute SQLCMD from a JOB

Good afternoon colleagues, I need your help to know what is happening with my JOB since it does not perform the action I want. I commented that I made a Stored Procedure to send a JOB call which executes a command line SQ...
asked by 07.08.2018 / 01:46