what you want to do is to use the DATEADD function, which allows you to add to an existing datetime value.

in the below example, i'm adding hours (hh); note i...

store the latitude and longitude in decimal form only.

it's trivial to convert the decimal to the long syntax, but very difficult to do it back from text to decimal...lots of...

i was under the impression that simple CONNECT rights gives you access to creating objects in tempdb, and the same for at least reading tables in the master database(sys.objects, etc).

to...

in the past, i've used a rowversion as a semaphore column to designate that a row has not changed since the last time it was downloaded.

in some rare cases where...

here's a complete example you can use as a model:

-==snip oops it had a CTE in it; rewriting it... hang on

a datatable is a local object that exists in memory until you call UpdateDataTable from your DataAdapter, which would synchronize any changes....

typically you would use a typed dataset that has...

simply restore the backup with a different database name.

so for example, you could create the database SandBox, and then restore that db with the backup from "PRODUCTION", or you can...

i believe CONNECT privileges automatically gives you rights to tempdb,so because of that you can create a temp table.

so you could insert data into a temp table, which would not...

i think you'll want to search a bit more here on SSC for a better example of auditing changes.

first, your example table is missing a primary key...so for your example,...

he means you have to run the full path: something like this instead:...this is the path on my specific machine:

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\bcp.exe

no i was thinking that you should run monitoring tools against your live server and gather statistics that help identify your bottlenecks;

there's a link on this thread that has a...

the identity() columns themselves are not a problem; I read an

article years ago where SQL2000 could handle 400 new identity values per second in a table...and that was given...

by using the row_number() function,a nd a subquery to limit the results ot the row number, you'll get one(max) record for each account...that's because of the partition by.

try this:

SELECT AccountNbr,...

one of the options in SSMS is that you can script out any command you are doing in the GUI...

the way to do it is as follows:

1. create a...

another option is to use the IDENTITY() function, which is allowed when you use the SELECT INTO format to create an identity column in the dynamically created table:

SELECT

identity(int,1,1) as...