SQL Parser by Microsoft SQL Server for C#

Please check below article, https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.sqlparser.parser.parseresult(v=sql.120).aspx Sample code. using Microsoft.SqlServer.Management.SqlParser.Parser; ParseResult pr = Parser.Parse(@”Select * from Config where ID in (Select top 10 ID from Config order by ID desc)”); You will find Assembly “Microsoft.SqlServer.Management.SqlParser.dll” in GAC (Assembly Folder)

Back to WordPress

Hello friends, I started thus blog to gather information and share my knowledge which i research. After finish 1st year i stop posting but i am getting good comments from you guys which finally inspire me to spend some time daily to update this blog. Hope you enjoy my work and give me valuable feedback

Integrating Microsoft Dynamics AX 2012 with SAP for Expense Management

Learn how Microsoft standardized on one solution, globally, for employee expense management. In this webcast, we describe how integrating Microsoft Dynamics AX 2012 with SAP for expense management achieved greater policy enforcement, improved flexibility to react to changing business conditions, and reduced long term maintenance costs while enabling future business capabilities. Click to view the

Sql custom sort apply on varchar column

Recently I got an simple question called need to short a column which is varchar values but not in alphabetical order. Scenario is : A customer table with Id, name, address, rank. Rank column contains values ‘very good’ , ‘very bad’ , ‘good’ , and ‘bad’. We need to sort rank column in such manner

Integrating Microsoft Dynamics AX 2012 with SAP for Expense Management

Learn how Microsoft standardized on one solution, globally, for employee expense management. In this webcast, we describe how integrating Microsoft Dynamics AX 2012 with SAP for expense management achieved greater policy enforcement, improved flexibility to react to changing business conditions, and reduced long term maintenance costs while enabling future business capabilities. Click to view the

GridView: Creating groups and summaries with 2 lines of code

GridView has a lot of improvements over the DataGrid but it still lacks some very important features. A recurring requirement not available in the GridView is to create groups and summaries. To create summaries we can easily code the RowDataBound event. Grouping is a more complex task, and involves more coding and debugging. But when