Developer's Zone

Pages

Home
SQL

Saturday, October 18, 2008

Posted by Unknown at 2:19 AM

No comments:

Subscribe To

Posts

Atom

Posts

Comments

Atom

Comments

Followers

Blog Archive

► 2011 (2)
- ► September (1)
- ► April (1)

► 2010 (17)
- ► December (2)
- ► November (15)

▼ 2008 (1)
- ▼ October (1)
  - No title

About Me

Unknown

View my complete profile

Popular Posts

Error Converting Data Type Money to Decimal

Run following script and you will see that it will thrown an error. DECLARE @mymoney MONEY; SET @mymoney = 12345.67; SELECT CAST (@mymon...
Program To Print Numbers in Cylindrical(Maze) Format

Hi, Program Definition :: Print Numbers in Cyclical (Maze) Format Explaination: Here numbers are to be printed in cyclical format i.e. su...
SQL SERVER – ERROR – FIX – Msg 3702, Level 16, State 3, Line 1 Cannot drop database “MyDBName” because it is currently in use

I tried to drop a table, but while trying the same. I got the following Error : Msg 3702, Level 16, State 3, Line 1 Cannot drop database “...
How to Use Pivot table concept in SQL.

Unit_id Unit_price Abbr 1 250 S 1 300 A 1 350 T DROP TABLE TestTable GO CREATE TABL...
SQL Server - Select All Rows rather than Select TOP 1000

When you right Click on a table, you simply find the first option Select TOP 1000 rows. But you can change it to ALL rows i.e. all the rows...
SQL SERVER – The Self Join – Inner Join and Outer Join

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask –...
SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View

Let us first create the same table for an employee. One of the columns in this table contains the ID of the manger, who is an employee of ...
SQL SERVER – COUNT(*) Not Allowed but COUNT_BIG(*) Allowed – Limitation of the View 5

One of the most prominent limitations of the View it is that it does not support COUNT(*); however, it can support COUNT_BIG(*) operator. ...
SQL SERVER – What is Denali?

“What is Denali?” Denali is code name of SQL Server 2011. Here is the list of the code name of other versions of SQL Server. In 1988, Micro...
(no title)

Techworm Pvt. Ltd.. Travel theme. Theme images by richcano. Powered by Blogger.

Pages

Saturday, October 18, 2008

No comments:

Error Converting Data Type Money to Decimal

Program To Print Numbers in Cylindrical(Maze) Format

SQL SERVER – ERROR – FIX – Msg 3702, Level 16, State 3, Line 1 Cannot drop database “MyDBName” because it is currently in use

How to Use Pivot table concept in SQL.

SQL Server - Select All Rows rather than Select TOP 1000

SQL SERVER – What is Denali?