Questions tagged as 'sql-server-2008'

Tagged questions
0
answers

Error copying database in SQL Server 2008

I'm trying to copy a database to the same server but I'm encountering the error below:    Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.       The Execution method succeeded, but the number of errors raised (1)   reached the maximum allowed (1...
asked by 11.04.2017 / 20:08
1
answer

Doubt with date and time in sql server

I have a field in the bank of type "char", I am returning the dates this way: select CONVERT(VARCHAR(20),HORA_FECHAMENTO) as HORA_FECHAMENTO, CONVERT(VARCHAR(20), DATEADD(hour, +0, getdate()), 120) as HORA_ATUAL from TB_ESTRACAO wh...
asked by 28.01.2017 / 04:14
1
answer

Visual Basic 6.0

Hello, I'm new to this language. I am creating a student enrollment form with SQL Server 2008 and .ADO connection. When inserting and saving the registration data, the register button inserted two repeated lines. Here is the code for the sign...
asked by 16.08.2016 / 15:26
0
answers

Splitting Duplicates in a Subreport - MSSQL / Crystal Reports

I would like to generate a PIS and COFINS tax forecast report, which is calculated based on a CFOP code of the notes issued in a given period, but would like to separate this information in "blocks" / p> I expect the result this way: +------...
asked by 24.02.2015 / 21:07
0
answers

Querying Active Directory data in Sql Server

I have services (WCF) that do searches in Active Directory to provide data to many applications that use Microsoft Membership Provider, and also need some of this information in some queries in a Sql Server 2008 database, I generated a dll and I...
asked by 16.12.2014 / 16:25
2
answers

Save photo to the database and then display it

I have an application to register students where the photo will be inserted, I want to save it and then display it, however I have a save button where I want to save all the information inserted plus the photo as shown below: SqlConnection con...
asked by 09.11.2018 / 00:51
2
answers

Search for elements with a certain distance of time (only reporting the time)

Detail sqlserver (2008) Good night, I have the following problem. I tried searching all day and found nothing. -I need to find elements in a same table that have the same date (day, time ...) and a time distance of at most 40 seconds from one to...
asked by 09.11.2018 / 22:08
2
answers

Arithmetic overflow error converting expression to data type int in count

I've seen several answers about this message    Arithmetic overflow error converting expression to data type int. However, everything they indicated did not work. It only gives error when I use count . Code: SELECT COUNT(D...
asked by 09.01.2017 / 17:44
1
answer

Error opening connection to a SQL Server 2008 R2 database

I have a problem opening a connection to a local database in SQL Server 2008 R2. The opening method that is giving error is as follows: public static SqlConnection AbreConexao() { string path = System.IO.Directory.GetCurrentDirectory();...
asked by 14.12.2016 / 20:35