Menu
Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
Here is a quick way to find all currently blocked requests in SQL: SELECTSESSION_ID,STATUS,BLOCKING_SESSION_ID,WAIT_TYPE,WAIT_TIME,WAIT_RESOURCE,TRANSACTION_IDFROM sys.dm_exec_requestsWHERE STATUS = N’suspended’;GO
The HTML tag creates an inline frame, used to embed another document into your current HTML page. This element is great because you can include content such as advertising banners,
Want to cycle through all the items you put in the clipboard in Visual Studio? Just press the CTRL/Shift/V keys together to cycle through them. When you cycle through, and
Assuming there are tables EMP and EMP2, which have the same schema, and there are possible duplicate IDs present in them???the following query will help us identify the unique records:
To see the history of pages you have recently visited, you just have to “long” press the back button (left arrow) in your browser. Just click and hold and you
You can use the dm_exec_function_stats (in SQL Server 2016) to check detailed execution details of a function. These include: execution_count – the number of times this function has been executedlast_execution_time
If you want to insert a static background image on your website, you can do this by adding attributes to the labels in the HTML code. If you apply the
There are times in which we need to suppress some errors that are not impacting what we currently are working on. In MySQL, we may want to suppress an error
There are times in which we need to suppress some errors that are not impacting what we currently are working on. In MySQL, we may want to suppress an error
Many times, when we open the last saved document, it takes a while to recollect what we were editing on the saved last. Word offers a shortcut to take you
Pozitiv – ?????? ???????????????????????????? ????????????????, ?????????????? ???????????????? ???????????? ?????????????????? ???????????????????? ?????????????????? ?? ??????????????????, ?????????????? ?????? ???? ?????????????? ?????? ??????????????! ????????: http://workle.website/74
Often, we have to do a string comparison by ignoring the case, or the results end up being wrong. The StringComparison enum provides the “ordinalignorecase” member that allows you to
Deleting data in a database can a very dangerous operation in the wrong hands. Sometimes you are too busy to really concentrate fully; or sometimes you have given the wrong
Thetag specifies text tracks for media elements (and ). You can use theattribute to add subtitles to any video or audio element. Web Video Text Tracks Format (WebVTT) is a
There are numerous cases in which you get null and are not able to handle it effectively in the code. MySQL has a command that can help you know if
The getCustomValue() method on the enum returns the custom value associated. You can use this mechanism when you want to override the default ordinal with a custom ordinal. Code snippet public
SQL Server usually presents an error on an attempt to insert more data into a field than it can hold. It typically throws an error message similar to the following:
This simple feature allows us to autofocus the chosen items when loading the page and it specifies that the element automatically focuses when the page is loaded. The autofocus attribute
There are many ways for a DBA to increase performance and you may want to use some of them in your code. For example, you may want to list all
The notification area has lots of icons that we don’t use. And it is, at times, a cumbersome process to locate the appropriate icon that we need. However, it is
In Node.js, we can pick and choose from a lot of modules that make sending email easier. One of the most commonly used modules is “nodemailer.” Check out the sample
In case you are wondering, yes, there is a different way to transpose columns into rows than making use of a PIVOT structure. However, it is quite a lot of
In HTML, all included elements can be made editable. To do this, we can use the contenteditable attribute. Here’s an example where the user can modify the content: Contenteditable Now the
Word allows you to navigate through hyperlinks when you use the ctrl+click combination, You can turn this default behaviour off, and navigate by just hovering on the link and clicking it. To disable, please go to File – Options and then choose Advanced- Editing options. Disable the checkbox next to ???Use Ctrl + Click to follow hyperlink???
If you are using windows and Microsoft applications like Work and Excel, you can easily repeat your last executed action with a keyboard shortcut. All you have to is press the F4 key. For e.g. if you have marked the text in bold, or adding a new line in a table or any other actions, all you have to do to repeat that action is press the F4 key and the respective actions will repeat.
Getting the attention of a user is easily achieved in Java with the following code. Listing 1. public class Beep{ public static void main(String args[]) { Beep beep = new
One of the ways to bind filtered data to an element is by using the filter module in AngularJS. See below for an easy example that filters a collection of
You may want to know the temp location in your environment to use it for some purpose during the execution of the program. Here is the code to help. public
A very common task is to backup a table’s data, but sometimes we’d just like to copy a table’s structure. This quick tip will demonstrate how to copy a table’s
SQL 2016’s RLS Feature allows you to implement restrictions on data row access. You can use this business rule manager to enforce rules that are difficult to achieve through the
