Search results for: SQL Developer
29-Oct-2012
SQL SERVER: T-SQL to find out when database was restored
Recently, we have found that our testing database has been restored on the server and we lost our recent work. We have to identify that at what time the database has been restored, so we can know that what are the changes need to be restored again on the database
15-Mar-2010
SQL SERVER: Execute Stored Procedure when SQL SERVER is started
We have a requirements to execute Stored Procedure when SQL SERVER is started/restarted and we need to start some processes. I found that SQL SERVER provides a way to call Stored Procedure when SQL services are restarted.
28-Dec-2009
SQL SERVER: How to remove cursor
Many times developer ask me that How can they remove Cursor?
23-Dec-2009
SQL SERVER: How to Read Excel file by TSQL
Many times developers asked that, they want to import data from Excel file.
