SQL BlogsDecember 2, 2010by Rudy4 min7,531

Importing Data into SQL Server – Using the Import Export Wizard

Today begins the series on importing data into SQL Server 2005/2008 using the various built in tools. With SQL Server, there are several ways of getting your data from one place to another. Today, we will focus on using the wizard from SQL Server Management Studio. Before we begin, I am using a simple database called testdb. I am also using a country code file found at http://www.andrewpatton.com/countrylist.html. The file contains the 2 and 3 character ISO 3166 Country Code abbreviations, which we will use in our sample. The CSV file as seen in Excel 2007 Here is the script … Continue reading Importing Data into SQL Server – Using the Import Export Wizard

SQL BlogsDecember 2, 2010by Rudy1 min711

Storing Computed Columns in SQL Server

From time to time you will run into a case where you need to store computed columns in your SQL Server tables. Examples of computed columns include taxes on a sale or business days between several dates. Setting up computed columns in SQL Server 2008 is fairly simple. You simply give the column a name and then specify your calculation instead of giving a datatype. You could even use a case statement instead of functions and calculations. Here is an example of a table that calculates days between 2 dates.

<span style="color: #0000ff;">CREATE TABLE</span> dbo.DateDiffTable
	(
	RowID <span style="color: #0000ff;">int</span> NOT NULL <span style="color: #0000ff;">IDENTITY</span> (1, 1),
	DateStart <span style="color: #0000ff;">smalldatetime</span> NOT NULL,
	DateFinish <span style="color: #0000ff;">smalldatetime</span> NOT NULL,
	DateDiffs  <span style="color: #0000ff;">AS</span> <span style="color: #ff00ff;">datediff</span>(DD,DateStart,DateFinish)
 NOT NULL	)
<span style="color: #0000ff;">GO</span>

CREATE TABLE dbo.DateDiffTable

(

RowID int NOT NULL IDENTITY (1, 1),

DateStart smalldatetime NOT NULL,

DateFinish smalldatetime NOT NULL,

DateDiffs AS datediff(DD,DateStart,DateFinish)

NOT NULL )

GO

The sample table has an ID, 2 dates and … Continue reading Storing Computed Columns in SQL Server

WindowsJanuary 12, 2018by Rudy1 min4,883

Could not install the custom actions

Learn how to fix the error “Could not install the custom actions” message Continue reading Could not install the custom actions

ASP.NETJanuary 12, 2018by Rudy1 min793

Javascript to Toggle Items

There are times when you will want to hide an item on a web page and activate the item only when the user clicks on an element. You can use a small bit of Javascript to display or hide the … Continue reading Javascript to Toggle Items

SQL BlogsJanuary 12, 2018by Rudy1 min1,168

View All Permissions for Objects in SQL Server 2008

There are times when you need to audit user permissions to ensure that things aren’t getting inserted, over-written, or deleted. I looked around and found this script which uses several sys objects, which gives us most of the information we … Continue reading View All Permissions for Objects in SQL Server 2008

SQL BlogsJanuary 11, 2018by Rudy1 min1,779

Overwrite files in a DTS using ActiveX

Several of my DTS jobs require processing a file and then archiving the file. As we all know, you can use ActiveX to Copy or Move a file. Problem is, sometimes we need to reprocess or reuse a file name. … Continue reading Overwrite files in a DTS using ActiveX

SQL BlogsJanuary 11, 2018by Rudy3 min1,387

Delete old DTS packages in SQL Server 2008

Learn how to delete DTS packges using TSQL Continue reading Delete old DTS packages in SQL Server 2008

Rudy Rodarte . com

Follow Rudy as he programs, travels and designs.