|
|
-
|
|
Often developers use Import wizard from SSMS or SSIS to import data from a text file into a table. You may or may not import it successfully based on the nature of the data.
Create a text file named test.txt with the following data
id|name|address1|rame...
|
|
-
|
|
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...
|
|
-
|
|
When you run the following codeselect name from sys.objects
having 1=1
you get the following error Msg 8120, Level 16, State 1, Line 2
Column 'sys.objects.name' is invalid in the select list because it is not contained in either an aggregate function or...
|
|
-
|
|
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 posted a post on Different ways to find End of the month where I showed you five different ways to find out last day of a month. Here is the analysis on how long each method takes to executeI am not using any physical table to store dates and the...
|
|
-
|
|
You may need to often find the end of the month for various monthly analysis. In this case you need to take all data from 1st of month to end of month.
Consider the following set of data Create table #test(date_col datetime)
insert into #test(date_col)...
|
|
-
|
|
There was a question in the forum on how to Sort mixed value strings “numerically”
Consider the following set of datacreate table #test(val varchar(10))
insert into #test
select '1002' union all
select '29C' union all
select '1' union all
select '205' u...
|
|
-
|
|
Following up Question of the month December 2012 - Why is last comma ignored in CREATE TABLE statement? , here is same question on TABLE VARIABLE
The last comma in permenant and temporary tables are ignored when you run the followingCREATE TABLE emp(emp...
|
|
-
|
|
SEQUENCE is introduced in version 2012. It is an object which can be used to generated customised SEQUENCE numbers that be used across many objects in the database. A SEQUENCE can be directly/indirectly bound with objects.
Consider the following SEQUEN...
|
|