Tags » Table (database)

How to strip double quotes while importing data from CSV or TSV using SSMS Import Data wizard OR SSIS?

Long Title! Let me explain. This post will help you solve following problem if you run into it:

1) You are using SSMS Import data wizard to load data from a comma (or tab) separated value (CSV/TSV) file into SQL Server Table & you find that your source data values has double quotes and so you want to strip them before loading to destination table. 121 more words

Microsoft Business Intelligence

An analogy between family systems and computer systems analysis

An ecomap is equivalent to a system diagram utilized in the software development industry.  What a system diagram does is allow an analyst to define relationships between objects.  499 more words

Recovery

SQL Commands

The standard SQL commands to interact with relational databases are CREATE, SELECT, INSERT, UPDATE, DELETE and DROP. These commands can be classified into groups based on their nature: 89 more words

SQL/ORACLE

Learn SQL Fundamentals in 20 Easy Days

Hello Bloggers !!

Today I am going to start a learning session for all of you. Here you will be able to learn basic SQL fundamentals in 20 easy days. 62 more words

SQL/ORACLE

Relational Databases for Dummies

Web apps can be split into two major components: a front-end that displays and collects information, and a back-end for storing the information. In this article, I’ll demonstrate what a relational database is, and how to properly design your database to store your app’s information. 3,033 more words

Canvas Code

Using C# to interface with SQLite

If you need to interface with SQLite there are a couple of steps.

1) You need to get the .net provider for SQLite from sourceforge.net… 886 more words

SQL

DATABASE OBJECTS

What Are Database Objects?

There are many different types of database objects that can be created in the Oracle RDBMS. The exam looks at eight of those objects in great detail. 393 more words

SQL - 1Z0-051