Geeks With Blogs
Fórmulas e Cenas Object Reference Not Set to an Instance of an Object October 2012 Entries
How to restore a database using multiple transation log files (sql server 2000)
Restoring a database can be a pain in the ass, specially when you need to find some point in time where the data went wrong.This is the best way i know how:RESTORE DATABASE MY_TARGET_DATABASE FROM DISK = 'path_to_backup.bak' WITH NORECOVERY, replaceGORESTORE LOG MY_TARGET_DATABASE FROM DISK = 'mytransaction_log1.trn' WITH NORECOVERYGORESTORE LOG MY_TARGET_DATABASE FROM DISK = 'mytransaction_log2.trn' WITH NORECOVERYgoRESTORE LOG MY_TARGET_DATABASE FROM DISK = 'mytransaction_log3.trn' WITH NORECOVERYgoRESTORE ......

Posted On Monday, October 22, 2012 11:18 AM

How to select distinct rows from a DataTable
DataView view = new DataView(table);DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...); Source: http://stackoverflow.com/qu... ......

Posted On Tuesday, October 2, 2012 11:53 AM

Copyright © Sglima | Powered by: GeeksWithBlogs.net | Join free