Browse through various articles and courses for Free at DeveloperPublish.com

    Get Started
    HomePosts tagged “tips”Page 5

    tips

    Showing 81 - 100 of 329 results

    How to fill Blank Cells with a specific value in Microsoft Excel 2016?

    There are times when you have to fill the blank cells within your worksheet in Microsoft Excel 2016 with the...
    Read more

    Changing the background color of a cell based on value in Microsoft Excel 2016

    This blog post will explain how the users can change the background color of a cell based on its value...
    Read more

    Useful Keyboard shortcuts in Microsoft Excel 2016 that you must know – Part 1

    There are plenty of shortcut keys available in Microsoft Excel that lets you to do few repeated tasks quickly. In...
    Read more

    C# 7.0 : Pattern Matching

    In one of the previous blog post , we saw the Out variables enhancements in C# 7.0. This blog post...
    Read more

    How to Display the Current Date in a Cell in Microsoft Excel ?

    Microsoft Excel 2016 provides the functions =TODAY() and =NOW() which displays the current date in a cell in Excel sheet....
    Read more

    C# 7.0 : Out Variables enhancements

    In C# , we can use the out parameters to get the behavior of the call by reference. In the...
    Read more

    Dealing with the column names that looks like SQL Keywords in SQL Server

    There are times when you might have a column names in your SQL Server database table that might looks like...
    Read more

    Using DebuggerDisplay attribute in C#

    DebuggerDisplay attribute class in C# lets the developer control on how an object or property needs to be displayed in...
    Read more

    How to check for the column name in an SqlDataReader Object in C# ?

    When working in ADO.NET for data access , there are times when you want to check to see if a...
    Read more

    How to return the column names from a table in SQL Server ?

    You can easily return all the column names of a table in SQL Server 2008 using the sp_columns stored procedure....
    Read more

    SQL Server’s ISNULL() equivalent in PostgreSQL

    SQL Server provides an function ISNULL if the value placed in the 2nd parameter if the first parameter passed to...
    Read more

    Quick way to search within a procedure in SQL Server

    There are times when you want to to list out all the stored procedure names that contains certain keyword or...
    Read more

    How to insert a picture into a comment box in Microsoft Excel?

    This blog post will explain how to add or insert picture (image) to the comment box in Microsoft Excel 2016....
    • Excel
    • September 2, 2016
    Read more

    How to View Named Ranges in Microsoft Excel ?

    Named range is a very useful feature in Excel especially when you work with lot of formulas but there are...
    • Excel
    • September 1, 2016
    Read more

    How to view the code of a stored procedure using a Query in SQL Server ?

    Here’s a quick tips on viewing the code of a stored procedure in SQL Management Studio. One of the quickest...
    Read more

    Print a text N number of times in SQL Management Studio

    When working with SQL Management studio , you might need to display a string N number of times , in...
    Read more

    How to get day of a week in SQL Server ?

    Assume that you have a date “01/09/2016” and you would like to find out what day of the week it...
    Read more

    How to replace NULL values with alternate values in SQL Server ?

    Assume a scenario where you are trying to get the records from the table where some of the records contains...
    Read more

    WAITFOR TIME in SQL Server

    If you want to pause the execution of the code block until a specific time is reached , you can...
    Read more

    How to check if the table exists in a database in SQL Server ?

    To check if the table exists in a database in SQL Server , you can use the INFORMATION_SCHEMA view. How...
    Read more

    Categories

    Archives
    Tags
    c# C# Compiler Errors C# Programs C++ examples C programs csharp DB2 Errors Delphi Errors Download Excel Excel 2016 Excel Automation excel functions excel tips excel tutorials Excel VBA Functions in Excel how to HPE NonStop SQL/MX Java examples Microsoft Microsoft Excel MS Office MySQL Errors Oracle Errors Outlook Errors PolarDB for PostgreSQL Python examples python programs SQL Server SQL Server Errors Sybase Error Message tips tricks troubleshoot Visual Studio Visual Studio 2012 Win32 Windows 11 Windows 11 tutorials Windows BSOD Errors windows phone windows phone 8 Windows Store wp8