Questions tagged as 'sql'

0
answers

Problems with data node.js (SQL Data)

I'm having a question regarding receiving SQL data in an array in JavaScript. I have the login information and everything else, regarding the server, but the issue is not the connection, it's saving the data in an array. Example: nameArray [user...
asked by 16.02.2018 / 17:43
0
answers

return json c # .net core sql

I am testing with a console application . In it I query the database and would like to return a json file from the result. Is it possible to return the query json without instantiating the object? how can I do this? I tried converti...
asked by 16.02.2018 / 20:19
0
answers

How do I insert money type from the view using numero with comma?

I need to enter values for the view that are values with a comma Inside my Model I have the property public decimal Preco { get; set; } But when I try to insert the view, I get the following error: Heisonlysavingvalueswithoutacomma,a...
asked by 20.02.2018 / 01:59
2
answers

Migrate EXTRACT (YEAR_MONTH, data) from MySQL to SQL Server

I have a MySQL query that I would need to convert to SQL Server. I tried with datepart of SQL Server but it does not maintain the main feature of the MySQL query, which is to maintain the month-to-month range but also to take into acco...
asked by 20.02.2018 / 03:15
1
answer

Store SQL data in a javascript Array

I have a question regarding the receipt of SQL data in a Javascript array. I have the login information and everything else, regarding the server, but the issue is not the connection, it's saving the data in an array. Example: nameArray [usernam...
asked by 16.02.2018 / 17:02
1
answer

Why were the views slow after migrating the data via script in Firebird 2.5?

I'm working on a standardized database. I recently refacted her (A) structure by renaming all existing PKs and FKs, because they had the names that are automatically generated. When migrating data from another base (B) to this refactor (A), I'm...
asked by 28.02.2018 / 22:07
1
answer

Find table field with query result from a different table?

I recently asked a question: search for last 24h lines that repeat the most (MySQL) And it was answered, I now have another question. I do the following to find from and to of the most repeated lines of the last 24h, but th...
asked by 22.02.2018 / 03:38
1
answer

Mysql Database (Insert Into and correct order)

My question may sound silly, but is it something I always miss, how to know the correct order of insert into the database? I was told that it is by foreign keys, but I did not understand logic the insert was in that order: post  crew...
asked by 13.02.2018 / 23:00
1
answer

database backup

I looked at some tutorials here on the site, but I did not find one that fits with what I'm looking for, so I followed this tutorial Backup & Restore Sql Server database in C # It even has a link in the comments with the codes already r...
asked by 13.02.2018 / 03:51
2
answers

Query sql SELECT

What command select shows me only those comments from a single user? For example: I have a Post table where you store the comments of each user (user_1, user_2, user_3), but would like to show only user_1 comments. Comments t...
asked by 13.02.2018 / 13:33