Archive | Sci-tech

Once you have extracted the catalog item as XML, you can then leverage SQL Server’s built-in support for the XML data type and XQuery to further parse the XML. If you...

But if you’re using the “dark” theme in Visual Studio the Tangible T4 Editor needs a color change. Working with T4 templates can be a bit tedious. What’s T4 you ask? T...

In the above image we can’t even select multiple files. So, after the HTML5 equivalent update we can select multiple. Look at the animated image below. Now, let’s look at...

As of MySQL 5.5, there is RESIGNAL: “RESIGNAL passes on the error condition information that is available during execution of a condition handler within a compound state...

But SQLite does not support date arithmetic for this format. 2. Receive the current time as an integer SELECT strftime('%s',’now’) This query uses the function...

The settings of Machine.config file are applied to the whole asp.net applications on your server whereas the settings made in the Web.config file are applied to that part...

Here’s the screen shot that I took using Navicat Lite client and Sequel Pro . I did Googling a bit and I found that most common problem is because MySQL has too many ...

Consider following query: mysql> SELECT firstname FROM address; If you need unique firstname i.e remove duplicate contains type the command: mysql> SELECT DISTI...

The mouseover text has two hundred and forty-two characters. [edit] Explanation This comic is self-referential , because every graph is dependent on the whole comic....

With smplPDO, you can write fully functional database driven PHP apps with ZERO knowledge of SQL. // Very simple user authentication example with smplPDO.// init smplPD...

From discovering the best Snapchatters to consuming media content , we could pretty much stay on Snapchat all day without getting bored. And now with its latest update...

Well, for almost for years developing in C#, last month was the first time I ended up drawing graphs in an application I’m developing. After a couple of hours looking at ...

OBIEE 11g Setup and Full Development. ODI Oracle Data Integrator15 Years + – Oracle Discoverer 3i,4i,10g (Plus, Viewer, Desktop Admin) - PLSQL, SQL, Toad, Unix, SQL Devel...

As a result this first SQL INSERT statement will work: insert into projects (project_type, name, description) values ('APPLICATION', 'ACME - Phase 1', 'ACME Project, Ph...

It's because of these sales that people like me have built vast gaming libraries with hundreds of titles. Thanks to Valve's new sharing features, which the company unve...

This is probably the easiest way to make an ASP.NET MVC 3 project work as a web role. Just right-click on the MVC project and choose “Add Deployable Dependencies.” Then c...

Virtual Full Backups and Recovery Point Archiving The R1Soft CDP Server uses proprietary Disk Safe technology to archive hourly, daily, weekly, or monthly disk-based MyS...

There are not any native GUIs available (to my knowledge), I’ve found that getting TDS up and running is a pain, and it seems impossible to import a.bak or ms sql insert ...

Additionally, issues posted here will not be addressed. This project was created to address the problem of maintaining database changes within an actively developed PHP...

Each method should use the OS’s default locking mechanism, no fake proprietary garbage here. Additionally, you should be able to use any kind of device that will connect ...

By calling Response.Write() directly you are bypassing the normal rendering mechanism of ASP.NET controls. The bits you write are going straight out to the client without...

To implement mail concept in asp.net first we need to add following reference to our application System.Web.Mail namespace What is System.Web.Mail System.Web.Mail ...

The problem? SQL injection. Most of the tutorials I saw had code that looked something like this: NSString* unsafeSqlString = [NSString stringWithFormat: @"UPDATE rec...

I didn’t want to go through and configure params for each entity, hence I created a custom implementation of an Id-generator and added some conventionbased configuration ...

In a series circuit, a common pathway exists for all the items that are connected in series. This will mean that the amount of current passing through each item is the sa...

Choose your Operating System: Windows 8.1 Windows 8.0 Windows Vista & 7 1. On the Start screen type Bluetooth Settings and press Enter 2. 8. Your comput...

I don’t want a tonne of hidden fields in my form in order to get a complete entity that I can post to my controller, when all I need to delete a record is it’s primary ke...

By Terrence Dorsey Confession time: I have a bit of an obsession with code editor fonts, themes and syntax highlighting. So my interest was piqued recently when I came...

Read more about SQLite in-memory databases here . Data Source=:memory:;Version=3;New=True; Data Source=c:\mydb.db;Version=3;UseUTF16Encoding=True; Data Source=c:\...

This gives the ability to prepend and append most any text to various input fields, with the result something like the following: In the above image there are both prepe...

Lesson 2: Elephants Elements of SQL In this lesson, you'll begin learning SQL, the Structured Query Language used by most relational databases. You'll learn about the s...

This article helps you to mitigate any conflicts and allows your migrations to stand as-are. I cover a bit of background, but you can jump to the end to see two or thre...

While databases vary in what functions and features they offer a good reporting tool will know the difference. Actually, we've just completed a quick-start package for ap...

It also sniffs ICQ/ AIM/JABBER/YAHOO/MSN/GADU-GADU/IRC and MRA protocols. It has a built-in arp poisoning module, can change MAC addresses of LAN adapters, and has variou...