SET @bcpCommand = 'bcp "SELECT * FROM #Results" queryout "' + @FileName + '" -T -c -t,'

...

If you would follow the instructions found under the link at the bottom of my signature, the answer could be more detailed...

Otherwise:

drive your select query from a set of the...

Luis Cazares (2/6/2014)

---

With 800M rows, I would use a bulk export/import for this. I see 2 options:

Use bcp to export query with a SELECT DISTINCT (or GROUP BY all columns),...

Actually, it is not very clear of what OP want's and what he is talking about.

I cannot see how SQL script/proc can ask user to confirm for proceeding with...

BWFC (2/6/2014)

---

jayoub (2/6/2014)

---

I would like to know how to run an update or delete query and have a chance to commit or not. Here is the issue. When...

Whatever way you do, it's not going to be super fast.

You may want to try

SELECT DISTINCT * INTO NewTable FROM ExistingTable

DROP TABLE ExistingTable

EXEC sp_rename 'NewTable' , 'ExistingTable'

BEGIN TRAN

DELETE [tablename]

WHERE [some contitions]

IF @@ROWCOUNT < 10

COMMIT TRAN

ELSE

ROLLBACK TRAN

ben.brugman (2/6/2014)

---

Eugene Elutin (2/6/2014)

---

If you want to see how many times any sql executed with calling this functions, Gail's suggestion with profile might help.

But it has nothing to do...

If you want to see how many times any sql executed with calling this functions, Gail's suggestion with profile might help.

But it has nothing to do with "how many...

Is it function or stored procedure? If you are talking about function, have you tried to "build in counter ". I just wonder how are you going to do so,...

Lowell (2/6/2014)

---

the usual answer is it depends on how you are searching;

if you are searching on last name (WHERE LName = 'McArther')

then yes, an index would help a query like...

Any additonal line of code (excluding comments) degrades the performance less or more...

There is nothing wrong with using temp tables.

Using static...

It depends...

You cannot...

I am looking to query each Database in our environment and list AD,...

Could...