List/Grid
Tag Archives: SQL
OpenRowSet – SQL Server
some times its required connect to a different source like some external access file or Excel file from SQL server. To accomplish this task we can use SSIS or .NET… Read more
CLR integration in SQL Server
Sometimes writing some code in C# is very easy as compared to SQL. Examples are recursion, handling datetime functionality like day light saving and many more. So for that we… Read more
Coalesce – SQL Server
Consider we have a table structure as given below declare @Temp table ( col1 int, col2 int, col3 int) then we insert some values in the table above insert into… Read more
