Some info here, although not good news I'm afraid: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q236/6/05.asp&NoWebContent=1 If the workaround give here is unacceptable, you might be able to fudge it by applying a macro onto the excel sheet that explictly converts all numeric values to character data in the affected columns (I know you don't want to play these games if […]
2003-11-26
2 reads
How about something like this? select t.[name] as tablename, isnull(p.[name],'') as ConstraintName, isnull(p.xtype,'') as ConstraintType from sysobjects t left join sysobjects p on t.[id] = p.parent_obj where t.xtype='U' order by tablename asc Dan B
2003-08-19
I figured out the problem. It seems that in the SP where the code reads: ' "' + @param1 + '"' There were double quotes, which made the query treat param1 as an identifier instead of a string literal. It was hard to discern double quotes (") from 2 single quotes (''). I have modified […]
2003-08-13
1 reads
If users have administrator access to your machine, then you are not going to be able to secure SQL Server completely, other than for the casual user who connects via isql or EM. As an administrator I can change the registry to let me in in or I can just copy the DB files or […]
2003-08-10
Can you post the SQL code, or is it proprietary? Have you tried contacting the vendor for support?
2003-07-11
1 reads
Hi Csaba, you've said, you've installed SQL Server. Can you reinstall the OS or is this a problem? Cheers, Frank
2003-06-20
1 reads
Crappy Why don't you add an identity column to your temp table and then select between key values ie create table #temp (id_no identity (1,1), val varchar(50)) <insert your data> for first ten select val from #temp where id_no between 1 and 10 for next ten select val from #temp where id_no between 11 and […]
2003-06-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