What happened to a simple query like bellow? You only need to set the number of rows per page and the number of page you want to retrieve. I...

How about the feature with right click and generate the script? Has anybody used that? As it seems the script does about just right in creating all the objects involved...

Thank you all for your posts!

I think that the easyest workaround for this problem would be indeed to explicitly specfy the owner at the creation of the table. I knew...

Cliff Knight (3/4/2008)

---

I have found dynamic SQL statements to be faster in many situations where the exact nature (and number, when using optional parameters) of passed parameters is unknown at...

RIck Moudy (2/28/2008)

---

If you convert your @varDate local to a smalldatetime local before using it in the SELECT statement you can do a straight comparison of the local variable and...

SQL server 2000 doesn't support the XML data type. It was introduced with SQL server 2005.

jacob sebastian (12/10/2007)

---

Manish Sinha (12/10/2007)

---

I am having a dot net application.Suppose I have to insert 5 rows in particular table.wat i do is that I call the sp once for...

Scott Gammans (5/30/2007)

---

I don't think Jacob is the one suffering from a lack of knowledge, Sergiy. What happens when two different users simultaneously call the same stored procedure? Kaboom, that's...

Sotiris Filippidis (10/10/2007)

---

Just suppose those two conditions could be part of a larger array of conditions in a reporting UI, for example, and would apply depending on user's choices. Of...

To be honest I didn't understand this article. First of all the example doesn't cover the first condition "All records that contain the word "the" in the company name", but...

You can also use OPENDATASOURCE or OPENROWSET without having to create a linked server.

Ex from Books Online:

with OLE DB provider for MS SQL

SELECT a.*

FROM OPENROWSET('SQLOLEDB','seattle1';'sa';'MyPass',

   'SELECT * FROM pubs.dbo.authors ORDER...

try this:

osql -S servername -d databasename -E -Q"select * from orders"

 

-E param tells OSQL to use the trusted connection (your windows account) to access the database so you don't have to...

You can put the DP task where you want depending on what you want but the "mission" of the Dynamic Properties task is to be able to change at the...

You don't need a second package.

I solved this kind of problem by creating in the working folder a sample/source/structure excel file (i.e. _sample_file.xls) that has the workbook created with the...

Contradiction:

Nothing comes without caveats! You cannot use Table Variables in the following situations:

select xxx into @table_variable

or

(here) insert into @table_variable select * from myTable

For example if you...