|
|
-
|
|
One of the common requirements is to generate an alphanumeric incremental values like PA0000000001, PA0000000002, etc. There can be several methods to to this. I will list out some of them
Method 1: Create an identity column and concatenate in SELECT s...
|
|
-
|
|
The basic function of a calculator is computing,
which can be as simple as the four arithmetic operations and also as complex as
the calculation for the next move in chess with Deep Blue. Among
these, esCalc is a desktop data calculation tool...
|
|
-
|
|
This series attempts to explore one of the most frequently used, but perhaps least understood feature of Microsoft SQL Server - IDENTITY columns....
|
|
-
|
|
This will take you through the Export wizard in SSIS with a step by step example....
|
|
-
|
|
Starting today, I present a series that explores one of the most frequently used, but perhaps least understood feature of Microsoft SQL Server - IDENTITY columns. Today's post presents an introduction to the IDENTITY column and lists the general rules around it....
|
|
-
|
|
I often see that some junior develepers forget an important thing while designing a table. They choose wrong datatypes to store data ie VARCHAR to store DATETIME or DECIMAL values. This is mostly identified either when verifying the design or giving som...
|
|
-
|
|
Most of developers, DBA or any persons who are working with SQL server, they have seen the error which i mentioned in title. From the error you can easily imagine there is a something error in Server name which are trying to connect server. But when thi...
|
|
-
|
|
Business computing always done by users without technical experience. These users can only rely on the business spreadsheet software to complete such computing. However, the traditional business spreadsheet software is weak in calculation, which will bring about errors in the calculation process....
|
|
-
|
|
How do you ensure that a given database belongs to your product? This post presents two of my most used approaches....
|
|
-
|
|
It’s been more than a month since the last post and you might be wondering – what’s up with SqlJason? Well, let me tell you that the last one month has been really busy and I thought of filling you guys in with some of the juicy stuff that’s been happen...
|
|