Kjetil's Hjemmeside
  • Hjem
  • Hobby
  • Data
    • SQL
    • Programmering
  • Meg
  • Kontakt meg

SQL Server developers factsheet

Details
Written by: Super User
Category: SQL
Published: 15 November 2012
Hits: 3168

SQL Server developers factsheet

Lock modes: shared, exclusive

Details
Written by: Super User
Category: SQL
Published: 13 November 2012
Hits: 3375

Read more: Lock modes: shared, exclusive

Access Tutorials

Details
Written by: Super User
Category: SQL
Published: 10 November 2012
Hits: 3339

Kom over en nettside med en god del tutorials for access:

http://www.599cd.com/tips/access/?key=ALZ

MySQL

Details
Written by: Super User
Category: SQL
Published: 14 October 2012
Hits: 3817

For å slette flere tabeller med lik prefiks kjør denne SQL spørringen:

SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' )
    AS statement FROM information_schema.tables
    WHERE table_name LIKE 'prefiks_%';

Når den er kjørt, kjører du en ny SQL spørring med utfallet fra forige spørring.

Copyright © 2023 Kjetil's Hjemmeside. All Rights Reserved.
Joomla! is Free Software released under the GNU General Public License.