Database

<br />
CREATE PROCEDURE updateUsers<br />
@ID int,    <br />
@Name varchar(50),<br />
@DateModified datetime<br />
AS<br />
<br />
--	compare the datemodified<br />
DECLARE @LastDateModified datetime<br />
SET @LastDateModified = SELECT [Users.DateModified] FROM [Users] WHERE [Users.ID] = @ID<br />
<br />
IF (@LastDateModified <> @DateModified)<br />
	BEGIN<br />
		RETURN 1<br />
	END<br />
ELSE<br />
	BEGIN<br />
		UPDATE [Users]<br />
		SET<br />
			Name = @Name,<br />
			DateModified = GETDATE()<br />
		WHERE<br />
			ID = @ID<br />
		GO<br />
		<br />
		RETURN 0<br />
	END<br />
<br />

DECLARE @table_name varchar(128);
SET @table_name = 'single_pkey';

SELECT	cols.COLUMN_NAME as column_name, 
	cols.DATA_TYPE as type, 
	cols.CHARACTER_MAXIMUM_LENGTH AS length, 
	CASE WHEN cols.IS_NULLABLE = 'No' THEN 0 ELSE 1 END as is_nullable,
	CASE WHEN pks.column_name IS NULL THEN NULL ELSE cols.ORDINAL_POSITION END AS primary_key,
	cols.ORDINAL_POSITION as position,
	pks.column_name as pks_column_name -- For testing
FROM INFORMATION_SCHEMA.COLUMNS cols
LEFT OUTER JOIN (SELECT kcu.COLUMN_NAME as column_name
	FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE as kcu
	INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS as tc
		ON kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME
	WHERE tc.TABLE_NAME = @table_name
	AND CONSTRAINT_TYPE='PRIMARY KEY') as pks 
	ON pks.column_name = cols.COLUMN_NAME
WHERE TABLE_NAME = @table_name
ORDER BY cols.ORDINAL_POSITION

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!