Questions tagged as 'sql-server'

Tagged questions
1
answer

Can not perform an aggregate function on an expression containing an aggregate or a subquery [duplicate]

I have this query and it does not allow me to use an aggregation function within another aggregation function and the fact is that I want the fields not to be repeated and I have already tried with distinct and nothing. this is the error:...
asked by 21.08.2018 / 20:11
1
answer

Insert data into a table with the same primary key

Good, I'm doing a screen where I store the payments of some clients, at the moment of inserting, I must put the same client code. I must use the same client id which is the primary key which gave me an error. I could fix it by doing a procedure...
asked by 15.08.2017 / 17:08
2
answers

Operator in SQL Server [closed]

What does this operator mean?:="?     
asked by 30.10.2018 / 18:01
1
answer

SQL date show in php ago when it was the record

I work on a table of reminders and I would like to be able to show how much the record was created in my table My table tasks : id idusuario usuario titulo Contenido fecha Estado 1 1 juan titulo1 aaa qq 17-08-1...
asked by 27.08.2018 / 20:05
1
answer

Help with Transact-SQL [closed]

Design with code in T-SQL language a block of instructions that calculates the average age of employees, and show us a message by console indicating whether the average exceeds 50 years of age or not. employees table Someone tells me...
asked by 01.12.2018 / 14:30
2
answers

stored procedures [closed]

I need to know how to do stored procedures in SQL Server for working I have a small database something like this: use Inventario create table Clientes ( Nit int, Nombre char (50), Direccion char(50), Telefono int, primary key (Nit) ); create...
asked by 23.06.2017 / 16:31
1
answer

How to connect a WPF application with SQL SERVER using a web service? [closed]

I have a wpf application with a sql server connection through a connection string created by entity framwework, but I need to connect to sql server through a web service (the web service has the connection string)     
asked by 30.04.2018 / 15:52
3
answers

How to insert 100 records in a SQL Server table at the same time [closed]

Could you support me? I need to insert 100 records at the same time in a user table and I know that it can be done through a query, unfortunately I do not know much about SQL to do so and insert one at a time would be very slow. The table con...
asked by 05.07.2018 / 16:43