Questions tagged as 'sql-server'

Tagged questions
1
answer

Give access to a table in a database in SQL-SERVER

Does anyone know, how to give full permissions to a table in a database in SQL SEVER? Example: I have the user: tests_1 and I want him to only have full permissions to the table [GUIDES] of a database, so he can do (insert, delete, update, selec...
asked by 26.11.2018 / 15:50
1
answer

Insert a consecutive number in a field sorted by another field in sql 2012

Good afternoon, colleague, have the next case to see if they help me solve it, it turns out that I am working in sql server 2012 . I want you to insert a consecutive number in a field x according to a certain order example:...
asked by 22.11.2018 / 23:03
1
answer

how I connect to sql by ip publishes from

I want to connect to Sql from a server with a public ip, I already get the network connection, but not by ip public, I also configure ports 1433 and the firewall, and I can not yet     
asked by 07.12.2017 / 17:42
3
answers

USE MAX and CASE at the same time SQLSERVER

Good morning, I created a simple database in SQLSERVER, which has repeated employees of different ages, plus an abbreviation to see if I was single or married. What I want is for me to show the maximum age per employee, I know it is not correct,...
asked by 16.12.2017 / 23:05
2
answers

Help with SQL server

Does anyone know why it goes like this and how to solve it? yesterday I was working normal with him but today I went to continue and he does not leave me ...     
asked by 13.11.2017 / 19:36
1
answer

Search Number repeated in SQL SERVER

How can I find a repeated number in a Table Items in different Columns called Gem1, Gem2, Gem3, Gem4, Gem5, Gem6 but that are repeated in the same row. example: UsuarioID, Gem1, Gem2, Gem3, Gem4, Gem5, Gem6 0001 23 23 23 23...
asked by 18.03.2017 / 02:51
2
answers

SQL Server Management Studio color in keywords

Good morning: I have installed the Microsoft SQL Server Management Studio 2016 version 13.0.15900.1 and even though I'm looking for it, I can not get the keywords to be in a different color. I read that I had to enable the Intellisense but I hav...
asked by 04.04.2017 / 15:40
1
answer

how to add letters and numbers in C # code? [closed]

What I want to know is how I can generate a new code but with the following -When selecting the first radiobutton, the first two letters of the code are generated -When selecting the second radio button, the third letter of the code is generated...
asked by 30.05.2018 / 19:59
1
answer

Problem with SQL Server script? Help

I have the following sql server code with the tables site, neighborhood, location and province. The scrip throws some syntax error? What is the result that throws? thank you for hours I'm struggling with this SELECT S.razonSocial, count(*) FRO...
asked by 09.06.2018 / 07:46
1
answer

Help with sql connection from java please

I'm running around with this since yesterday and I do not know the problem. I want to connect my test program with the database of my pc, from java to sql server 2017, I already made all the configurations, and the connection test gives me ok, b...
asked by 12.09.2018 / 04:16