July 2007 Entries
Microsoft Visual Studio 2008 is now available for download as BETA. Here is the link:
Ok, these 3 functions could be confusing - I have seen people use these functions in-appropriately, so I decided to put together a basic list of differences between them. These are points that should be noted before using any of these SQL functions included in the title. These functions are very similar and should be used carefully If no inserts occur @@IDENTITY will be NULL If multiple rows are inserted, @@IDENTITY will hold the last identity value generated @@IDENTITY does not revert to the previous setting if the insert/select into statement fails - same applies if the transaction is rolled back. @@IDENTITY and SCOPE_IDENTITY...
I came across this article today and it stands side by side with my simple development philoshphy. I strongly believe in writing simple and effective code at all times. If an array will do the job, keep it that way - no interwining code. If time permits I'll come up with a list of my do's and don'ts. Read this article...very interesting. Source: Do The Simplest Thing That Could Possibly Work
Ok, I've been asked one too many times about how to convert a month int value to a short or long month name - so here goes nothing. 1: /// <summary> 2: /// Start program 3: /// </summary> 4: /// <param name="args">Arguaments not required</param> 5: static void Main(string[] args) 6: { 7: for (int month = 1; month < 13; month++) 8: { 9: ...
Next entries »