Lost in Translation – Deprecated System Tables – syscolumns
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-13 (first published: 2012-07-04)
2,677 reads
syscolumns
Generate stored procedure parameter list based on table
Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.
2009-12-04 (first published: 2009-11-10)
1,825 reads
RE: Transfer Hebrew Access data to SQL Server
Eric, I have tried collation of Hebrew_Bin and Latin_General_Bin (both are windows collation) on a column and inserted the data directly from Access 2K to SQL 2K using an Append query in Access. Both the Access and SQL data looked like the data you want below. Also, if you want the data reversed you may […]
2003-12-22
1 reads
RE: Merge Replication!
I found : Schema Changes on Publication Databases Schema changes can be replicated during snapshot replication, transactional replication, and merge replication. Column additions and deletions are implemented at the table level and propagated to all Subscribers that receive data from that table. For snapshot replication, the schema change is propagated when a new snapshot is […]
2003-07-03
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers