I use SQL indentation, comments, and hungarian notation with underscore for variables that arn't affiliated with a specific column name (ex: @enrollment_date for enrollment_date column and @int_loop for a looping...

Also, I think it's important to capitalize keywords too. Something handy for that is using highlight the keyword you want to upper case and use Ctrl+Shift+u. Back to one of...

Always best to take the time to try several approaches, if just to add to your experience. And you also find out better (quicker, easier, more efficient or effective, etc.)...

Toreador (6/11/2010)

---

Well I learnt something, though probably not what was intended.

Believe it or not, I never realised that identity columns are ignored if you could insert into a table using...

So your development and deployment environments are both x64 or i64. You're using the command line syntax to access a 32bit version of the Oracle driver because there is no...

I added a quick option to George's original block to specify the DB you want to search. This way it can sit in Master and be called from anywhere on...

Tim Cullen (5/28/2010)

---

I thought I would be the only one to say that being a database developer is both my hobby and job! I tinkered with databases in my...

malleswarareddy_m (5/27/2010)

---

I did not understand this question.in question it shows that to select wrong sytax.but all resturns table data without any error.then i did not found the wrong answer.so i...

From what I know only the smartest among us survive and gain from Corporate America majority just keep going from job to job and are constantly on the edge for...

Most other countries (including India!) have mandated that companies provide certain benefits. Here it is nothing and no matter how old or how experienced you are you are always at...

Those projects where the workers were not located domestically failed in every case. One project was so badly run that the end cost was 3 times the budgeted amount, and...

Yeah, same here. Good thing a 4th choice like "error"...

Thanks for the replies; some food for thought.

Ken

Ian Massi (5/20/2010)

---

Heck, even when I was a developer building Business Objects reports got too tedious. I would imagine that other types of jobs that didn't offer much of...

My bad. My setup was not right after all. I got it. Linked server from 2005 to 2008 is the same as 2008 to 2008.

Ken