There are creative and different ways of solving any problem.  You did not state your business problem which limits anyone from giving you a proper solution.  Despite the many ways...

I should keep my reply short and just say "ditto" to what I've said in the past.

(New certification programs only ever result in more bad development going on and an...

Answer: in some manner it is probably possible.

Truth: It's is a very, very, very, very bad idea.  It would take me forever to properly describe how bad an idea it...

OK, I'm not in a place where I can verify this, but I'm pretty sure the link server name is an alias on your server.  That is, that you are...

Is the script using double quotes for strings and not setting QUOTED_IDENTIFIER properly?

I often find that I am usually alone in my cursing of microsoft when they break fundamental aspects of SQL Server with each new release.  Probably because nobody cares as...

I think what you really want to be doing is selecting @@rowcount into a variable after your assignment select

select @var = col from table

select @rows = @@ROWCOUNT

(edit: Or put your...

Linked servers are for internal (transact-sql) use.  As in stored procs or SQL code you send to the primary SQLServer. If you want to make use of tables on a...

If this is an issue for data insert update, I have always been a proponent of stored procs in place of INS/UPD/DEL statments.  Then the insert proc takes all columns...

Nature's little warning signs:

"I’d also like to see the users participating in the testing which isn’t happening yet"

Sounds like a "fun" environment...

I have this saying:  "Methodologies are crutches for people...

OK disclaimer: I don't know

But based on what I do know about SQL Server...

Each statement is implicitly within a transaction.  That is that behind the curtain SQL is issuing a...

I'm always in favor of making the client communicate correctly with the server. So the application passing the information should be responsible for passing it correctly.

However, if you...

Back in the early 80's affirmative action was a big thing. The state had a procedure for handling this. The personnel department rated all incoming resume's on a...

Ok, he's not going to say it but I will:

If you are that upset about it, quit and get another job.  Or chill out, relax, and give the other guy...

Perhaps a little easier (code wise & in some cases execution wise)

SELECT thingie, IDENTITY(INT, 1, 1 ) as sid, 0 as thingie_count

  INTO #tempthingie

FROM thingie

UPDATE t

   SET thingie_count = (t.sid...