SQL Server - Jeff Widmer's Blog

Browse by Tags

ISO 3166-1 Country Data SQL Script: I am creating a standard sign up form with one of the fields being a country drop down. So I created my Country database table and then needed to fill it with information. I found the ISO list of countries here , but then the issue was how to get that...
Posted 09 November 2009 09:15 PM by Jeff Widmer | with no comments
Filed under: SQL Server, SQL Script, SQL, ISO Country Codes

osql.exe and unicode files – how to save your sql scripts with encoding: osql.exe is a great application for running sql scripts in a batch. I use a batch file to execute multiple sql scripts that I use to rebuild my current application database from scratch. When developing a brand new application, deploying a...
Posted 14 October 2009 09:43 AM by Jeff Widmer | 2 comment(s)
Filed under: SQL Server, Visual Studio, Tips & Tricks, osql.exe, Unicode encoding

How to Reseed a SQL Server Identity Column: In SQL Server you can specify a column as an Identity column (ColumnName int IDENTITY(1,1) NOT NULL) to have SQL Server automatically set the value of this column upon insert by incrementing a seed value. This works great but I have run into situations...
Posted 15 September 2009 10:39 PM by Jeff Widmer | with no comments
Filed under: SQL Server

nvarchar(max) parameters need the size set to -1: SQL Server 2005 supports a new data type nvarchar(max). This is one of the new max datatypes that are to replace ntext, text, and image in a future version of SQL Server (according to SQL Server Books Online) but you should start using them now. I recently...
Posted 15 August 2008 05:00 PM by Jeff Widmer | 8 comment(s)
Filed under: SQL Server, .NET, ASP.NET, C#, Visual Basic

SQL 2000 Books Online January 2004 Update: There is an update of the SQL Server 2000 Books Online documentation at http://www.microsoft.com/downloads/details.aspx?FamilyId=A6F79CB1-A420-445F-8A4B-BD77A7DA194B&displaylang=en I highly recommend SQL BOL as an excellent reference for any developer...
Posted 13 February 2004 10:56 AM by Jeff Widmer | with no comments
Filed under: SQL Server