User Profile

Collapse

Profile Sidebar

Collapse
prasadgelli
prasadgelli
Last Activity: Jul 6 '06, 12:50 PM
Joined: Jul 6 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • prasadgelli
    replied to Concat ??
    in SQL Server
    Try this syntax

    select emp_id, 'Messages today = ' + convert(varchar (10),count(1)) from table group by empid

    Prasad
    See more | Go to post

      Leave a comment:

    • prasadgelli
      replied to to find a particular record set is present or not?
      in SQL Server
      Hi, It would be easy to help you if you can put your question in complete as i feel your question is incomplete. - Prasad
      See more | Go to post

        Leave a comment:

      • prasadgelli
        replied to Automated email
        in SQL Server
        Use the following syntax to send email
        SendEMail 'softdev@knoahi ndia.com','pras ad@knoahindia.c om', 'Sending email through Stored Procedure', 'Body : Giving TO, FROM, SUBJECT, BODY, SMTP - Address - 192.168.0.5, An Email can be sent through stored procedure... and this is SAMPLE', '192.168.0.5'

        Here is the storedprocedure
        Create Procedure dbo.SendEmail
        @To VarChar(500), @From VarChar(100), @Subject VarChar(200),...
        See more | Go to post

          Leave a comment:

        No activity results to display
        Show More
        Working...