Thank you for your response. The thing is, I have the driver. This thing was installed in production by someone and now I'm trying to install it on a new machine. The difference between the two machines (actually networks) is that the prod one uses MDAC 2.1 and the Test Lab machine uses MDAC 2.7. […]
2003-05-30
1 reads
Just the same way as you would if they parameter variables, e.g. INSERT INTO AccidentMain( EmpID, DeptID, ... FName, LName, Address, City, State, ZipCode, ... ) VALUES ( @EmpID, @DeptID, ... @FName, @LName, @Address, @City, @State, @ZipCode, ... )
2003-05-30
1 reads
It seems there are text/image columns in some of tables. See following KB help. http://support.microsoft.com/default.aspx?scid=kb;en-us;279511 http://support.microsoft.com/default.aspx?scid=kb;en-us;324432
2003-05-22
Hi there, I ran the dbcc shrinkfile which ran successfuly. The alter database command failed saying that the file cannot be dropped as it is not empty. What do I do now? Thank you.
2003-05-22
That is expected behavior. As it caches data it will hold it to make subsequent queries faster. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-21
Hi, quote: What exactly does N'string' do? Is it really necessary? not sure if it is really necessary, but it convert the string to unicode Cheers, Frank
2003-05-19
You can do what you want by building dynamic sql that builds dynamic sql, that then gets executed. Here is an example that issues a USE statement, followed by an alter table: declare @CMD char(1000) set @CMD = 'use test ' + char(13) + 'declare @cmd char(1000)' + char(13) + 'set @cmd = ''alter table […]
2003-05-14
Sorry try instead TSQL SQL:StmtCompleted and you will see the queries. You can also use Sotred Procedure items to see when a Procedure is used. "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
2002-04-18
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