SQL Server Personal FAQs
How to find Duplicates in a Table? References: How to find where an SQLServer Object is referenced? You can use the sys.sp_depends: Thanks to: David R Tribble. References:
S.d.O. Servizi di Organizzazione
Blog su programmazione ed organizzazione.
Tag: SQL
MySQL – How to group values from multiple rows in one field
There are situations in which we would like to group values of multiple rows in just one field. Consider this little example in which we have three tables (cars, colors and link table) and we would like to have a query with all the cars in the first column, and all the colors in which…