SQL Query how to select entry by char count?

by Evgelen 12. December 2009 21:55

SELECT * FROM TableName WHERE len(ColumnName) > 100

8de05fe4-59e1-417a-b891-5c48f2b195ce|1|5.0

How to attach the SQL Database and Log file using SQL Query?

by Evgelen 13. November 2009 22:40


sp_attach_db @dbName = 'DataBase',
@filename1 = 'C:\folder\Database.mdf', 
@filename2 ='C:\folder\Database_log.ldf'

733dde86-35a7-4fca-a30a-7bed2568ef10|1|5.0