User Profile

Basanth · Oct 31 '13, 05:26 AM

Code:

SELECT * FROM table WHERE GROUPS LIKE '%,1,%'

I think will do the trick...

Basanth · Aug 7 '13, 06:25 AM

I hope these guidelines may help you.

Always look at the query plan first. It will show you the optimal current execution plan from the query engine's point of view. Find the most expensive part of the execution plan and start optimizing from there.

If you see table scan, optimize. Table scan is the slowest possible way of execution. Table scan means not only that no index is used, but that there is no clustered index for...

Basanth · Aug 6 '13, 08:51 AM

@Ammu, I didn't fully understand ur question but if want to display all the rows which r equal to 3rd maximum value u can use subquery. I modified my answer check out

Basanth · Aug 6 '13, 06:42 AM

Try this

Code:

SELECT * FROM SALARY WHERE salary in
(SELECT s.salary FROM SALARY s ORDER BY column DESC LIMIT 2,1)

Basanth · Jul 31 '13, 10:05 AM

Finally!!!

Code:

CREATE TRIGGER DDLTrigger_Sample
ON DATABASE
FOR ALTER_PROCEDURE, DROP_PROCEDURE
AS
BEGIN
//Your logic
END

Basanth · Jul 30 '13, 06:21 AM

i am hoping track if anybody modifying the SPs other than me and i want to know is it possible in any way... may not be by triggers.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Creating trigger on stored procedure