As you've probably already found out, there are a lot of different ways to do things in ASP and ADO. Somethings to consider when choosing which way to do it is the possibility of SQL injection attacks as well as performance. Using a parameterized ADO Command Object reduces the risk of SQL injection attacks (note: […]
2004-02-25
Interesting!http://lists.isb.sdnpk.org/pipermail/comp-list/2003-January/001741.html
2004-01-18
Thankyou sooo much for your help, I am sure I will be back to ask more questions as time goes on.
2004-01-18
Attempting to get column name from varchar staging table and data type from target table.Query works, but need ideas on processing rows returned to select IsDate, IsNumeric .. based on data type.select is1.column_name, is2.data_type from information_schema.columns is1, information_schema.columns is2 where is1.table_name = 'StagingIn and is2.table_name = 'Target' and is1.column_name = is2.column_name and is2.data_type <> […]
2004-01-18
1 reads
2003-11-19
1 reads
Don't see the problem here... If the Manager gets deleted, so would the ID, so there is no difference in it. I personnaly would go for : 1. Track ID's using a trigger 2. Make sure the ID is always unique, even if a manager gets deleted 3. Create a 'history' manager table that is […]
2003-07-17
Frank, If you have access to SQL Server Books OnLine, in the index search for: limitations-SQL Server objects You will see that the maximum rows for a table is limited by the available storage space. The maximum (theoretical) size of a database is 1,048,516 TB, and not a single terrabyte as earlier suggested. Regards Kent
2003-07-09
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