Database

DECLARE @InputParam int,
        @OutputParam int

EXECUTE sp_executesql 'query', 
                      N'@DynamicInputParam int, @DynamicOutputParam int OUTPUT', 
                      @DynamicInputParam = @InputParam,
                      @DynamicOutputParam = @OutputParam OUTPUT

Hema Bairavan wrote:

its not working for me?

DECLARE @ABC VARCHAR(50)
DECLARE @SQL VARCHAR(1000)
SET @ABC = '%test%'
SET @SQL = 'SELECT * FROM table WHERE lower(column) LIKE (''' + @ABC + ''')'
EXEC (@SQL)

create procedure InsertUser
@username varchar(200)
as
Begin
if(select count(*) from users where username=@username) = 0)
begin

insert into users values(column1,column2......)

end
end

create function InsertUser
@username varchar(200)
as
Begin

return 0 --By default user is not inserted and return value have value 0

if(select count(*) from users where username=@username) = 0)
begin

insert into users values(column1,column2......)
return 1 --User is inserted and return value have value 1

end

end

Ray Cassick wrote:

Things that address naming conventions across various industry\business segments so that I can look to normalize a set of tables for a generalized system that could cross industry boundaries and still manage to keep some standardization across industry expectations would be great.

I are Troll

USE DB1
GO
CREATE FUNCTION dbo.udf_Calculate  ( @inID VARCHAR(10))
RETURNS money 
AS
DECLARE @myout MONEY;
SELECT @myout = amount from mytable where ID = @inID;
RETURN(@myout);

SELECT 
db1.dbo.table1.ID as ID, 
db1.dbo.table1.Field1 as Field1, 
db2.dbo.table2.Field2 as Field2, 
db1.dbo.Calculate(db1.dbo.table1.ID) As Amount

FROM db1.dbo.table1

INNER JOIN db2.dbo.table2
ON db1.dbo.table1.ID = db2.dbo.table2.ID