How to populate a database table with text from a file

Learn about loading text from a file into a database table on my latest blog post on SQL read text from a file at my programming interviews blog (Direct link: http://www.programminginterviews.info/2013/03/sql-read-text-from-file.html )

0

SQL self join or sub-query interview question (employee-manager salary)

One of my favorite interview questions that tips even seasoned SQL guys (maybe because it’s too simple) is around querying data that involves a self join. Question: Given an Employee table which has 3 fields – Id (Primary key), Salary and Manager Id, where manager id is the id of the employee that manages the…

10

Programming interview questions with answers covering ASP.NET, jQuery, JAVA, SQL, LINQ, Entity Framework and Regular Expressions

Having a bit of time in the last few weeks, I managed to hammer out some more detailed posts on my programming interview series blog. Here is the table of contents for easy reference: Introduction Introduction to technical interviewing Technical Interview Process – 30,000 feet overview So, what can be asked in a programming interview?…

22

Programming Interview Questions on C++, ASP.NET, C#, SQL and LINQ

  Reached a milestone today on my quest to make better interview questions with answers. Here is the latest list of programming interview questions on my Programming Interviews Series blog. Introduction Introduction to technical interviewing Technical Interview Process – 30,000 feet overview So, what can be asked in a programming interview? Beyond the Code Beginners…

13

SQL IF-ELSE and WHILE examples

Check out my latest post on SQL IF-ELSE and WHILE examples as part of SQL programming interview questions on my Programming Interviews Series blog.

0

SQL CASE statement examples

Continuing on my trek to flesh out more on SQL interview questions and answers, i just finished a post on SQL CASE statement examples on my Programming Interviews Series blog.

0

SQL GROUP BY and HAVING clauses

Continuing with SQL interview questions, please check out my second SQL post on SQL GROUP BY and HAVING clauses on my Programming Interviews Series blog.

0

SQL Select Where Interview Questions

Turning my focus on SQL interview questions, please check out my first of many posts on SQL Select Where Interview Questions on my Programming Interviews Series blog.

1

Bulk Insert into SQL from C# App

One of the common problems I have seen is to bulk upload data to a SQL Server database. If you have the flexibility to directly run your code in SQL, you have a ton of options. But let’s say that you have to massage the data before you throw it in to the database, then…

11