|
|
-
|
|
Pinal Dave in his post asked about the simple ways to convert hexadecimal values to decimal values.
Here are some methods:
87235 is an integer value whose hexadecimal is 0x000154C3.
In this case make use of Implicit conversion.
declare @hexa varbinary(10)
set @hexa=0x000154C3
select
@hex......
|
|
-
|
|
The PIVOT operator available in SQL Server 2005 is used to generate the Cross-tab results
Consider this example
select * from
(
select Year(OrderDate) as pivot_col,e.lastname, o.OrderDate FROM northwind..Employees as e
INNER JOIN northwind..Orders as o ON (e.EmployeeID=o.EmployeeI......
|
|
-
|
|
It seems often users want to check whether the data has only numbers in a varchar type column. The commonly suggested one is to make use of ISNUMERIC() function. But the problem in using that function is that it will treat some alphabets, $, char(10),etc as numbers.
Consider this example
declare......
|
|
-
|
|
One of the features available in SQL Server 2005 is Row_Number() function. It is not only used to generate row number for each row but also used for other purposes as well. I breifly explain how it can be used for various purposes
Consider the following data
Declare @t table(item varchar(100), p......
|
|
-
|
|
When viewing the existing table structures, I noticed that one table has a column with datatype defined as VARCHAR(1). I generally do not see this being used.
Given that you need to use a character datatype of maximum length of 1, the question is "Is V...
|
|
-
|
|
Assume that you have two identical tables in different servers. The table in production server has 100 million rows and the table in test server is empty and you want to transfer data from production server into test server to do some analysis based on ...
|
|
-
|
|
Previous posts on this series
Exploring SSIS - Understanding the basics Exploring SSIS - Execute SQL task with simple parameter Exploring SSIS - Export to csv file Exploring SSIS - Rename file by suffixing current date
I have started a series on Explori...
|
|
-
|
|
Previous posts on this series
Exploring SSIS - Understanding the basics Exploring SSIS - Execute SQL task with simple parameter Exploring SSIS - Export to csv file
I have started a series on Exploring SSIS where I will explain various features available...
|
|
-
|
|
Previous posts on this series
Exploring SSIS - Understanding the basicsExploring SSIS - Execute SQL task with simple parameter
I have started a series on Exploring SSIS where I will explain various features available. In this post, we will see the u...
|
|
-
|
|
I have started a series on Exploring SSIS where I will explain various features available. In this post, we will see the usage of Execute SQL task in Control flow Execute SQL task is primarily used to execute SQL statements and stored procedures with o...
|
|