ironically it's really easy: the INSERT command combined with a SELECT with no WHERE statement will copy it all for you.

Insert Into NewTable (ColumnList...)

Select ColumnList...

From OldTable

--Order By OldPK --optional...

well...yes it is possible, but without more info, you won't have any useful product.

100 tables? as many as 200 columns per table? an you just want to merge them all...

that is one of the coolest things I've seen in a long time; Thanks Paul, I learned something,and have a shiny new toy to play with now.

I added this to...

Paul i tried your example on SQL2005 Standard, SP3, but i get a syntax error in a 9.0 compatibility database, as well as master. is that a 2008 feature? it...

Mat gave you the script to read the flags of the status column; that is exact where it is stored/accessible...it might not be exactly what you wanted, but that's where...

not even familir with unix by any means, but if the commands you pasted can be copied/pasted to a Windows cmd window, which then does the connection to the remote...

the trigger itself looks ok, but it could still fail if any of the fields you are inserting are not null, but the data is null. That's where i...

well, here's an example of a trigger...in this case, my trigger is keeping track of the last time a column was updated.

for trigger interview questions, I'm afraid I can't help...

ranganathanmca (9/5/2009)

---

thanks for your reply ps

i want do it on sql query analyzer only if it possible for this plz tell me what is the error and...

there's some script contributions here on SSC that call SMO; I've done this all via TSQL, where i stick a current "snapshot" of a database in a versioning table in...

here's a similar example i did a while back; i was creating a database, and then adding roles, and then adding users, all as EXECUTE AS 'dbo'

you could picksome of...

I think this is exactly why they introduced the new EXECUTE AS command;

you don't REALLY want to give them extra rights, but they need to perform certain functions.

for #1, you...

Ahh David, yeah, i fell into that SQL trap where i assume all my PK's are also the clustered index...my bad.

Speed.

the PK determines the actual order of the data, so the any SQL's that use that "PK = somevalue" is very fast...because that PK index is used, and makes...

here's how i would do it with an CTE Tally Table:

CREATE FUNCTION StripExtraSpaces(@OriginalText VARCHAR(8000))

RETURNS VARCHAR(8000)

BEGIN

DECLARE @CleanedText VARCHAR(8000)

;WITH tally (N) as

(SELECT TOP 1000000 row_number() OVER...