I think the below code will solve your problem,

create table #a (nam varchar(10))

insert into #a values('aa')

insert into #a values('ba')

insert into #a values('ca')

with cte as

(

select 1 as id

)

update #a set...

It will surely work, May be the problem is with the case sensitiveness of your server.. Alter the statement with same column name and try it out,

create table #a (id...

Just try this query to achieve your task,

select * from INFORMATION_SCHEMA.COLUMNS

where DATA_TYPE not in ('varchar') and table_name='venkat'

Regards,

Venkatesan Prabu. J

It wont affect the performance of your query.

Check this kb for your question,

http://databases.about.com/od/sql/a/selfjoins.htm

You can prefer replication to achieve this task.

Hope this will resolve your problem,

create table aaaa(id int,nam varchar(10),city varchar(10))

insert into aaaa values(1,'aa','sydney')

insert into aaaa values(2,'bb','delhi')

insert into aaaa values(3,'cc','chennai')

select * from aaaa

create table #temp1(id int, nam varchar(10))

insert into #temp1...

Yes it will surely work

create table aaaa(id int)

insert into aaaa values(1)

insert into aaaa values(2)

insert into aaaa values(3)

select * from aaaa

create table venkat(id int)

with cte as

(

select * from aaaa

)

insert into venkat(id)

select...

I have faced the same problem in my SQL server.

Its because of the older version .. please install the latest patches and try it out.

BEGIN TRY

...

Full Text index can be used to create an index for the data in a column which may be any type (varchar, nvarchar,xml)

where as XML indexes are used to create...

Hope this code will help you,

create table aaaaa(id int)

insert into aaaaa values (1)

insert into aaaaa values (2)

insert into aaaaa values (3)

insert into aaaaa values (4)

insert into aaaaa values (5)

select *...

Hope this will help you achieve your task,

create table aaaaa(id int)

insert into aaaaa values (1)

insert into aaaaa values (2)

insert into aaaaa values (3)

insert into aaaaa values (4)

insert into aaaaa values...

The below statement will free up your cache and you can check your performance after executing the below statement.

DBCC FREEPROCCACHE [ WITH NO_INFOMSGS ]

DDL Trigger -> Its a new concept introduced in SQL Server 2005.

Its used to control and monitor the DDL statements executed in our database.

Consider the below example,

I have created a...

Just try this query,

DECLARE @sourceTable nvarchar(50)

DECLARE @sourceFieldId nvarchar(50)

DECLARE @sourceDisplayField nvarchar(50)

DECLARE @OutString nvarchar(500)

DECLARE @strSql nvarchar(500)

DECLARE @params nvarchar(20)

DECLARE @DocDataId varchar(20)

DECLARE @Concat varchar(200)

SET @strSql =

...