Questions tagged as 'sql-server'

Tagged questions
1
answer

sql when using nolock

In a query made with two tables, there is the possibility of placing a nolock. Why is this done? FROM tabla1 t1 (nolock) INNER JOIN tabla2 t2     
asked by 18.06.2016 / 16:36
3
answers

Casting of numbers with decimal point

Good morning to all of you, today I am trying to round a value of FLOAT to two decimals but doing so by consulting SQL SERVER shown below, some values rounded me correctly and others not, example: 19.1 I rounded to 19.10 already with t...
asked by 30.11.2016 / 16:34
5
answers

How to delete all records from a SQLServer table?

I need to delete all the records of a SQLServer table without indicating which one I want to delete, I want them to be all and this code deletes data in specific delete from tbl_usuarios where nombre='Abi';     
asked by 19.04.2017 / 17:58
3
answers

SQL query by data type

I have the following query: SELECT COUNT(co.sexo_id) as TOTALDIA, se.SEXO FROM CONDUCTORES co JOIN TRAMITE tr ON co.conductor_id=tr.conductor_id join LICENCIAS lic on tr.licencia_id=lic.licencia_id jo...
asked by 05.09.2018 / 19:30
3
answers

Insert records in the form of a table

Good afternoon, I am working on a restaurant system in C # using Windows Forms, which is the part of taking the order: What I want to achieve in inserting this order in table form in SQL SERVER In the following table: and how I...
asked by 28.09.2018 / 00:46
2
answers

Extract VARCHAR inside another VARCHAR in SQL Server

My question is very simple but requires a bit of programming, easy for some, complex for me at this time. I have a table that gives me these examples as an example: +--------------------------------------------------+ | Da...
asked by 26.04.2017 / 17:27
2
answers

SQL using LIKE within a variable

Good friends, I want to know how to use like inside a variable to know if there are 6,7,8 numbers. Does anyone know what would be the correct syntax for this case? @listaMenus = '4,5,6,7,8,9,10' if (@listaMenus like '%8%' or '%6%') begi...
asked by 10.09.2018 / 22:57
1
answer

Visual Studio and .NET Framework versions supported by SQL Server 2000

I would like to know which versions of Visual Studio and .NET Framework I have to use to connect to a SQL Server 2000 data server. I have read that some versions are not compatible. Thank you.     
asked by 14.06.2016 / 19:27
2
answers

what does NOT mean in UPDATE SQL?

Search Google and I can not find an answer for this, it seems easier to ask here. UPDATE table SET Paciente = Juan Perez WHERE RowID IN NOT (1,2.3)     
asked by 18.09.2016 / 06:22
1
answer

Statement in sql for a datetime

I have this fragment of cogigo public List<byte[]> selectAlarmas1(int numero) { try { cn = new SqlConnection("Data Source = PRUEBA; Initial Catalog = FUCS; Persist Security Info = True; Use...
asked by 17.10.2016 / 22:05