See, if this helps:http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspxOr search the fora here. This is a FAQ in almost any SQL Server community.
2004-12-16
But while the answer sucked.. The question was valid. The other three choices do not give you what you are looking for. We know that a Cross Join wihtout a where clause produces a cartesian, and how the left and right joins work, that left the "middle" join. Although it was not a keyword as […]
2004-10-21
Found the answer re how to use INI files - Excellent tutorial: "Updating SQL Server Connection Properties from the DTS Package INI File" http://www.databasejournal.com/features/mssql/article.php/3073161 The next step I guess is to create another package which will copy the template (ActiveX script using the FileSystemObject) over the top of config.ini. I can run this package once […]
2004-06-03
Look at your current execution plan, could be index could help or are you meaning is there a faste way to build query itself?
2004-05-28
Yes. Brian to the rescue.Its actually quite simple. I guess I was overcomplicating it in my mind (easy for me to do)Basically the query above can be rewritten as the following...INSERT TABLENAME1 SELECT Field1 = A.Field1, Field2 = A.Field2, Field3 = A.Field3, Field4 = A.Field4, Field5 = SUM(A.Field5), Field6 […]
2004-01-28
If you're using dynamic SQL, you could substitute CHAR(39) for the single quote, CHAR(91) for the left bracket and CHAR(93) for the right bracket, as follows:------------------------------------------------------ DECLARE @SQL varchar(200)SELECT @SQL = 'SELECT * FROM tab1 WHERE fld1 LIKE ' + CHAR(39) + 'Ph' + CHAR(91) + '(' + 'L' + CHAR(39)EXEC(@SQL) ------------------------------------------------------It will generate the […]
2004-01-16
Personally, I don't like the thought of all DB environments on the same server. The potential of un-wanted access or modification to the production DB is to great. I do not have a great problem with the test DB as much as the development DB. Development is an environment where you not only create objects but may […]
2004-01-16
Whooppss! Spoke too soon. I did end up finding it. Bet we hear they got hacked! -SQLBill
2004-01-16
Although I don't have enough experience in resolving deadlocks to make a recommendation for you, I did just recently find an excellent resource on deadlocks. The Professional Association for SQL Server (PASS) web site now has three presentations from last year's conference that non-members can access for free, including a PowerPoint about deadlocks. Here is […]
2003-08-29
1 reads
Might be that the INSERT INTO combined with the OPENQUERY creates a distributed transaction. Loopback servers can be used in distributed queries but not distributed transactions. See "Loopback Linked Servers" in BOL. Cheers, - Mark
2003-08-05
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers