How to add an auto incrementing ID field in SQL server

So it turns out that SQL is really quick to pick up, once you have the (very) basics down everything you need to do fall intuitively into place as it is all based on the first principals of a select statement. And even if you do get stuck all answers are a very rapid google search. The biggest trouble I have with starting off programming any new   more »

Tags : SQL number code

How to add better comments into SQL server

How to add better comments into SQL serverWhilst I'm firmly in the 'Tried and Test' camp for most things in life and I may only be new to SQL programming but there are just sometimes when I have to buck the mainstream trend and do it my way. One of these occasions is comments in SQL, the widely adopted way would be to use the prescribed double dash -- or the widely adopted   more »

Tags : SQL comment code

Search Posts

Back to top