Use WITH Encryption Keyword with all the SQL objects while installing on the production system.

"I'd have to disagree. I think these ones about working out pointless conditions to satisfy one off special cases that nobody will EVER use, are more about your ability (and...

HAPPY NEW YEAR 🙂

Thanks for the reply.Actually I want to export the data through my application.I can't able to run the script in destination before export.Is there any other way which I can...

Thanks for the valuable information.

I checked the Query like this :

"SELECT * FROM dbo.Customers AS C

MIDDLE JOIN dbo.Employees E ON C.CustomerID = E.EmployeeID",so it's showing some error.If i try...

I tried this query in SQL SERVER 2005,It's giving some error.It's a SQL SERVER 2008 feature?

Thanks & Regards

Sagesh.K

Thanks for your information.

I found, when working with Table variables it's faster than Temp table.

Table variable is faster than Temp Table

Declare a Table variable (INPUT/OUTPUT) and pass it into the store procedure(get_RptStaticPoolCopy1 ) .In the storeprocedure(get_RptStaticPoolCopy1 ) you can fill the table variable which you are getting as a parameter...