Edit Code sql server simple

I want

Edit Code

When inserting the date

I want a difference of 30 seconds

Increases 30 seconds per row

sql server 2014


INSERT INTO [SMS].[DBO].[Out] (MessageTo, MessageText, MessageType,Gateway,UserId,Scheduled )

SELECT ('hhh'+ Mobile) as MessageTo , ('hhf' + ' ' + '( '+ Actual_Balance +' )' + ' ' + 'hhff ') as MessageText, '[login to view URL]', 'COM64' , Act_Code ,DATEADD(second,(rand()*60+1), DATEADD(minute,(rand()*20+1) , getdate()))

FROM [‏‏SASDbforme2018hdedh].[DBO].[Account] where Eng_Name like '1'


Kemahiran: SQL

Lihat lagi: android project source code sql server, save edit documents sql server, inventory full source code sql server, sql database recovery mode, sql change recovery model, bulk logged recovery model in sql server, difference between simple and full recovery model in sql server, sql server change recovery model from full to simple, alter database set recovery simple, how to check recovery model in sql server, sql server recovery mode, mysql, sql, convert code sql server 2008, hospital management system source code sql server, convert access 2007 code sql server, rule engine source code sql server, simple registration form code asp net sql server, iphone sample code sql server, code sql server 2000 export xml

Tentang Majikan:
( 4 ulasan ) taiz, Yemen

ID Projek: #16339232

Dianugerahkan kepada:


Hi I can solve this right now for you, Your SQL CODE is adding a Random seconds that goes from 1 to 60, you want to change that to always 30 seconds. That's it?

$20 USD dalam sehari
(4 Ulasan)

7 pekerja bebas membida secara purata $26 untuk pekerjaan ini

$25 USD dalam sehari
(2 Ulasan)
$25 USD dalam sehari
(1 Ulasan)

Greeting, I have understood your Edit Code sql server task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in SQL

$50 USD dalam sehari
(1 Ulasan)

Dear Hiring Manager I can finish immediately. Looking for a creative and knowledgeable Web Developer? Search no further, because I am ready for the job. With 5 years of web development experience for global business Lagi

$20 USD dalam 0 hari
(0 Ulasan)

A proposal has not yet been provided

$35 USD dalam 2 hari
(0 Ulasan)
$10 USD dalam sehari
(0 Ulasan)