Questions tagged as 'sql'

2
answers

What does the ^ = operator mean in C #?

I have a function in C #, where I decrypt a string and need to convert to a function in SQL Server for technicians to be able to work with the decrypted value. There is a foreach , which I do not understand how it works: var calculoChave...
asked by 27.01.2015 / 13:32
3
answers

Java and Offline Databases

I need a help with database in Java. I want to make a database that the program generates a file, such as "database.db" and this file I can access without needing any internet connection, using only the mentioned file. How do I do this? Wh...
asked by 19.08.2014 / 22:18
4
answers

Login in PHP with permission levels

I have a problem with my code to separate the logins. I want when a login with Rank = 1 is entered it redirects to a page, and when Rank is = 0 go to another page. I tried to do but I did not have a result because he always...
asked by 18.04.2014 / 12:25
1
answer

What does COLLATE LATIN1_GENERAL_CS_AI do?

I'm asking this question because I came across this
asked by 02.06.2017 / 20:20
1
answer

What are the differences between utf8 and utf8mb4?

When importing my mysql database into a windows server after I created it on a local server (xampp), I could not import the script I exported from the database into the server. So I decided to copy the table scripts per table, and I noticed that...
asked by 22.04.2016 / 21:14
3
answers

Use VARCHAR (255) for all fields or choose the best size for each field? [duplicate]

Assuming the following fields (for example): Nome , Rua , Cidade , UF . The Nome would be the name of the client. There are people with 2 short names or people with 5 or more names, so it is possible to have a...
asked by 07.05.2018 / 02:11
4
answers

What's the difference between LIKE, IN and BETWEEN in MySQL?

I'm doubtful about the difference and use of the LIKE , IN and BETWEEN tags in MySQL. When should I use the tags and example?     
asked by 13.11.2017 / 15:27
1
answer

What is the difference between "ON" and "USING"?

Considering two ways to declare a INNER JOIN , we have: SELECT * FROM tabela1 INNER JOIN tabela2 ON tabela1.cd_tabela1 = tabela2.cd_tabela1; and SELECT * FROM tabela1 INNER JOIN tabela2 USING(cd_tabela1); What's the difference be...
asked by 01.10.2014 / 02:51
5
answers

Physical Exclusion vs. Logical Exclusion

Is it a common practice? Is it safe?    Derived from: Physical Vs. logical / soft delete of database record?     
asked by 24.03.2014 / 13:46
5
answers

Is it recommended to use Linq instead of SQL?

To avoid string abuse and avoid code injection problems it may be a good practice to use Linq . I can also imagine, for example, that it be slower. Who has used Linq to communicate with database, would you recommend it?     
asked by 14.12.2013 / 23:31