Whenever we want to loop something we always look for logic like WHILE LOOP or FOR LOOP. Trust me on my word that both of them are cursor when it is about SQL Server.
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)
Just received question from one of the DBA Question: I do not have full backup of my database. My .mdf and .ldf are corrupted. Is there any way I can restore database now? Answer: Sorry. I do not think there is any way you can do it. Try attaching this…
Read MoreSQL SERVER – Popular Articles of SQLAuthority Blog
I receive this email quite often that which are most popular articles on my blog. There is already list on right navigation bar of my weekly popular article. If you are interested to know which are most popular articles as per readers and my opinion here are two listed. SQL…
Read More
SQL SERVER – How to Escape Single Quotes – Fix: Error: 105 Unclosed quotation mark after the character string
Jr. Developer asked me other day how to escape single quote?
User can escape single quote using two single quotes (NOT double quote).
SQL SERVER – Introduction to Aggregate Functions
Recently I have been taking many interviews to increase work force in my companies outsourcing establishment. One question I ask to all interview candidates. What is Aggregate Function? So far I have received two different kind of response. First, I do not know. Second, AVG, SUM, COUNT are aggregate functions.…
Read More
SQL SERVER – Export Data From SQL Server to Microsoft Excel Datasheet
Question: How to Export Data From SQL Server to Microsoft Excel Datasheet?
SQL SERVER – Download Frequently Asked Generic Interview Questions
Yesterday I posted article about SQL SERVER – Most Frequently Asked Generic Interview Questions. I always enjoy when I receive emails and comments about my article. Many readers have asked me to write more about this, I suggest that my readers help me here and add their suggestion and answers…
Read More