Questions tagged as 'sql-server'

Tagged questions
1
answer

Divide date range in weeks

It would have some simple way of extracting the weeks given a range of dates, for example: start date: 07/01/2017 end date: 7/30/2017 Given the dates above how could you automate the extraction of the weeks contained in this range? E...
asked by 20.07.2017 / 18:12
1
answer

How to export data from R directly to the sql server?

Friends, I consumed a web service with R and now I need to export this data directly to the sql server. How do I?     
asked by 28.07.2017 / 17:57
1
answer

Error connecting to the database [WinForm / C # / SQL Server]

My C # course teacher taught a new technique for us today, one need not tell ConnectionString itself, the program would go to the documents folder and get the .mdf file (SQL Server) and open the connection with it, but I have the following error...
asked by 20.07.2017 / 01:08
0
answers

How to make multiple mask replaces per T-SQL table field

I'm doing replaces of some texts (Mask) of a field of a temporary table. I'm replacing where text is searched for by a field from other tables. Example: SELECT TOP 1000 * INTO #TEMP_COMPL_L FROM TB_CONTRATO WHERE IDCAR_CON = 1 ALTER TABLE #...
asked by 13.07.2017 / 17:56
1
answer

Create a database backup that is in the azure

I would like to back up a database that is in Azure. I tried to back up by Microsoft SQL Server Management Studio, but the backup option does not appear. I tried to backup through the Azure portal but did not have the option.     
asked by 16.07.2017 / 18:22
0
answers

Problem with trigger change

I have a table that receives data all the time, almost every second. This table has a trigger that after insertion of a new row inserts this record into another table. I need to include a new trigger in the same table and I have some question...
asked by 05.06.2017 / 16:47
1
answer

Limit and Offset for web paging in SQL Server

I'm working with PHP and I have about 8000 records currently in DB. As it is for a web page, I need to make a pagination to be viable reading the data. As I understand it, I have to do something similar to limit and offset to...
asked by 28.11.2016 / 13:35
1
answer

Group data from a Query?

I do a GROUP BY in a query result and the result comes like this: Iwouldliketoknowifitispossibletobringgroupedinthisway? I'd like to know if this collation is best done in PHP or Query and how can it be done? Follow my code: SQL...
asked by 22.05.2017 / 18:22
0
answers

Generate grid with multiple records [closed]

Good morning, I need to make a grid where I need to say exactly the value of each line based on a column of a table in the bank, I need help because I have never done anything like this. It is an ASP.NET MVC web application using SQL Server a...
asked by 27.06.2017 / 16:03
3
answers

Doubt SQL Query Business Days

Good evening! Well, I need to know the following result. I want to bring the workdays grouped by month and year from April to June of this year of 2017. Example: Ano Mês Dias Uteis 2017 Abril 19 2017 Maio 18 2017 Junho...
asked by 01.07.2017 / 04:12