Breaking of relationship means any action( INSERT, UPDATE or DELETE ) that results in an entry in FOREIGN KEY table that does...

Yes. You can delete a row in the PRIMARY table if the CASCADE DELETE...

One way could be to use an INSTEAD OF trigger

The below mentioned link could be of help to you

http://msdn.microsoft.com/en-us/library/ms175521%28v=sql.105%29.aspx

CELKO (11/6/2012)

---

Now we have to track down this interview so we can tell them that you cheat. I have gotten two students and one lecturer kicked out of their schools...

vs.satheesh (11/6/2012)

---

I face one interview question.One salary table i have three column like (id,name,salary)

Table Name:SalaryDetail

id name salary

1 arun ...

muthukrishnan.e (11/2/2012)

---

DECLARE @r VARCHAR(MAX)

SELECT @r = ISNULL(@r+'/', '')

+ t2.col4 + ' - ' + 'Rs. '...

Probably something like this..

UPDATE#temp_ticket

SETclub_group_joined = CASE

WHEN club_group_id_col = @lClub_group_joined_test

THEN STRING(club_group_id_col, ',', CONVERT(date, club_group_joined_datetime))

ELSE NULL

END

WHEREclub_group_joined_datetime IS NOT NULL

After a unique clustered index is created on the view, the view's result set is materialized immediately and persisted in physical storage in the database, saving the overhead of performing...

Good QOTD.

This will clear quite a few misconceptions people have about Table Variables.

patelmohamad (10/17/2012)

---

Kingston Dhasian (10/17/2012)

---

No. You cannot use a Stored Procedure like a UDF.

You can insert the results from a Stored Procedure into a temporary table and work on the temporary...

No. You cannot use a Stored Procedure like a UDF.

You can insert the results from a Stored Procedure into a temporary table and work on the temporary table further.

phamm (10/15/2012)

---

Thank you very much. what if my column1 have value 'abcdef0000' and column 2 value is 123. Then I cannot convert them to integer to add them...

Well, nobody can help with this limited amount of information

Please describe your issue and give us some sample data and the expected results as per your sample data

It would be...

You can use a Modulo operator to remove the hard coding of values

DELETEtemp

FROM(

SELECTROW_NUMBER() OVER(PARTITION BY x.cStudentId,x.dtEnrollmentDate ORDER BY dtEnrollmentDate asc ) AS DSeq, x.*

FROM#temp1 x

) temp

WHERE ( DSeq % 5...

The answer to this is available in the explanation to the question( also shown below )

When n...