blob: 3cc72dc030e7449ed108a5dcd0d9d12c238345f5 (
plain)
1
2
3
4
5
6
7
8
|
DECLARE @col_length nvarchar(max)
SELECT @col_length = COL_LENGTH('[dbo].[adiantamento]', 'datapgt')
DECLARE @sql NVARCHAR(MAX) = N'UPDATE adiantamento SET Pagamento = datapgt WHERE Pagamento IS NULL AND datapgt IS NOT NULL;'
IF @col_length IS NOT NULL
exec sp_executesql @sql
|
