If we take specific column in the count function, its fine.

But when i am using count(*), it showing difference.

i found that in background one command is executing i.e.,

DBCC checkDB('Databasename')....

small example :

right("D:\\filesource\\emp1.xls",3)=="xls"

right("D:\\filesource\\emp1.txt",3)=="txt"

mention this condition in precedence constraint to send text files to one destination and excel to other destination using same table in OLE DB.

we can write a condition in precedence constraints like which type of file need to send.

we can send that to same destination taking 2 OLE DB destination with same table.

on way using Precedence constraints we can do that.

If u r considering the name, then there should be 10 tables for those 10 files.

Or else u need something other than this then mention clearly what exactly u r...

Datatype for all the columns is nvarchar only.

we had such a requirement.

its depends on the data type for that column.

for example: If it is a datetime then it will not show much difference.

or else if it is a nvarchar its...

ya that's fine.

if we create a view with schemabinding that will not allow us to make any changes to schema of any underlying tables and their columns.

My ques is why...

create table (id int,subid int)

begin transaction outerOne

insert into bitwise values(100,25)

begin transaction innerOne

insert into bitwise values(150,25)...

Hi,

try this, may it works for u

declare @string varchar(200)

set @string = '\Beverages\Soda Pop\Mountain Dew'

if CHARINDEX('\',@string,CHARINDEX('\',@string)+1)>0

set @string= STUFF( @string , 1 , CHARINDEX('\',@string,CHARINDEX('\',@string)+1),'')

else

set @string= ' '

print @string

hi,

try this, may its works for u.

declare @string varchar(200)

set @string = '\Beverages\Soda Pop\Mountain Dew'

if CHARINDEX('\',@string,CHARINDEX('\',@string)+1)>0

set @string= STUFF( @string , 1 , CHARINDEX('\',@string,CHARINDEX('\',@string)+1),'')

else

set @string = ' '

print @string

i think in sql server 2008 we can rollback the committed transaction.

but in server 2005 we can't.

can anyone suggest me what will be reason.

i got this error when i tried this type of task.

can anyone suggest me about the error?

Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of...

Hi,

Deleting the records by joining more than one table is not possible.

for example:

delete from EMP inner join dept

on emp.deptno=dept.deptno and dept.deptno=50

error:

Incorrect syntax near the keyword 'inner'.

thanks,

kumar

Hi,

its ^ (Bitwise Exclusive OR)

Here is the small example using that operator.

CREATE TABLE bitwise

(

A int NOT NULL,

B int NOT NULL

)

INSERT bitwise VALUES (170, 75)

select...