Tag: tips
How to get the first day of the month in SQL Server ?
If you want to get the first day of the month of a input datetime variable from a SQL Query , here’s how you do it.
How to Declare and Define an Boolean data type variable in F# ?
How to Declare and Define an Boolean data type variable in F# ?
Exit the Current Scope with a return value in SQL Server
You can use the RETURN statement to discontinue the execution of a T-SQL batch statement or a stored procedure and provide a status code or value on return. For example , you want to display the Employees whose MaritalStatus is Divorced. You want to return a value -1 to indicate that no records exist and also You do not want the SQL Statements following it…
How to find all instances of a pattern in JavaScript ?
To find out out all the instances of a pattern in JavaScript , you can use the regular expression as showb below. How to find all instances of a pattern in JavaScript ?
How to escape a single quote in SQL Server ?
You can escape a single quote in your T-SQL query in SQL Server by simply doubling them. Here’s a simple example that demonstrates how the single quote ie escaped in SQL Server. How to escape a single quote in SQL Server ?
How to add new user account from command line in Windows 10 ?
You can add a new user account in Windows 10 using command prompt using the net user command and passing the right parameter. How to add new user account from command line in Windows 10 ? Following is the syntax of the command to add a new user from command line in Windows. net user <username> <password> /ADD For example , to add a new…
How to know what toolbar does in Microsoft PowerPoint 2013?
If you want to know what a toolbar does in Microsoft PowerPoint 2013, simply mouse over or point your point on the toolbar, a tooltip will pop up and displays the necessary information on what exactly the toolbar does. How to know what toolbar does in Microsoft PowerPoint 2013?
How to convert number to text in Excel?
In Microsoft Excel 2016 , there are times when you don’t want the numbers present in the cell to be participating in the calculation. This means , you can either update the formula to not include the cell value or else change the number to text. How to convert number to text in Microsoft Excel 2016? You can use the TEXT function in Excel to…
How to Detect Windows Phone OS version using C#?
The Windows Phone SDK provides the Environment.OSVersion property which can be used to detect the version of the Operating System uses in Windows Phone (Windows Phone 8 / Windows Phone 7). Below is a code snippet that demonstrates how to detect the Windows Phone OS Version using C#. How to Detect Windows Phone OS version using C#?
How to Check if all elements in array are alphabets in JavaScript ?
JavaScript provides the every() method defined in the Array object which lets the developers to check and validate the contents of the array in JavaScript. How to Check if all elements in array are alphabets in JavaScript ? Below is a sample code snippet demonstrating the usage of the every() method to find out if all the elements in the array are alphabets. Note that…
What is the equivalent of MySQL’s Now() function in SQL Server ?
MySQL has the function Now() which is a Datetime type field which shows the current date as well as the time. What is the equivalent of MySQL’s Now() function in SQL Server ? In SQL Server , you can use the GetDate() function to achieve the same.
How to change the ‘Edit Top 200 Rows’ in SQL Management Studio ?
When working with the SQL Server Management Studio and trying to edit the table records , you would have noticed the context menu option “Edit Top 200 Rows”. How do you change this to display all the records for editing instead of “Edit top 200 rows” in the context menu ? There are couple of ways in which you can do it. 1. Right click…
Recent Stories
-
AI Reliability Architecture (ReAct, Guardrails, HITL) youtube.com
-
The Future of Software Architecture: Role of an Architect in... youtube.com
-
Stop using Event-Driven Architecture for your CRUD apps youtube.com
-
Improve .NET MAUI’s AppThemeBinding? (Matt Lacey) mrlacey.com
-
How to Create 80+ WPF Chart Types (Greg Lutz) developer.mescius.com