Yes, it will work as long as you can afford taking the original DB offline for a few moments. quote: Will detatch/attach keep the original database? Will the following steps work? 1.Detatch database 2.Make a copy of the detached database file 3.Attach both files: one to the original db, one to the new db
2003-07-29
2 reads
The way I prefer for this is to use a CASE statement, e.g.: SELECT Sum(Case When Column > 5 Then 1 Else 0 End) As GreaterThan5, Sum(Case When Column < 5 Then 1 Else 0 End) As LessThan5 FROM MyTable You could also do it as two nested select statements: SELECT (Select Count(*) From Table1 […]
2003-07-29
1 reads
SELECT column, COUNT(*) FROM table1 WHERE column > 5 GROUP BY column HAVING COUNT(*) < 5 I think this is what you meant...
2003-07-29
1 reads
In T-SQL: BACKUP LOG dbname WITH TRUNCATE_ONLY Replace dbname with the database name. -SQLBill
2003-07-28
this is for a text field. the 3rd argument needs to represent a multiple length string and up untill this point I thought % would do this. example: SUBSTRING(FIELD,3,%) 'should return the following: CR20AB = 20AB CR509FDS = 509FDS
2003-07-28
Is the job ENABLED? Usually when the next run date says what you posted, then it means the job is not enabled. -SQLBill
2003-07-28
No problem. I guess I have a bit of a prejudice against cursors in stored procedures...
2003-07-25
Backup and restore is one option. Detach/attach is another one but it will disconnect your original database. If the DB is not huge, backup/restore will do it.
2003-07-25
Diferential backups, take the changes since the last full backup. Once you made a diff backup, all the other differential backups you made, are useless. You should backup the full backup to a backup device with init, and backups all the diff backups to a diferent device also with init, to reduce disk space
2003-07-24
If you want a single row at a time you can do this: declare @string varchar(255), @col1_value varchar(25) set @string = '' set @col1_value = 'A' select @string = @string + col2 + ' ' from table_1 where col1 = @col1_value print @string If you want multiple rows, you might want to put the code […]
2003-07-24
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers