Skip to main content

Posts

Showing posts with the label SQL

SQL Sever Datediff() Function to Show Date Difference in Days Hours Minutes

Introduction: Here I will explain datediff() function in SQL Server with example to get date difference in days hours minutes, years, month between two dates or calculate datediff in SQL Server in days hours minutes format. Description: In previous articles I written SQL query to get data between two characters range, Get table size in SQL Server, SQL Server reset identity column to 1 in
✔ Read More...
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to…

SQL Server Get Data between Two Characters Range Start with A to C

Introduction: Here I will explain how to get data between two characters range in SQL server or get user details start with A-C range in SQL server. Description: In previous articles I explained Acid Properties in SQL Server, Query to get database size in SQL Server, show time difference in minute ago hour ago etc in SQL Server, can function return multiple values in SQL Server and many
✔ Read More...
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to …

10 Easy Steps to a Complete Understanding of SQL

Too many programmers think SQL is a bit of a beast. It is one of the few declarative languages out there, and as such, behaves in an entirely different way from imperative, object-oriented, or even functional languages (although, some say that SQL is also somewhat functional).
✔ Read More...
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to

</ span>Articles,Computer Tutorials,Database,…

Understanding SQL Injection and Creating SQL Injection Proof ASP.NET Applications

As ASP.NET developers, we often write dynamic SQL to perform some database operations. These dynamic SQL is some cases might be created by concatenating strings with user input. If we are not validating the user input and taking every input as is, then this kind of scenario poses a very serious problem of SQL injection.

SQL injection is the attack in which the user of the website will input some SQL code as input which would result in creating a SQL statement that developers didn't intend to write. These SQL statements could result in unauthorized access, revealing secret user information and sometimes it could even wipe out the entire data lying on the server.

✔ Read More...


I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read …

Update Stored Proc with Raw SQL Query via EDF Framework

Update Stored Proc with Raw SQL Query via EDF Framework Introduction Today, in this article let's play around with one of the interesting and most useful concept in EDM Framework.   Question: What is update stored proc with raw SQL query via EDM framework? In simple terms "It provides flexibility to update data with help of raw [...]
✔ Read More...
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too. 
Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to
C#,.…

Delete Stored Proc with Raw SQL Query via EDF Framework

Delete Stored Proc with Raw SQL Query via EDF Framework Introduction Today, in this article let's play around with one of the interesting and most useful concept in EDM Framework.   Question: What is deleting stored proc data with raw SQL query via EDM framework? In simple terms "It provides flexibility to delete with help of raw [...]

✔ Read More...
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to
Art…

Self Join using Lambda

Self Join using Lambda

Self Join using Lambda Introduction Today, in this article let's play around with one of the interesting and most useful concept in LINQ.   Question: What isself join using lambda? In simple terms "It provides flexibility to perform join on single table and get the result set based on request query with lambda operation".   Step [...]
Read more of this post
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect pri…

Self Join using LINQ

Self Join using LINQ

Self Join using LINQ Introduction Today, in this article let's play around with one of the interesting and most useful concept in LINQ.   Question: What isself join using LINQ? In simple terms "It provides flexibility to perform join on single table and get the result set based on request query".   Step 1: Create a new [...]
Read more of this post
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This ar…

What are SQL Joins and How to use thses..

The first thing we learn to do with SQL is writing a SELECT statement to get data from one table. This kind of statement seems to be straightforward and very close to the language we speak.
But real-world queries are often much more sophisticated than those simple SELECT statements.
First of all, usually the data we need is split into several different tables. This is a natural consequence of data normalization, which is an essential feature of any well designed database model. And SQL gives you the power to put that data together.
In the past, DBAs and developers used to put all necessary tables and/or views in the FROM clause and then use theWHERE clause to define how the records from each table would combine with the other records. (To make this text a bit more readable, from now on, I will simplify things and say "table" instead of "table and/or view").
Read More...
I guess you came to this post by searching similar kind of issues in any of the search engine and hop…

Seeding your Metro style app with a SQLite database

It looks like people are really glad about being able to use SQLite within their Metro style apps. I had written two previous posts (Using SQLite in your Metro style app and HOWTO: Build and include SQLite) about this topic. I'm pleased to report that since those posts the SQLite team released a build (3.7.13 as of the datestamp on this post) which also provides the binary (32- and 64-bit versions) pre-compiled for you for inclusion in your Metro style app. You can get them from the SQLite download page.

I've received a few comments/questions that I thought I might clarify in my own opinion (and some facts) about using SQLite in your app.

Read More from: Original Source
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too. 

Stay tuned to my blogtwitter or facebook to read m…

Making Your Own MySQL Backup and Restore Tools in C#/VB.NET/ASP.NET - MySqlBackup.DLL (Supports Unicode, UTF8)

This article introduce a tool (DLL) that can backup/restore MySQL database in .NET Programming Language and some sample codes on how to use it. It is an alternative to MySqlDump.

On the other hand, this tool uses native .NET language to handle all values and parameters, therefore it can handle Unicode/UTF8 character (multi-language) well.

Another benefits of making this tool is, we don't have to rely on two small programs - MySqlDump.exe and MySql.exeto perform the backup and restore task. We will have better control on the output result.

This tool is develop in C# but useable in VB.NET.

The most common way to backup a MySQL Database is by using MySqlDump and MySQL Administrator.

MySQL Administrator is good for developers, but, when comes to client or end-user, the recommended way is to get every parameter preset and all they need to know is press the big button "Backup" and everything is done. Using MySQL Administrator as a backup tool is not a suitable solution for client o…

Introduction to NoSQL

For the past several decades, database professionals use a single standard supported by all databases: which is the Structured Query Language (SQL). We've relied upon the table-oriented relational database for all of our data storage and retrieval needs, without thinking about other alternatives. But now time is changing. The NoSQL database model tosses the relational model on its head by abandoning many deeply held beliefs about the "proper" structure for a database. In exchange for removing some of the design constraints, NoSQL databases can achieve enhanced performance flexibility.

Changing the Model

Relational databases have always relied upon some very hard-and-fast, structured rules that govern the conduct of database transactions. These are encoded in the ACID model and require that the database always preserve the some rules which are atomicity, consistency, isolation and durability of database transactions.  Any action that might violate the ACID model is expressl…

SQL Joins