bcp doesn't add headers, so you have to do it manually.

here's two examples i keep onhand for that:

--BCP to get headers

--Version 1: global temp table

--note i'm making sure my headers...

can't see a reason for the calculated persistent column;

here's my prelim version of your schema, based on what you posted:

by making the column not null, with a foeign key,...

well it looks like it can be done without the cursor and also without the dynamic SQL;

this SELECT is the section that would be doing the INSERT;

how many rows does...

well the details are certainly different now that the DDL is posted.

the DDL details you posted is doing an Insert, not an update, and it's not joining on five...

Charmer (5/29/2012)

---

oh....but i am not sure how...

first a gentle reprimand: you've seen enough posts about providing code...posting pseudo code gets you a psuedo-answer that you have to adapt and ask more questions about...if you posted your...

truncating or deleting never returns file space to the server; it merely clears the internal tables so SQL can reuse the same space. SQL continues to reserve all that space...

another option:

if you use a common naming convention across related procs/tables etc, SSMS has the little used option to filter the results in the Object Browser to limit the items...

michael vessey (5/24/2012)

---

and please re-read the thread yourself - lowels reponse was to change the "query results to text" - which is nothing to do with a select to a...

the truncation is because by default, to save memory, SSMS limits the Results-To-Text to the first 256 characters, regardless of the results.

change it in your options to 8000

not that no...

express 2012 is free, and you can get it straight from microsoft;

the enterprise evaluation edition is also free, but it expires after a while.

both of those you can google for...

I was going to paste it here two! two questions on the same subject just a couple of minutes apart;...

simple syntax issue.

you have BEGIN ( and ) END; the parentheses are not allowed

cthis is syntactically correct:

CREATE PROCEDURE Casino.SP_SLOTMACHINE

@User NVARCHAR(10),@bet INT

AS

BEGIN

DECLARE @L_Wheel...

not natively no. if the database is set to 60 gig, even though it's 10% used, you need 60 gig to restore it.

that said, Redgates SQL virtual restore will...

in our shop, all the identity columns contain the tablename + Id, so repeating the tablename would be repetitively redundant 🙂

so for example TBAddress would have an identity TBAddressID...