Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

If record exist in declare table @tt

I have declared a table namely @tt in which inserting some values to the text file.

I need to update table b if data is available in @tt otherwise exit. Like is

if @tt Row>0 then
Select..............

Please help me how to check data is in @tt or not.

Mehram
0
Mehram
Asked:
Mehram
1 Solution
 
Pratima PharandeCommented:
try

if exists(select 1 from @tt )
begin
   -- data present

end
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now