This is cool is there any use for this

SELECT * FROM sysobjects WHERE name like '%spTest%'

Gives one name

SELECT text FROM syscomments WHERE id = (

SELECT id FROM sysobjects WHERE...

I tried

EXEC Northwind.dbo.spTest;2 1 -- 'Tacoma'

It says

Server: Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'Northwind.dbo.spTest'.

Yes Bulk Insert and bcp will ignore the foreign Key and check constraints unless specified to check. Only way to get data into a not null columns during bcp is as...

very well. How the batch file is executed? If he initiates the batch file himself then he can check whether there are any rows in the staging table. Or if...

When the files are sent by FTP how do you initiate the bcp?. Do you have the bcp commands as Batch file.

Like I mentioned before before initiating the...

You can bcp out data from a view or query with just columns and rows you need. Then use format files to load the databack through Bulk Insert.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=193526#bm193537

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=192560#bm192593

I...

It will be the same for any character field.

E with any other subsequent letter is gretaer i.e 'EA' is greater than 'E'

SO obviously 'Evan'  is not less than or equel...

CREATE PROCEDURE YearSales

  @Start   datetime,

  @End     datetime = NULL

AS

SET NOCOUNT ON

DECLARE @Error

IF (@Start IS NULL OR @End IS NULL)

BEGIN

  RAISERROR('NULL Values are not allowed',14,1)

  RETURN 14

END

SELECT ShippedDate,

       OrderID

  FROM Orders

WHERE...

Within a stored procedure itself is single scope even without a transaction.

External calls, Call another stored procedure and triggeres are out of scope even within a transaction.

Data modified or inserted...

During Bulk Insert constraints on the table are not checked for the bulk copy operation unless CHECK_CONSTRAINTS is specified.

So you can bcp out the data and use Bulk Insert to...

So Noeld how can we make sure the call is made every 10 seconds.

I got that doubt too. If that is the case make the call in endless loop with 10 sec gap. -- Bad Idea

What happens to the time taken for executing the commands.

If the job is scheduled for every minute and the execution takes 1 min 10 sec. Will the job continue...

Ther will never be 10 consecutive days Vasc. We have holidays when there is no trade. So we have to take available dates only.

I use T-SQL Function.

T-SQL function will fail after @@NESTLEVEL = 32. So Front end calls are better. I use this to Update another field in a table. So I...