Archive for January, 2012:

How to iterate through a result set with SQL

Method 1: Using a cursor declare cursor1 cursor local for select * from tablename open cursor1 fetch next from cursor1 into #temptable while @@fetch_status = 0 begin if exists (select column from tablename where id = (select id from #temptable)) begin  /* do stuff here */  end else begin /* do other stuff here */ [...]

Share

Tags: , , , , , , , , ,

Leave a Comment

How to iterate through a result set with SQL

Method 1: Using a cursor declare cursor1 cursor local for select * from tablename open cursor1 fetch next from cursor1 into #temptable while @@fetch_status = 0 begin if exists (select column from tablename where id = (select id from #temptable)) begin  /* do stuff here */  end else begin /* do other stuff here */ [...]

Share

Tags: , , , , , , , , , , ,

Leave a Comment

Understanding JavaScript OOP

“JavaScript is an object oriented (OO) language, with its roots in the Self programming language, although it’s (sadly) designed to look like Java. This makes the language’s really powerful and sweet features stay covered by some pretty ugly and counter-intuitive work-arounds. One such affected feature is the implementation of prototypical inheritance. The concepts are simple [...]

Share

Tags: , , , , ,

Leave a Comment

The Development of the C Language

“The C programming language was devised in the early 1970s as a system implementation language for the nascent Unix operating system. Derived from the typeless language BCPL, it evolved a type structure; created on a tiny machine as a tool to improve a meager programming environment, it has become one of the dominant languages of [...]

Share

Tags: , , ,

Leave a Comment

Tip: How to connect to a database with different credentials in SQL Server Management Studio

If you are logged into your machine with a username that doesn’t have access to a certain SQL Server database you can launch SQL Server Management Studio with different credentials. This allows you to use Windows Authentication with a different username when connecting to the database server. runas /user:DOMAIN\USERNAME “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”  

Share

Tags: , ,

Leave a Comment

12 New Year’s Resolutions for Programmers

“Go analog. (e.g. cooking, hiking, astronomy, etc.) Stay healthy. (e.g. weight loss, RSI, etc.) Embrace the uncomfortable. (e.g. stop using a mouse, use Dvorak, try a different OS, etc.) Learn a new programming language. (e.g. scala, erlang, haskell, OCaml, Prolog, etc.) Automate. (build a robot, lego mindstorms, arduino boards, shell scripting, etc.) Learn more mathematics. Focus [...]

Share

Tags: , ,

Leave a Comment

What every programmer should know about memory

“In the early days computers were much simpler. The various components of a system, such as the CPU, memory, mass storage, and network interfaces, were developed together and, as a result, were quite balanced in their performance. For example, the memory and network interfaces were not (much) faster than the CPU at providing data. This [...]

Share

Tags: , , ,

Leave a Comment

A Coder’s Guide to Coffee

“As most software and creative professionals know, coffee is an important technology for boosting mental acuity and maintaining peak on-the-job performance. But did you also know that coffee can be a damn tasty beverage? It’s true. All you need is the appropriate amount of disrespect for the mainstream coffee industry and a desire to enjoy [...]

Share

Tags: , ,

Leave a Comment




PHP Error Message

Fatal error: Call to undefined function advman_ad() in /home/a3151242/public_html/wp-content/themes/black-splat-wr/archive.php on line 54