I want to lop off the 4th decimal from a column and update that column.Example:col_a1.23452.34563.4567I want col_a1.23402.34503.4560I thought it was update table set col_a = Trnucate(col_a,3) but this is wrong.
2004-09-10
1 reads
2004-07-13
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-07-12
As long as you can connect to them via linked server I really don't see why it would matter where they live as long as they can talk....
2004-07-05
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
I'm sure this has been asked many, many, many times and hoping several optimal...
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Ask SSC