Questions tagged as 'sql-server'

Tagged questions
1
answer

Search with stored procedure

Good morning classmates I have a stored procedure to search by code and it works fine but I would like to know if there is a way that by searching for example the 1.5 in addition to looking for those with the 1.5 also drag the record with code 1...
asked by 05.07.2017 / 15:24
2
answers

List all databases that contain a specific table

I want to list all the databases of a given server Sql Server (2008 or higher) that contain a certain table. I have seen several examples from cursors, stored procedures that run through the server databases to the use of sp_msforeachdb, which i...
asked by 22.02.2017 / 13:27
1
answer

Problem when creating a job in SQL Server

Consulta I hope you can help me. I told you to create a JOB in SQL SERVER 2012 but within that JOB I created 3 steps as the image: what happens when I want to save I get that error:     
asked by 08.03.2017 / 18:50
1
answer

INNER JOIN in Update

I am migrating an Access query to SQL Server, the problem is that in Access it allows to perform INNER JOIN in the UPDATE UPDATE (Aux_Nodos INNER JOIN Nodos_NULL_Titular ON Aux_Nodos.Necesidad = Nodos_NULL_Titular.Necesidad) INNER JOIN Out_Arc...
asked by 13.02.2017 / 16:38
3
answers

Group SQL SERVER records using Distinct and Case

I am trying to perform the grouping of records of two tables using the following query: select distinct detrec.iddestino, --sum(DetRec.NoBulto) as [Número de Bultos], sum(DetRec.Peso) as [Peso], case when enrec.OrigenEnvios=detrec.iddestin...
asked by 19.01.2017 / 15:24
2
answers

snackbar with database,

I want to show a snackbar with data obtained through a database, the problem is that the snackbar is not shown, I will leave the code that I am using: edit: delete the code and this is the current one map.setOnMarkerClickListener(new Google...
asked by 13.12.2016 / 04:08
1
answer

SQL Server 2008 R2 do Update in different Like

Many of us already know that (Like '% search%') serves us in sql server to search for keywords in this opportunity I have to do this: UPDATE Table SET a.ItemID = 1000, a.type = 1, a.typeID = 0 FROM PS_GameData.dbo.CharItems a INNER JOIN PS_Gam...
asked by 05.01.2017 / 15:05
1
answer

Extract date as String Sqlserver C #

When I run a query on sql server from C # the fields of the date type are extracted as Date(1445580000000) when formatted in JSON. Although in the query specify the CONVERT to do so in yyyy-mm-dd , the same thing happened to m...
asked by 27.10.2016 / 01:28
3
answers

Make Select in all columns except in 2 specific [duplicate]

I have the colunnas mapa, numero, mob1, mob2, mob3, mob4 asi hasta el mob400 In sql I want to do something like say this SELECT * NOT IN(Mapa, numero) FROM Tabla WHERE mapa = 1 can it be done that only the columns are not shown witho...
asked by 16.11.2016 / 02:48
2
answers

CREATE DATABASE permission denied in database 'master'

Good afternoon everyone. I'm having trouble creating a database. Since I get the error    CREATE DATABASE permission denied in database 'master' Since the SuperUser (sa) I have given permission to the user "Lucas" with db_owner so he can...
asked by 02.11.2016 / 20:45