Best answeres tagged with sql-server

1

answer

Error when calling the report

I have an error below, when I call a report, which has a query in the database, I can not resolve it. Takealookattheresultyouhavenothingwithzero Followthecode:SELECTSD.D2_DOC,SA.A1_NREDUZ,SB.B1_DESC,m.nm_mes,SD.D2_QUANT,SD.D2_PRCVEN,(SD.D2_C...

asked by 12.04.2017 / 14:18

2

answers

View Not Upgradable in SQL Server

asked by 12.04.2017 / 18:55

1

answer

Update an Access application

What is the easiest way to upgrade a desktop Access application with VBA to a web application with sql server?

asked by 22.04.2017 / 00:58

2

answers

Bring the count of the word "DATA" of a calculated column in SQL Server

Good morning, I have a query that brings in a calculated column the information of "Data" and "Historicos", in this column I have the Prefix of the item (vehicle license plate) and the column with its calculation. I need to change this query so...

asked by 07.07.2017 / 20:29

1

answer

Default structure of a SQL Server procedure [closed]

I have a structure template, I would like to know if it is suitable for a good standard. USE [teste] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> --...

asked by 04.05.2017 / 16:22

1

answer

How to do a select in C # using database / Sql-Server?

In a previous question, I needed to do a select by a specific date: How to do a select by date in C #? Now I need to make a select that brings records whose date is within a specific week or month. How should I proceed?

asked by 06.04.2017 / 12:05

1

answer

Generate empty line (null) in sql server

I do not know much about sql, but I need to do the following: User informs a number. Sql generates the amount entered by the user of blank / null records. After generating the blank records, execute an sql query. In the last item the...

asked by 06.04.2017 / 17:33

2

answers

Return the shortest date within the Select

I have the following table: CREATE TABLE [dbo].[Crm_man]( [id] [int] IDENTITY(1,1) NOT NULL, [nCRM] [int] NULL, [cliente_CRM] [int] NULL, [item_CRM] [int] NULL, [qnt_CRM] [int] NULL, [descri_CRM] [varchar](max) NULL, [descri_NF] [varchar](max)...

asked by 12.05.2017 / 18:59

1

answer

How to troubleshoot "3183" error when importing a database in SQLSERVER 2012

Good afternoon! To begin with, I warn you that I am a layman. I need to run a local bank on my machine to work on a project. I installed the programs: SQLSERVER Express 2012 SQL Management Studio 2012 I use a Macbook Pro and squeeze a Win7...

asked by 02.03.2017 / 17:10

1

answer

Create select to return last time something was different from zero

I have a table called Estoque , where it has the columns NOME_PRODUTO , DATA , among others. The idea is that when I make a SELECT Using the date as a parameter, all the products that were in stock on that day are return...

asked by 21.02.2017 / 01:55

Questions tagged as 'sql-server'