CREATE TRIGGER test /* CHANGE TO ALTER when you edit this TRIGGER */
ON tbltest
FOR INSERT, UPDATE /* Fire this TRIGGER when a row IS INSERTed OR UPDATEd */
AS
BEGIN
                     UPDATE  tblTest  SET  tbltest.testvalue=tbltest.name 
                     FROM INSERTED
                     WHERE inserted.id=tbltest.id
END

 
/* Eg: */
INSERT INTO tblTest (name) VALUES (‘ooooo’) 
 
/* Now CHECK the DATA: */
SELECT *FROM tblTest

 
WITH temp_table AS
(
	SELECT *, (ROW_NUMBER() OVER (ORDER BY field_name)) AS row FROM table_name 
)
 
SELECT * FROM temp_table

 
SELECT * FROM temp_table WHERE row BETWEEN 10 AND 15

SELECT 
	HashBytes(‘MD5′, ‘Praveen’),
	HashBytes(‘MD5′, ‘PraveeN’),
	‘0xD09C2ECC3DFCDC8C8D921B589097FCB1′,
 
	CASE WHEN convert(int,HashBytes(‘MD5′, ‘PraveeN’)) = 0xD09C2ECC3DFCDC8C8D921B589097FCB1 
	THEN 
		‘Success’ 
	ELSE
		‘Failed’
	END

SELECT
	name,
	CASE WHEN type=‘P’ THEN 
		‘Stored Procedure’
	ELSE
		CASE WHEN type=‘TR’ THEN 
			‘Trigger’ 
			ELSE CASE WHEN type=‘V’ THEN
				‘View’
				ELSE CASE WHEN type=‘U’ THEN
				‘Table’
					ELSE CASE WHEN type=‘FN’ THEN
						‘Function’
						ELSE CASE WHEN type=‘F’ THEN
						‘Foregin Key’
							ELSE CASE WHEN type=‘K’ THEN
							‘Key’
							END
						END
					END
				END
			END
		END
	END
FROM 
	sysObjects 
WHERE 
	type=‘P’ OR type=‘TR’ OR type=‘V’ OR type=‘U’ OR type=‘FN’ OR type=‘F’ OR type=‘K’ 
ORDER BY
	type, name