Create function int select_dynamic(range varchar(255)) As declare @Qr

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

Question Posted / carmel franco

2 Answers
5324 Views
TVS, I also Faced
E-Mail Answers

Answer Posted / carmel franco

Create function int select_dynamic(range varchar(255))

As
declare
@Qry Varchar(2000)
Begin
Begin try
Set @Qry =”select * from table1 where col1
in (“+range+”)”
Exec @qry
Catch
Print “error processing parameter”
Return -1
End try

Return 1
END

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is merge replication?

1100

What is the purpose of a table?

958

What does select 1 mean?

922

What are the disadvantages of merge replication?

1410

Where to find ntwdblib.dll version 2000.80.194.0?

958

What are the elements of dbms?

958

How can you check the level of fragmentation on a table?

1040

How can you list all the columns in a database?

924

Explain about thread and memory management process of SQL?

968

What the different components in replication and what is their use?

948

What is Transparent Data Encryption?

996

Explain why variables called the most powerful component of ssis?

1084

What is query and its types?

909

Give a example to search fr a string in all stored procedure in sql server.

978

What is wide table?

947