if you add a drop columns from a table, the column_id is dropped with it; then when you add additional columns, the next column_id is used.

so if you drop column...

here you go:

GeoProject.zip

this was the product of an afternoon of too much time on my hands...i was surfing Wiki looking at planets when they renamed Pluto to a planetoid, and...

i'd say your table's attempts column was not initialized to zero, but instead has nulls:

select @NewAttempts = hua.attempts + 1 from hub_user_auth as hua

where hua.id = @UserID

would probably be better...

ok i found an old project i was screwing around with, let me know if you want it;

it's a suite of tables, all inter related with FK's and all that,...

here's one i use regularly:

ZipCityStateCounty.txt

it's a typical thing you find for free, 42K records more or less, in a TAB delimited format i think.

I can tweak it into comma delimited...

also, here is an example of converting that unusualdate format into a datetime field:

--results:

BeginOfMonth DaMonth ...

can you post some sample data you would be importing as well as the CREATE TABLE of the destination table?

you said the first two values of 10141045 was the day,...

BCP is what you would use to get a table or query's results into a file; you'll really need to read Books On Line for the syntax, as I rarely...

you'll want to use the optional ALIAS for each columnname.

descriptions with spaces require brackets or double quotes.

based on your example, here's what it might look like:

SELECT

employeeid AS...

here's a code example of what John and roy are talking about with the calculated column:

Create Table Example(P int identity(1000,1) , --starts at 1000

PCODE AS 'P' + CONVERT(varchar,(P)) PERSISTED, ...

i THINK i understood what you are after;

it's still looking in the same view i mentioned.

try this, and comment/uncomment the WHERE/AND statements to see the differences:

select name,* from syslogins

where...

yeah it seems misleading.

I would say it is ALWAYS Characters. it's just coincidence that when you have a varchar, the bytes=# chars. i think that was what they were trying...

the GO command after every related group of commands would do what you want, i think.

you'd want to make sure there was no explicit transaction open i think, as well.

sp_help_revlogin serves a specific purpose: scripting out the commands to create the logins, complete with the password. it has output...

To build on what CozyRoc said, the issue is your choice of application in opening a CSV file;

if you use a raw text editor, like EditPlus,Notepad++,UltraEdit32, etc, they all open...