Questions tagged as 'sql-server-2012'

Good morning! I have a question, I need to perform a cascade search with a string in the following 5 scenarios:    Scenario1: string = 'value1 value2 value3 value4 value5'   Scenario2: string = 'value1 value2 value3 value4' Scenario3:   ...

I have a problem with SQL SERVER 2012, the inconvenience is that when I open it, it sends me an error that tells me that it stopped working as if some process was working, the strange thing is that it was working and from nothing it started to t...

In my Procedure a dynamic query is executed (use PIVOT ) where the last columns are dynamic, so when I want to create the view I have tried to use Openquery and OPENROWSET but always shows the same message.    You...

I have the following query in SQL where I am getting the Incidents of the employees in a report, this by the Date From and Date Until, in that period I must show the total number of Incidents (Fouls, permits, holidays) what it has, with what I h...

I have a web app, which needs to connect to a bd sql server. This is achieved through the typical definition determined in conecctionstring in app.config. I need to be able to have a list of connectionstrmgs (definitions) in order to be able to...

I have the following query SELECT IdOcupacion, Codigo, Descripcion FROM Ocupaciones On which in the field of Descripcion I see several double registers and I would like to know how to consult only one of the registers but bring me th...