good Question.Learned some new point about nulls

I got wrong.Because i did not observe the semicolon.

CTE is new feature in SQL server in 2005 which uses the result set as a table and you can join the result set with some more table.CTe is use...

I didn't execute the code, but I was definitely helped by the title, "Table Variable: Doesn't Care"... All the same, it's a good question that's pointing out interesting and completely...

hugo explanation is good

It's correct.

Create Table MyTable( mainkey int not null identity (-1,1))

GO

insert into MyTable default values insert into MyTable default values insert into MyTable default values

Select * from MyTable

this will give result...

good question. but i also expected that result is A,B,C.

DECLARE @AAAATABLE TABLE(

K INT IDENTITY(1,1)

,V1 VARCHAR(10)

,V2 VARCHAR(10)

)

DECLARE @DATATABLE TABLE(

V1 VARCHAR(10)

,V2 VARCHAR(10)

)

INSERT INTO @DATATABLE(V1,V2)

SELECT 1 AS V1, 2 AS V2...

got it wrong and i thought that, 1 as something in select into statement by default it will allows.but learned that it will not allows null.I worked more on select...

for working with linked servers you can use system store procedures to add linked server.use the following

USE master

GO

-- To use named parameters:

EXEC sp_addlinkedserver

@server = 'SF-PC035',

@srvproduct = ' ',

@provider...

Hi,here i am unable to see your picture.

this topic is similar to my thread.

Please go through the thread you will find the answer.

http://www.sqlservercentral.com/Forums/Topic922837-338-1.aspx

I read msdn article for more than two hours.and finally answered correct and it is a complex topic and i learned some thing new about encrption.

Can any body send entire...

good question on select into...

I had one point to add.

the following gives an error.

select IDENTITY(int,100,5),* into #temp3 from

testread

there is no alias for identity column.so it shold throw an error.because every...

This type Go questions and answers and disscussions are there.

Please...