Yes, I'm very curious as well about this strange way of setting up the identity columns. Indeed, -1,7,15,23,... is the same as 7,15,23,31,... with the exception of the first element. What's...

I tried the XP/SP2 to Vista upgrade a few months back using my wife's notebook and quickly gave up. Thus the inital analysis Vista does on your computer comes up with a...

No one is denying or questioning that you can store a precise value, say 1.25 followed by an infinte number of zeroes, into a SQL Server decimal data type that...

This will be my last post - on this thread.

It may be my last post on this forum - no threat implied.

I thus invite everyone

who wants or needs

to say one...

Say you have a table with just one column d containing dates which represent missing appointments, then a monthly statistic would go something like this

select left(convert(varchar,d,120),7),count(*)

from t

group by left(convert(varchar,d,120),7)

order by...

This is a pretty standard sequence I use when, for example, I need to copy a database from one instance to another. However, make sure you know the implications of...

Just as in SQL Server, where I detach a database and then quickly recover or save it via its MDF and LDF files, so in Oracle I do something analogous...

Gordon, can you show some sample VBScript code for sending email to an smtp server. Thanks loads.

And for Amit or for those that are still on SS2K (i.e. without SSIS), below is some VB script code that lets you transfer an image column to/from a file. Thus...

File shares in a web environment are hard to deal with. Here are some reasons:

1. Even if your web application runs off only one web server, in a large corporation...

Where I work we have started to move a lot towards using image columns to store files in tables. Sometimes it's not always the GUI that needs to get at the...

For importing Excel files, you might also have a look at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=334859#bm334915

Indeed! Although the SS2K BOL documents allowable seeds for RAND() as limited to integer types. But if varbinary works, so be it.

Man are you right. I stopped at RAND and didn't bother to look what it's being passed. Sorry.

To get different values you need to mess with the function newid().