Database

EXEC master.dbo.sp_configure 'show advanced options',1      RECONFIGURE
EXEC master.dbo.sp_configure 'xp_cmdshell', 1       RECONFIGURE

declare @query varchar(500)
set @query = 'BCP "SELECT * FROM YourTable" queryout "C:\YourTable.txt" -c -T -C850 -S(local)\SQLEXPRESS -Usa -Psa'

EXEC master..xp_cmdshell @query

EXEC master.dbo.sp_configure 'xp_cmdshell', 0
RECONFIGURE     EXEC master.dbo.sp_configure 'show advanced options', 0
RECONFIGURE

nelsonpaixao wrote:

What do you think?

SELECT TO_CHAR( SYSDATE,    
                'dd.mm.yyyy hh24:mi:ss'    
              ) AS CurrentTime,
       TO_CHAR( TO_DATE('09:00','hh24:mi') -- results in first day of this month at 09:00
                + INTERVAL '19' HOUR       -- adding hours
                + INTERVAL '09' MINUTE,    -- adding minutes
                'dd.mm.yyyy hh24:mi:ss'    -- formatting
       ) AS AddedTime
FROM dual;

CURRENTTIME	ADDEDTIME
6.8.2008 21:18	2.8.2008 4:09

CREATE PROCEDURE mySchema.MyProcedure
(
    ... Parameters go here ...
)
AS
... SQL Code Goes here ...
GO

compad wrote:

how to declare variable

DECLARE @myVariable int -- or what ever type you want.

compad wrote:

how to check condition

IF @myVariable = 123
BEGIN
   ... Some SQL Code Here
END
ELSE
BEGIN
   ... Some other SQL Code here
END

compad wrote:

I am aware of Oracle Procedure. Is the same syntax or something different.

compad wrote:

If you have any link for tutorial. please forward it to me.