Thanks Florian, Got it.Such strange cases need to be ignored.

The result set is same for the both the queries.

Thanks Gail for your update.

Lynn,

Here is the input.

CREATE TABLE TAB1(COL1 INT IDENTITY(1,1),COL2 DATETIME)

DECLARE @I INT

SET @I=1

WHILE (@I<1000)

BEGIN

INSERT INTO TAB1

SELECT GETDATE()

SET @I=@I+1

END

SELECT * FROM TAB1

CREATE TABLE TAB2(COL1 INT IDENTITY(1,1),COL2 DATETIME)

DECLARE...

Thanks Lynn I have gone through your post(articles).Let me update the post with exact data and input .Typo it's not right join it's inner join

Gail,

Am getting the same result when I select only col1 from both Left and inner join like the below

SELECT Tab1.col1

FROM Tab1

LEFT JOIN Tab2

ON Tab1.col1=Tab2.col1

or

SELECT Tab1.col1

FROM Tab1

INNER JOIN...

Thanks Gila

Lynn

Regarding your query the first Inner Joins lists records that matches in both tables.LEFT OUTER JOIN returns the all records from table tab1 irrespective of matching records in...

Hi Stewart,

It's working now.Even the first statement also working.

Thansk a bunch.

Hi,

It's not working.Is there a way to rename the file.

Thanks,

Nagesh

Hi,

You need to declare two input parameters for each column

1) columnname

2) datatype.

so that u can dynamically declare them.

declare @Cmd varchar(max);

set @Cmd='DECLARE @data XML

SET @data=''<dataSet> <Items><ID>5 </ID> </Items><name>santhose</name></dataSet> '' SELECT

colx.value(''id[1]'',''int'') as EmpId,

colx.value(''name[1])'',''varchar'') as EmpName

FROM @data.nodes(''dataSet/Items'') as tabx(colx)'

exec(@Cmd)

Hi,

for the answer A) how will be the performance impact

and which will be the best method of the above three backups that will have low impact.

Thanks in advance.

For interger columns you can go for the default as 0(zero). You may have Varchar column as null.But make sure that you should not query based on the null column...

Thanks for that

I learnt new thing stuff function

SELECT CONVERT(VARCHAR(20),GETDATE,120)

above query not giving the AM/PM at the end

Please check the below one (ignore the previous one)

SELECT (SELECT CONVERT (VARCHAR,GETDATE(),101))+' ' +(SELECT SUBSTRING (CONVERT(VARCHAR,GETDATE(),109),14,27 ))

Output

11/17/2010 2:01:51:833PM

Still am not able...

SELECT CONVERT(DATETIME,((SELECT CONVERT (VARCHAR,GETDATE(),101))+' ' +(SELECT SUBSTRING (CONVERT(VARCHAR,GETDATE(),109),14,27 ))))

Output

11/17/2010 2:01:51:833PM

Still am not able to remove the milliseconds as it should be below.

11/17/2010 2:01:51PM