Actually my database creation depends upon no of customers i have.

each customers have there own individual tables and i cant maintain all those things in

a single database

hi Vinu Vijayan,

Thank u for ur reply can u send me a example function on how to use an dynamic sql query in function

This my code

Create FUNCTION [dbo].[UFN_GET_URL]

(

@databasename navarchar(20), -- dynamically will pass the database name

@tablename navarchar(20), --dynamically will pass the tablename

@SubMenuID int,

@Flag tinyint

)

RETURNS nvarchar(300)

AS

BEGIN

declare...

what will be the complexity in CLR functions ....what will be the alternative for this ....

Thank u Robin

I cant use if else statement because there will be a dynamic database creation

and i need acess the function using dynamic sql statement or alternative where...

Hi

thank u for ur reply.

Actually we are using multiple database in our application for a single application .

i need acess different database tables...