Most voted "ddl" questions
4 questions
Sort by count of
-
8
votes5
answers6773
viewsSeparate ddd from phone with SQL statement
I have a table with fields DDD and Phone. Some were registered correctly, others the ddd is next to the phone and need to separate. TABLE +--------------------+ | DDD | Telefone |…
-
3
votes1
answer974
viewsSQL SERVER myth about SELECT INTO and tempdb locks
I’ve been studying a lot lately about databases and everything. Today, performing a routine check on the processes of the SQL Server instance verified that an instruction that was running in one…
-
1
votes1
answer4041
viewsHow to select all tables containing the field with the same name?
I need to search all fields "id_category" in a given database, and bring a list of the tables that contain this field in common, which in this case is the foreign key of the table "sis_category".…
-
0
votes0
answers8
viewsMysql 5.6.12 - How to create date field with current default value
I am creating a table that has a separate date and time field (yes, the two separate fields), and in these I want the default value to be the current date/time. I tried to create the field with…