Questions tagged as 'sql-server'

Tagged questions
1
answer

Show data in texbox c #, edit and update?

This time I bring a little problem that is stinging me. It's about that I have a form of a web solution in c # with asp.net that I want to edit. The data I want to edit is a table called User made in Sql Server. The data of a particular user...
asked by 16.04.2018 / 22:25
3
answers

Erroneous connection of Android with SQLServer

I am starting to program a small project in Android Studio. I want to make a query to the base, in case the connection fails it gives me a message in a Toast: Network error IDException: failed to connect to /ANDRESPC\SQLEXPRESS (port 1433): co...
asked by 20.09.2017 / 05:12
1
answer

Roles, Permissions asp.net c # sql server

Good, I would like you to help me, I'm doing programming language asp.net c # and sql server roles and user permissions: I have these following tables in Sql Server: Table Roles ID_Roles Rol_Cargo Rol_Estado 1 ADMINIST...
asked by 29.08.2017 / 22:08
3
answers

Perform Search between dates. Sql Server

Good afternoon, I'm doing a simple query of a logical in db2 that is numeric but contains dates of the following format 20170831, but when doing the query with both 'between' with the operators '> = < =' brings all the existing dates....
asked by 31.08.2017 / 21:09
1
answer

SHOW MAX, MIN of several columns sql 2008

select nombre,Company,isnull([4],0) as 'ABRIL',isnull([2],0) as 'FEBRERO',isnull([9],0) as 'SETIEMBRE', 'TOTAL' = (isnull([4],0)+isnull([2],0)+isnull([9],0)),PROMEDIO = ((isnull([4],0)+isnull([2],0)+isnull([9],0)))/3, 'MAXIMO' = (CASE WHEN isnull...
asked by 13.02.2018 / 16:16
1
answer

How to migrate a SQLServer 2012 database to MySQL?

I need to perform the migration of a SQLServer 2012 Database to MySQL for this I tried the information in this post: link But it only works for SQLServer 2008. Then I tried OpenDBCopy link Then try to do what is indicated in t...
asked by 21.07.2017 / 02:32
3
answers

Show values within a range

I have the following SQL code: SELECT (CAST(DATEDIFF(dd,Fecha_Nacimiento,GETDATE())/365.25 as int)) Edad FROM Clientes Which gives me back the age, what I want to do is to be able to visualize in a query the age range, that is, a table wit...
asked by 11.09.2017 / 23:29
2
answers

Error calling a T-SQL function

I have created a function with Transact-SQL that after the ISBN of a book returns 1 (if it exists) or 0 (if it does not exist), but calling the function gives me an error. The code: CREATE FUNCTION fn_llibre_ok (@isbn varchar(13)) returns bit...
asked by 12.06.2017 / 11:53
3
answers

How to open a sql Server connection in C #?

Well my problem is that I want to open a sql server connection so I can make a query BD and get a possible result either erroneous or successful. Code of my method to authenticate users: public string Autentificar() { string sql = @"SE...
asked by 24.03.2017 / 22:50
1
answer

Floating point error when obtaining the result of two high negative numbers in SQL Server

I want to perform the following operation SELECT POWER(-0.616666,-1.6441441441441) but it returns the following error Msg 3623, Level 16, State 1, Line 3 An invalid floating point operation occurred. I already tried to cast both number...
asked by 05.03.2018 / 20:42