Blog

Search results for: T-SQL

SQL Yoga – Read XML with T-SQL statement in SQL SERVER

03-May-2013

SQL Yoga – Read XML with T-SQL statement in SQL SERVER

In my previous post, “XML Result sets with SQL Server”, we review to generate result sets in XML from SQL server. Then I got a comment from the team, to also have post to read XML in SQL Server.

SQLYoga – XML Result sets with SQL Server

14-May-2013

SQLYoga – XML Result sets with SQL Server

Recently, found that people making much complex code to have an XML in application. I have found that they return result set in Table to the application and have applied code to convert that data table to XML by Asp. Net application. When I review the process, I have suggested that why don’t you use the XML feature of the application. They surprised the simple use of it and make their life easy. Let me have sample query to generate XML result sets in SQL Server database.

SQL SERVER: T-SQL to find out when database was restored

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

SQL SERVER: Find executing queries

23-Aug-2010

SQL SERVER: Find executing queries

Recently my company owner reported that SQL SERVER is running slow. I searched for it and get following T-SQL query. SQL SERVER provides dynamic views, which contains current information about all details.

SQL SERVER: How to Add Computed Column

09-Dec-2008

SQL SERVER: How to Add Computed Column

Today I came across scenario where I need to add one computed column. Computed column means we can manipulate one or more column from the same table and we can use this column in queries as regular column.

SQL SERVER: How to Read Excel file by TSQL

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.

28-Dec-2009

SQL SERVER: How to remove cursor

Many times developer ask me that How can they remove Cursor?
 

Community TechDays at Ahmedabad - Great Event

09-Oct-2009

Community TechDays at Ahmedabad - Great Event

There was a great event held by Microsoft and PASS (Professional Association of SQL Server) in Ahmedabad on 3rd October 2009. This was very big event where 250+ attendees attend the excellent session of Vinod KumarPinal DaveJacob Sebastian and Prabhjot Singh Bakshi. There were Four technical sessions by these excellent speakers.

22-Jul-2009

SQL SERVER: Reset Setup Values, when SQL SERVER is started/restarted

We have a requirements to clear all setup values when SQL SERVER is started/restarted and we need to setup default values to setup table.