SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
77 reads
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
77 reads
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
1,436 reads
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
239 reads
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
80 reads
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
4,311 reads
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
403 reads
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
133 reads
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
1,251 reads
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
219 reads
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
106 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers