SQL – Page 2 – Tech Talk

January 11, 2012

Nested Case Statements in SQL

Need to do nested Case statements in SQL? Use the following syntax. This should result in ‘a1b1 – yar’ This took me a little time to work out the syntax, but pretty simple once I understood case statements a little better. For some more info on case statements, you can go to the msdn article located at http://msdn.microsoft.com/en-us/library/ms181765.aspx

SQL/Tips and Tricks Comments: 0

January 9, 2012

Using Transactions in the Entity Framework (EF4)

You have multiple updates and want to implement transactions into your database updates in the Entity Framework? I had to do just that in C# , so I thought I’d share what I learn for to remember, and for you to learn. To do this, we must create a TransactionScope, and move around our save function a little bit in...

C#/SQL/Tips and Tricks Comments: 0

December 2, 2011

Automated Backups of Your SQL Database

Ever find yourself taking precious time and backing up all your databases, only to forget and be behind? I am currently working on some Alpha-PreAlpha software whose database structure changes with time like any other application. To solve the issue with remembering to back up however, I decided to automate it, and not have to worry. There probably is a...

General Tips/SQL/Tips and Tricks Comments: 0

August 29, 2011

How to Add, Modify, Rename, and Delete a Column in SQL

There has been a few times where I needed to compose a script to update a customer’s database, and I’ve had to use probably the most popular of the SQL ALTER TABLE syntax: Add, Modify, Rename, and Drop. To help save for my own notes and to possibly give some help, I thought I’d write a quick article on these 4...

Development/SQL/Tips and Tricks Comments: 0

May 18, 2011

Delete or Truncate All Data in a Database

A quick tip for you all, ever need to delete or truncate all the data from a database? There has been a few times during testing after my database grew, that I needed a quick solution to clear a database. The solution is using the MSForEachTable stored procedure. Simply do the following : DatabaseName – The name of the database you...

SQL/Tips and Tricks Comments: 0

May 16, 2011

Specify Your Own Select And Edit Top(n) in SQL Server Management Studio

When right clicking a table in SQL Server Management Studio, you have an array of options. Probably the two that I use most however is the “Select Top 1000 Rows” and the “Edit Top 200 Rows”. However, sometimes you want to look at a little more than that. I know most of the time I want to select all from...

SQL/Tips and Tricks Comments: 0

March 23, 2011

Fixing A Blue Filled Checkbox in .Net

If you ever seen the above check mark, you are probably wondering what the heck is going on. First off it’s not checked or checked, some in between state where it’s just filled with a blue square. Second off you even, most likely, have a variable bound to it, and yet it still displays as this! The issue is that the...

C#/SQL Comments: 0

March 15, 2011

Drop, Truncate, and Delete : The Difference

If you wanted to get rid of all the data in a table, then you could you either of the three. However there are certain situations which using a different one of these is the best route to go.

SQL Comments: 0

March 14, 2011

Create a Filestream In SQL Server 2008 In Three Easy Steps

Step 1 : Enable FileStream The first step is to enable the filestream capabilities on your SQL Server instance. This can be found by going to your server properties in your SQL Server Configuration Manager and enabling the filestream there. Microsft explains how here. Step 2 : Creating a FileStream Database The following script will create a filestream database for...

SQL Comments: 0

March 11, 2011

Do a Like Statement in LINQ in C#

There has been a few times I needed to do a like statement in LINQ, but didn’t know exactly how to go about it. Just in case there are you out there looking for the same, I thought I would post what I did. For example, say you had this SQL statement : This would translate to LINQ code in...

C#/SQL/WPF Comments: 0

February 2, 2011

Quick Newbie SQL Tips

I go back and forth with different versions of SQL which at times will require different syntax. I started using primarily SQL Server 2008 R2 so I needed an update on some certain functions. To help me remember and to save you some time, here they are. Adding Multiple Colums There has been a few times where I needed to...

SQL Comments: 0

January 19, 2011

Building The Perfect SQL Script. Part 1 of N

Introduction Im going to start off by saying I am by no means an expert in SQL. I am however on the road to increase my skills and work towards more efficient and cleaner SQL code. With that said, Im going to start an on going series of posts which I will post from time to time which include tips...

SQL Comments: 0

Like this:

Like this:

Like this:

Like this:

Like this:

Like this:

Like this:

Like this:

Like this:

Like this:

Like this:

Like this:

Tech Talk

Category: SQL

Nested Case Statements in SQL

Using Transactions in the Entity Framework (EF4)

Automated Backups of Your SQL Database

How to Add, Modify, Rename, and Delete a Column in SQL

Delete or Truncate All Data in a Database

Specify Your Own Select And Edit Top(n) in SQL Server Management Studio

Fixing A Blue Filled Checkbox in .Net

Drop, Truncate, and Delete : The Difference

Create a Filestream In SQL Server 2008 In Three Easy Steps

Do a Like Statement in LINQ in C#

Quick Newbie SQL Tips

Building The Perfect SQL Script. Part 1 of N

Category: SQL

Nested Case Statements in SQL

Share this:

Like this:

Using Transactions in the Entity Framework (EF4)

Share this:

Like this:

Automated Backups of Your SQL Database

Share this:

Like this:

How to Add, Modify, Rename, and Delete a Column in SQL

Share this:

Like this:

Delete or Truncate All Data in a Database

Share this:

Like this:

Specify Your Own Select And Edit Top(n) in SQL Server Management Studio

Share this:

Like this:

Fixing A Blue Filled Checkbox in .Net

Share this:

Like this:

Drop, Truncate, and Delete : The Difference

Share this:

Like this:

Create a Filestream In SQL Server 2008 In Three Easy Steps

Share this:

Like this:

Do a Like Statement in LINQ in C#

Share this:

Like this:

Quick Newbie SQL Tips

Share this:

Like this:

Building The Perfect SQL Script. Part 1 of N

Share this:

Like this: