Table1

create table usertbl

(

userid int identity(100,1) primary key,

username varchar(50),

parentid int foreign key references usertbl(userid),

product varchar(50),

pValue decimal(7,2)

)

Table2

create table userscore

(

userid int foreign key references usertbl(userid),

score int

)

CREATE TRIGGER updating on usertbl for insert

as

begin

declare...

nabajyoti.b (12/23/2008)

---

Thanks...

well, i tried to find out all the styles

by using below code:

declare @style int

set @style=1

while @style <= 500

begin

print CONVERT(CHAR(100),GETDATE(),@style)

set @style=@style + 1

end

however i did not get 20081223...

This works fine.

But the salary is not ORDERed BY ASC

Ok I created the...

Jeff Moden (12/22/2008)

---

This is what Vladan is talking about...

--===== Move just the data we want to a place where we can work on it

SELECT ISNULL(Sal,0) AS Sal,

...

Jeff Moden (12/22/2008)

---

This is what Vladan is talking about...

--===== Move just the data we want to a place where we can work on it

SELECT ISNULL(Sal,0) AS Sal,

...

r.hensbergen (12/22/2008)

---

Thanks for the input, though there were some flaws in it that made it a bit unclear what is desired exactly. Here I changed the input a bit, let...

Truncate is logged.

Basically you need to find a 3rd party log reader like Lumigent's LogExplorer[/url]

In reality you will probably need to restore the database to before the truncate...

Roy Ernest (12/9/2008)

---

That is going to be tough. Truncate table does not make any entry in the Log file if I am not mistaken. Do you have traces running that...

Thanks jones,

But

I am not the member of sysadmin and I think there is no access for me to see all these things.

As said in articel,

"to check the default trace to...

Thanks Jerry,

I will try my best...NO...I...

Hi,

Thanks for the reply.

Yes it takes a lot of time to become a DBA.

Let my day 1 start from today....

and

What is this PASS?

Thanks

Also consider the values

1234.56

3456.67

45.67

78.34

0

0

-1234.56

-3456.67

-45.67

-78.34

The SUM of above must be equal to zero.

but at 1st execution it will show 0

next execution it will show -2.71243434E-11

next execution again -2.71243434E-11

next execution 0

like that.

So...

Thanks Gila,

Actually these types of result are affecting the production in one or other way.

some batches will be having a query like

WHERE col = '0'

in...