Blog Posts

Many times we caught in a situation where we have a table where there is no primary or unique column...

2013-12-29

59,420 reads

Answer -Question of the Week - 25/12/2013- Question 1

by Vivek Johari

Vivek's SQL Notes

Question:- Suppose we have a table says tbl_students whose structure is given below:-

Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))

Suppose it...

2013-12-28

780 reads

Day 4 – Broken Broker

by Jason Brimhall

SQL RNNR

This is the fourth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

2013-12-28

28 reads

Day 4 – Broken Broker

by Jason Brimhall

SQL RNNR

This is the fourth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...

2013-12-28

728 reads

Question of the Week - 28/12/2013 - Question 2

by Vivek Johari

Vivek's SQL Notes

Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows...

2013-12-28

540 reads

Being a Better IT Pro - Grammar

by Brian Kelley

Databases – Infrastructure – Security

In my IT career, one of the things I have found that sets me apart is my ability to write....

2013-12-27 (first published: 2013-12-23)

16,509 reads

Day 3 – Reviewing Peers

by Jason Brimhall

SQL RNNR

This is the third installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

2013-12-27

14 reads