Questions tagged as 'sql-server-2014'

Tagged questions
3
answers

How to find a String from Regular Expressions

I have a field in the SQL Server 2014 database that stores the client address. The problem is that everything was stored in a single varchar field. Here are some real examples:    Antonio José Nerchis Street, 81    Street: Guaira /...
asked by 31.08.2016 / 20:09
1
answer

User who has permission to create another SQL Server user

I'm trying to use a user other than SA to create new users on a SQL Server 2014 base, I've tried the db_accessadmin and db_securityadmin roles yet, but they do not permissions to change other roles. For example, when I create a user, I wa...
asked by 24.01.2017 / 11:46
1
answer

How to change the language of Microsoft SQL Server Management Studio?

The Microsoft SQL Server 2014 Enterprise .ISO image file that is available for download through Microsoft DreamSpark exists only in the en-US version. Would you just like to change the language of the Management Studio interface? I have tried...
asked by 28.04.2014 / 13:44
1
answer

Is Visual Studio 2013 compatible with SQL Server 2014?

I connected the SQL table with Visual Studio, but at the time of wringing the table there was a message saying that SQL Server was not compatible. If not, will I have to download another Visual Studio or database?     
asked by 23.07.2015 / 20:08
1
answer

Problem with Decimal (4,2)

I have an MVC project, I am using Entity Framkework and in my database there is a table with a column of type decimal (4,2) . The problem is: I try to insert any value, for example: 5.00 // 5,00 // 14.21 // 14,21 and it always re...
asked by 19.05.2015 / 15:29
1
answer

Error; The connection has not been closed. The current state of the connection is opened SqlServer 2016

I'm creating an application in Visual Studio in C #, and connecting to sqlserver on Server Explore was all correct in connection testing. This is my connection string: return "Data Source=DESKTOP-58ASAQP\MSSQLSERVER16;Initial Catalog=Contro...
asked by 17.04.2016 / 23:06
3
answers

Calculate the average between 3 dates directly in sqlserver database?

What is the most efficient way to calculate the average of dates in the same column by sqlserver bank? I need to get the date of the last 3 sales of a customer, and return in days to know if that customer buys, for example, every 30 days, 60 in...
asked by 13.08.2015 / 21:33
3
answers

How to tell if a key in the sql server is identity

How to tell if a key in the sql server is identity? How do I find out? The version is 2014.     
asked by 18.04.2017 / 18:56
2
answers

Error while inserting - String or binary data would be truncated

When doing this insert: INSERT INTO t_cmo_oit1980_leitura(id_oit_let,id_oit,rx_num, dt_rx) SELECT (1), (SELECT id_oit FROM t_cmo_oit1980 WHERE id_oit = 6574), (SELECT rx_num FROM t_cmo_planilha_leitura WHERE id_xfc = 39517),...
asked by 19.04.2017 / 12:55
3
answers

Do not repeat records in a join

I have two tables: One with 1009 records and another with 11949. When I do a join, I have 11949 records, and the records in the 1009 records table are repeated several times. I need to do a select with join, but bring only the amount of records...
asked by 20.04.2017 / 22:19