View Single Post
  #1 (permalink)  
Old April 5th, 2008, 03:43 AM
mahen_pali mahen_pali is offline
Registered User
 
Join Date: Apr 2008
Location: mumbai, maharashtra, India.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to mahen_pali Send a message via Yahoo to mahen_pali
Default get the execute query result in variable

hello all of you

i want to get the execute query result in variable
Here is code

declare @Trans varchar(50)
set @Trans = 'Trans'
declare @val int
set @val = (execute('select count(*) from '+@Trans))

How can i solve that please help me soon

mahendra singh
Reply With Quote