How do you write an SQL insert statement?
Answers were Sorted based on User's Feedback
Answer / srinivas reddy
In SQL Insert statement is
insert into tablename values(columnname1 datatype,
columnname2 datatype........)
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / pravati
INSERT INTO tablename(column name1,column name2,column name3....)
VALUES(value1,value2,value3...)
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
There is a web Table where You will find Two Columns First Column consist of Check box and Second column consist of Test cases ID(Viz T1,T2,T3....Etc); If You select any Test case ID, respective Check boxes to be checked write a VBSCRIPT for this scenario?
Am working with web application. i faced one senario. i.e, webpage having webtable having two coloumns, in that first coloumn is for serial no and second coloumn is for mac address link, now i want to get first row second coloumn value, that having macaddress as link. Please help me how to get that link?
How to make sure that items in a wintree are sorted al?
filter the array values without using filter function?
How to remove the spaces in a string Ex: "Welcome to QTPWorld" ?
How to select a value from a list box by using Selenium web-driver?
How will you trim the spaces on the left of a string using vbscript?
Program to use input box and send even numbers into sheet1 and odd numbers into sheet2 and prime numbers into sheet3 using vbscript(QTP)?
hai..friends ....what is the difference between function and sub procedure ....here every one know's theoretically here my question is what is the meaning of function can return the value and sub can't return the value...can you give one example with some values for that ....what does it mean ? how function can return the value...sub can not...any one please...........with example
1.I want to establish connection with excel and also want to fetch the data using SQL queries. 2.the code should be written in such a way that in future if I want to migrate from excel to MS excess database , then there should be minimal changes.
What are lbound and ubound in the vbscript language?
What is the difference between function and procedure?