Questions tagged as 'sql-server'

Tagged questions
1
answer

Declaration of 2 PK Sql

Good afternoon. I have the Icms table that has the IcmClaFiscal as the PK, I need to pass the IcmEmpresa column also as PK, but SQL returns me an alert. As I already managed to do this procedure in other cases through...
asked by 10.05.2017 / 19:07
1
answer

Bulk insert into a table

I have two proc's that my system in VB already uses. One for Insert and one for Update. I need to use it right now, right in the bank. The target table has a composite key as follows. A field named ID_OIT_LET and another field called ID_OIT. ID_...
asked by 20.04.2017 / 14:18
1
answer

Push notifications

I'm developing a program where multiple users will use, and would like to develop a system with Push notification, so when any user makes a Insert in the database. I would like it to be, for example, a pop-up of MSN .. Could...
asked by 11.04.2017 / 02:49
1
answer

Popular table in sql server with data coming from an excel spreadsheet

How do I create a script or via DTS , a way to populate a table in sql server 2014 , with information coming from a excel worksheet? The spreadsheet has several columns, but only two columns will be populated, and two other co...
asked by 18.04.2017 / 19:47
1
answer

Backup and Restore in Delphi with Sql Server how to do?

Hello, I'd like to know how I can do Backup and Restore to integrate with my system. I have a ready code but it is for firebird I believe it will not serve for Sql Server. I have read on some topics that there are no components for Backup and Re...
asked by 18.04.2017 / 16:39
1
answer

Error when restoring external application bank asp.net mvc

I am trying to restore a SQL database that I created in a provider that does not have the WebDeploy option. And my goal is to initialize a database using ASP.NET MVC with EntityFramework . Well, when setting the server and...
asked by 17.05.2017 / 01:59
1
answer

Changing a table

Is it possible to change a field in a table without losing the data that was previously entered? I have a table that has a varchar field and I need to change it to int . It already has data entered of type varchar .     
asked by 30.03.2017 / 12:38
1
answer

Select that does not return blank SQL

select 'TEM' AS InSituacao from GTCLogist where NrPlacaCarreta = '' and ID <> '35514' and year(DtBase)=year(GETDATE()) and MONTH(DtBase)=MONTH(GETDATE()) and DAY(DtBase)=DAY(GETDATE()) I have the above SQL, I need when the fiel...
asked by 17.04.2017 / 13:59
2
answers

Error 1 The type or namespace name 'DataReader' could not be found (are you missing a directive or an assembly reference?)

Good afternoon, I was performing a code to query my database when I encountered these errors: Error 1 The type or namespace name 'DataReader' could not be found (are you missing a directive or an assembly reference?) I know it's something sim...
asked by 07.04.2017 / 18:52
2
answers

sql inserts the wrong datetime into table [closed]

I'm using microsoft sql manager, and was trying to insert a date into my table, the problem is that it's inserting the wrong date, I make the following command for the manager's table INSERT INTO tblCliente /*minha tabela que eu criei*/ VALUES...
asked by 21.04.2017 / 22:08