I need to change an existing column in a table so that it has the identity property using T-SQL and then insert data into this table. The column already contains data and after this insertion, I must again change this column by disabling...
Open-source databases such as MySQL and Postgres are so advanced that they can handle a wide variety of applications without problems, perhaps most. (There's SQLite too, but this is more for when portability is essential.)
But for business ap...
Well, I have a method that I query on my bank and compare with a List<Carros> . My intention is, for each item that contains both in my query, and in my List<Carros> , I remove the item from my List<Carros> ....
I'm developing an application that will be used by multiple clients simultaneously, I'd like to use Day, Month, Year, Hour, Minute, Second and Millisecond as id and / that the : function returns?
What can be the maximum size that a table can have? To be clearer: a table in MySQL, what is the maximum size it supports? And in SQL Server, Oracle, PostgreSQL?
By query , how can I get the disk space that the tables (in a database) are occupying?
I can list all tables using sys.tables , but what about size?
SELECT NAME AS NomeTabela FROM sys.tables
I would like to list all the tables in my database that end with a specific name and also all my databases that match those tables. I tried to do but it does not return anything to me.
Query
SELECT da.name AS BANCOS,ta.name as TABELAS
FROM...
What would be the SQL (SQLSERVER) that could extract the difference between two dates (the largest being the current system date) with Years, Months, and Days output?
I need to run the query below in PHP with SQL Server, however I can not use the LIMIT clause missing in Microsoft queries .
$SqlTabelaAtual="SELECT *
FROM BusinessCadTabPreco
RIGHT JOIN BusinessCadTabPrecoItem ON B...