Questions tagged as 'tsql'

How can I enable a user who is offline? I have a user associated with a Login in a database but it is disabled     

Good morning, in a trigger for insert I need to delete all the records that have a value greater than 0 in vat and at the same time delete one that does not say vat of the same client and same rut. (Does not have primary key) EJ: Cliente...

I have a SELECT in SQL Server and I want to export it to a text file (result.txt), I can see that it can be done with some programming language, but I want to do it with TSQL. If it is possible?     

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...