Questions tagged as 'ddl'

5
answers

Separate ddd from phone with SQL statement

I have a table with DDD and Phone fields. Some have been registered correctly, others ddd is next to the phone and I need to separate. TABLE +--------------------+ | DDD | Telefone | +--------------------+ | 47 | 89876543...
asked by 10.12.2015 / 16:29
1
answer

SQL SERVER Myth about SELECT INTO and locks on tempdb

Lately I've been studying a lot about database and everything. Today, performing a routine check on the processes of the instance of SQL Server verified that a statement that was running in one database was blocking execution in another database...
asked by 09.04.2018 / 19:33
1
answer

How to select all the tables that contain the field with the same name?

I need to look up all the "id_category" fields in a particular database, and bring up a list of tables that contain this field in common, which in this case is the foreign key of the "sis_category" table.     
asked by 08.04.2016 / 21:36