Posts Tagged “sql”
Moving Databasefiles
by Rainer Bendig on March 20, 2010
If you want to move your databasefiles on a Microsoft SQL 2000, 2005 or 2008 server, you can use the following steps: (Optional) You should first backup your database, and then your current database files. (Optional) Get a list of all files… Read more
Zufällige Zeile aus Datenbank lesen
by Rainer Bendig on January 24, 2010
Da ich immer wieder drüber stolpere: Eine zufällige Zeile liest man mit MySQL wie folgt: SELECT * FROM table ORDER BY RAND() LIMIT 1 Für Microsoft SQL Server verwendet man SELECT TOP 1 * FROM table ORDER BY NEWID() Arbeitet man mit… Read more