Top Posts Tagged with #sqlupdate

Sql ile Sağdan Karakter Silme

LEFT(kolonadi,CHARINDEX('/',kolonadi)-1)

İSTENİLEN: / Karakteri sonrası tüm karakterleri silme...

=======================================

Önce sorgu kontrol.....

SELECT CODE=LEFT(CODE, CHARINDEX('/',CODE)-1) FROM LG_001_ITEMS WHERE CODE LIKE 'TM%' =>> tm ile başlayan tüm kodlar

Sonra Güncelleme.........

UPDATE LG_001_ITEMS SET CODE=LEFT(CODE, CHARINDEX('/',CODE)-1) WHERE CODE LIKE 'TM%'

TEHLİKELİ DURUM : KOD FAZLALIĞI SİLİNDİKTEN SONRA ÇAKIŞMA OLURSA ?

Invalid length parameter passed to the LEFT or SUBSTRING function.

The statement has been terminated.

#logogo #logogo3 #charindex #sqlupdate

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality

Anya is LIVE right now

FREE

Free to watch • No registration required • HD streaming

SQL Update script

/* sets NotionalCurrency to Deliverablecurrency */ SET XACT_ABORT ON SET NOCOUNT ON PRINT N'Preparing data.' declare @transactionsToUpdate table ( DeliverableCurrency1ExtRefInID int, DeliverableCurrency2ExtRefInID int, NotionalCurrency1ExtRefInID int, NotionalCurrency2ExtRefInID int) BEGIN PRINT 'Starting..' DECLARE @cnt INT SELECT @cnt = COUNT(*) FROM @transactionsToUpdate BEGIN TRANSACTION /* UPDATE CODE HERE. Don't forget to fill AuditLog */ IF(XACT_STATE() = -1) BEGIN ROLLBACK TRAN PRINT N'ROLLED BACK' END ELSE BEGIN IF(@@TRANCOUNT = 0 ) BEGIN PRINT 'ERROR OCCURED' END ELSE BEGIN ROLLBACK TRAN PRINT N'HA HA HA! transaction was ROLLBACKED because COMMIT is commented!' --PRINT N'COMMITED' --COMMIT TRAN END END END

#script #sql #sqlupdate