That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the last month or so. When I think I have it figured out, I am fortunate enough that some of you are interested in reading about my understanding of the technology.
2009-11-06
7,434 reads
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
2009-08-06
5,698 reads
Learn how you can split a delimited string in a single query using XML with Divya Agrawal.
2009-06-25
14,672 reads
Phil shows how 'CROSS APPLY' can be useful for writing thank-you letters or thinking of excuses as to why your project has failed....
2009-03-18
3,881 reads
To add to Chris. I think this is just the default behaviour of the Access Upsizing wizard.
2005-05-11
Hi, I installed MS SQL Server 2000 + SP2 with default options. It was installed in a mixed mode. Now I noticed that the SQL server login passwords are not case sensitive. i.e. for e.g 'PASSWORD' and 'password' are same. Usually passwords are case sensitive. Why it is like this? Regards Unnic
2004-11-26
1 reads
Sorry for asking the bloody obvious, but has tempdb been deleted? As you cannot start the SQL Server service, check in Windows Explorer for existence of C:\Program Files\Microsoft SQL Server\MSSQL\Data\tempdb.mdf (well, this is the default path anyway). Or does the full error message suggest that SQL Server cannot find a certain system table within tempdb? […]
2004-11-16
1 reads
Superfast set based query (0.093 sec for a table of 10000+ records of 40-50 characters): CREATE TABLE [Numbers] ( [PkNumber] [int] IDENTITY (1, 1) NOT NULL , CONSTRAINT [Pk_Number] PRIMARY KEY CLUSTERED ( [PkNumber] ) ON [PRIMARY] ) ON [PRIMARY] GO Declare @i as int set @i = 0 while @i < 8000 begin Insert […]
2004-11-02
Best of luck. With the great job you've done with this site so far, the move should go smoothly. You've done all the proper steps...plan it, notifiy users (and family). Now you just have to do it. And if something unexpected should happen, that's part of the IT would and we'll bear with you (at […]
2004-09-17
Not unless you've got some form of datetime field that's set to the current date on an update. Timestamp columns are updated whenever a record is changed, but I don't think it's possible to work them to a date
2004-09-06
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