i think round(number,0) or floor(number) do that

thanx

Round(Number to be rouned, number of digit after the '.')

Is it vailed?

select cola,colb,colc ,count(*)from NonUnique as e

where (select Count(* )from nonunique as e1 where e1.cola=e.cola and e1.colb=e.colb and e1.colc=e.colc )>1

group by cola,colb,colc

itried it but it give this error

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'CREATE PROCEDURE [dbo].[ListForeignKeyConstraints]

AS

SELECT (CASE

WHEN OBJECTPROPERTY(CONSTID,...

how can i set user to the defualt user ?

thanks

thats my question how can i log to a specific user?

i have add a database role and then choses and from the securables tab i assigned a spesfic table to deny insert

then go to user on the same database...

i had create a database role

and DENY insert on the table for the role

and add a user to the role but when i try to insert it do so how...