Sql Server - Find and Replace a value across all tables in database
Find and Replace a value across all tables in database
In my project I faced this problem due to typing mistakes....
2016-08-31
550 reads
Find and Replace a value across all tables in database
In my project I faced this problem due to typing mistakes....
2016-08-31
550 reads
Monitoring the Performance of All Stored Procedures
Every Project suffer from this problem, over the time they
have developed many stored procedure...
2016-08-31
442 reads
Monitoring the Performance of All Stored Procedures
Every Project suffer from this problem, over the time they
have developed many stored procedure...
2016-08-31
571 reads
Index Utilization Report
One day my manager came and told me that he need Index Utilization Report.
He felt that during...
2016-08-29
552 reads
1. Tell me about yourself.
Answer - Give summary of your past education and work, skills, and achievements and include your strong...
2016-03-27
133 reads
Interview is a three stage process. Before => Interview => After
A. Before Interview -
1. Most important, ready your Resume/CV. Be confident about...
2016-03-26
148 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