Best answeres tagged with sql-server

1

answer

How to import records file in asp.net mvc with entity framework [closed]

I would like to ask a question and I do not know how to structure my need .. I need to import / export a file with records, and depending on each record will be from a different table with their references and etc. What file formats is right?...

asked by 17.11.2017 / 19:07

1

answer

Query all sql tables

Good evening I'm starting in the career of developer and I'm creating an application that le an xml file. I'm having trouble passing a command in sql database that returns all tables and their attributes (column and values). Thank you ...

asked by 07.11.2017 / 22:54

1

answer

Access SQL Server Express remotely on Google Cloud Platform

I have a server in GCP and everything is working properly (IIS, SQL Server ...). But I'd like to remotely access a database that is on that server. I've already done this: link I have already created the rule in the GCP firewall as well...

asked by 07.11.2017 / 22:17

0

answers

Data Flow Task: Processes, but does not write to the Database

I am using SQL Server Integration Services (SSIS) with SQL Server Data Tools (graphical component for Visual Studio 2015). Within my processing package (SSIS) I have streams that, depending on the defined condition, the respective Data Flow T...

asked by 28.11.2017 / 19:45

0

answers

How to use more than one DataSet in a single table in Reporting Services

Good afternoon, I'd like a big help, I'm trying to use two DataSets within a single table in Reporting Services. Can anyone tell me if there is any way to do such an action?

asked by 26.10.2017 / 17:23

1

answer

java error in connection with SQL Server

I am trying to connect to a sql server database, but I am not succeeding. Here is the connection class and test method: public class ConexaoBanco { public static final String user = "sa"; public static final String pswd = "**********"...

asked by 03.11.2017 / 18:36

1

answer

MSSQL How to find out which table a record was included or modified

Is there a way to find out via query which table in a database has changed Update or Insert?

asked by 14.10.2017 / 18:20

0

answers

How to implement an exception using "IF AND ELSE" in a Sql Server query

I have a query that lists all the databases, tables, highway, and dates. only in the query it returns me an error in the completion pq inside the field where all the tables are stored, there are tables that do not have a specific column. I'm try...

asked by 13.10.2017 / 16:39

1

answer

Linked SQL Server and FireBird: Error 'Must declare the scalar variable'

I made a linked of my SQLSERVER with FIREBIRD . But at the time I pass a variable inside the query to return the record amount I get the error: Message 137, Level 15, State 1, Line 1 Must declare the scalar variable "@QtdR...

asked by 11.10.2017 / 03:49

2

answers

How can I query the last deleted database procedure

Is it possible to check which was the last procedure deleted in the database? If so, how can I do this? The goal is to rebuild it.

asked by 06.10.2017 / 19:33

Questions tagged as 'sql-server'