Metadata queries are really helpful in discovering information for a given database schema. Database information including the tables, views, columns names, data types, indexes, and table constraints are all available using queries such as these.
The CASE expression is used to compare one expression with a set of expressions in SQL. The result of the CASE expression is a Boolean value, true or false. We can use various DML statements like INSERT, SELECT, DELETE and UPDATE with a CASE statement. In this Tech-Recipes tutorial, we will see how to use a CASE expression with UPDATE statements.
Frequently, when working with SQL, we need to know if a file exists in a local directory or not. This can be done using SQL Server’s built-in procedure known as master.dbo.xp_fileexist. This user-defined function (UDF) checks whether or not a file exists in a specified directory.
The replicate T-SQL function in Microsoft’s SQL Server makes it simple to add leading zeros to a number value.
When modifying an important table in the database, user frequently backup the table by making a copy of the original table with a different name. Using a stored procedure makes this process simple and convenient to reuse.
One of the benefits of Dropbox is that it allows you to restore items that you may have deleted from your computer’s Dropbox folder. Dropbox stores these items on its servers so that you can go to its website and restore them if you need to. If you have files that you want to permanently delete, you need to do more than just simply remove them from your computer.
The Startup folder has been in Windows since its beginning. It allows the user to select applications to automatically launch during the Windows initiation process. However, in Windows 8 finding and using the Startup folder can be difficult.
By default, the Maps app on Windows Phone requires an active internet connection to work because the data is not stored locally on the phone. To be able to use the phone offline, which is useful when the mobile signal is weak or when you want to save battery, you can choose to download a number of maps to your device.
When working with NULL values, it’s important how you deal with NULL records in your database. This example walks through and explains how to sort and separate NULL and non-NULL values. This example should work with all database types including MySQL, MS SQL, and postgreSQL.
If we have a trigger and want to prevent it from running, we can either delete the trigger or disable it temporarily. With the trigger disabled, it will not function. We have three ways to enable/disable a trigger in SQL Server by using a graphical option or by using a query editor.
If you are annoyed by repeatedly receiving notifications of a conversation or by a person on Google Hangouts, you can turn off the notices and block the person.
If Internet Explorer will only let you save an image file as a bitmap, here is how to fix it.
1...271272273...528Page 272 of 528
error: Content is protected !!
