How do you write an SQL insert statement?




Answers were Sorted based on User's Feedback



How do you write an SQL insert statement?..

Answer / srinivas reddy

In SQL Insert statement is

insert into tablename values(columnname1 datatype,
columnname2 datatype........)

Is This Answer Correct ?    3 Yes 1 No

How do you write an SQL insert statement?..

Answer / pravati

INSERT INTO tablename(column name1,column name2,column name3....)
VALUES(value1,value2,value3...)

Is This Answer Correct ?    1 Yes 0 No

How do you write an SQL insert statement?..

Answer / vamsilakshman

create table tablename (sid int,sname varchar(20))
insert into tablename(1,'vamsi')
insert into tablename(2,'lakshman')

Is This Answer Correct ?    0 Yes 0 No




How do you write an SQL insert statement?..

Answer / ghanshyam vrema

USING ADO Command Object

Is This Answer Correct ?    1 Yes 5 No

Post New Answer



More VB Script Interview Questions

I want good books or good sites for scripting.Can any one help me.

0 Answers   Wipro,


we executed QTP scripts in one browser(i.e IN)same scripts is working on another browsers or not (i.e mean netscap,m azol..like )

6 Answers   Accenture,


What is the difference between Javascript & Vbscript?

2 Answers  


please can you help me to get a code of flames using a visual basic 6

0 Answers  


Anyone have qtp11.0 crack?

0 Answers  






What is the use of "Option Explicit"?

2 Answers  


Write a VB Script to count blank Lines in a notepad

2 Answers   IBM,


Sub link() Dim k As Integer Dim rand As Integer Dim URL As String Dim foldernum As Integer Dim folderstring As String Dim filenum As Integer Dim filestring As String k = 1 'for AC Numbers For i = 11 To 40 foldernum = 0 foldernum = 1000 + i folderstring = CStr(foldernum) folderstring = Mid(folderstring, 2, 3) folder = "ac" & folderstring 'folderstring = Sheets(2).Cells(i, 1) ' for Number of Random files For j = 1 To 10 rand = Int(Rnd * (200 - 1) + 1) filenum = 0 filenum = 1000 + rand filestring = CStr(filenum) filestring = Mid(filestring, 2, 3) 'URL = "http://ceobihar.nic.in/PSCDROM/ac" & folderstring & "/i" & folderstring & "0" & filestring & ".pdf" URL = "http://www.elections.tn.gov.in/pdfs/dt1/" & folder & "/" & folder & filestring & ".pdf" ' URL =http://www.wb.nic.in/wbeco/EROLLS/PDF/English/A001/a0010105 .pdf Cells(k, 1) = folderstring Cells(k, 2) = folder Cells(k, 3) = filestring Cells(k, 3) = URL k = k + 1 Next j Next i End Sub plz define it

0 Answers  


How to generate 3 digit random number?

3 Answers   Virtusa, IBM,


Hello All, In QTP 9.2 for Mozilla Firefox, there is webelement in my application, I tried to click on that using decsriptive programming, but it does not work. and for this i tried this code too: Set obj = CreateObject ("Mercury.DeviceReplay") absx = Browser("").Page("").WebElement(".").GetROProperty ("abs_x") absy = Browser("").Page("").WebElement(".").GetROProperty ("abs_y") obj.MouseMove absx, absy obj.MouseClick absx, absy, 0 But it is not clicked. Can anyone help me out for this problem. Thnx in Advance

1 Answers  


Can we create Crystal Report object in QTP?If yes then what it is and what are its various properties?

0 Answers  


print the array values in ascending order?

2 Answers   CSS Corp,






Categories