Are you asking how to pass a parameter to a batch file, or how to connect to SQL Server from a command prompt? If it's the latter, look up...

There are lots of options in that dialog box, one of which is to script out the primary key constraint. Have a play with those options, and see if...

I'm not clear about whether your table already exists in the second database and you just want to copy the data. If so, just use DTS or INSERT INTO...

There must be different degrees of "exactly the same" otherwise you wouldn't need to do this...

Seriously, though, just script out the table and then run the script against the second...

Frances

If you take the second "as [Name]" out of your second query, it should work.

John

If you declare a variable, it is only visible in the context of your connection. If you then use EXEC @select_var to run some code that contains the name...

Sandy

It's doing what you ask it to. SELECT * means "select all columns". SELECT 'x' means "select the value 'x'" (regardless of what data is actually in each...

Yes, just create a temporary table with an identity column and insert from table A into that. Then find the max ID value from table B and insert into...

Kiruba

Because you've converted your dates to varchar, it's comparing string values and not date values. In those circumstances, '03/10/07' will always be greater than '01/01/08'.

John

I agree with Mattie. Please can we go back to the old way of having threads only appear on the newsletter once. That way readers don't have to...

Joe

That looks as if it will fit the bill.  Unfortunately, I'm off home now and I have three weeks out of the office, so I probably won't be able to...

Joe

LOL indeed!  t does stand for table, but as I explained, I could have used any other letter(s) instead.

John

Rohit

This information about your error is available in Books Online.  Have you checked your error message and run DBCC CHECKDB?

A

system assertion check...

Joe

In the FROM clause, tblassignment is aliased as a, tbl3215 as t, and tblfltwrkcntr as f.  These are arbitrary aliases whose purpose is to make your code easier to read. ...

Byron

Please will you give us the CREATE TABLE statement for your temporary table.

Also, please have a read of this - it'll help others to help you as quickly as they...