-
How many trigger we can create on a table? How many column we can create in a table?
Janmejay Rout
- Jul 13th, 2015
Hi,
You can create 12 triggers on a table.
indira_priyadarsini
- Jul 29th, 2009
Only 3 triggers can be created on a table. i.e (Insert,Update & Delete)and Maximum of 1024 columns can be created in a table.
-
now i want the result as
(248)9078905,(234)5678909 into another table called phone2.
">Hi Guys,i have an interview question. can anyone help me reg this.i have a table called "phone" and filed as "phone number" and table have values like 2489078905,2345678909now i want the result as (248)9078905,(234)5678909 into another table called phone2.
SURESHMALLIPEDDI
- Aug 9th, 2011
Select '('||substr(phone,1,3)||')'||substr(phone,4) "formated phone number",phone from phone
paresh Borad
- Aug 1st, 2011
Use this query
create table newphone as (select '(' || substr(phnumber, 1,3) || ')' || substr(phnumber,4,10) "phonenumber" from oldphone) -
how do i print the call letter of Infosys?I mean should i print it directly with my account details or paste it to a word document?
Swapna Gentyala
- Oct 30th, 2006
Dont Copy or save into Word document...You just goto File option in the Menu bar and click on Print. It prints the whole page inlcuding the person from whom you got the mail (reference from Infosys) and your mail id which tells you are the receipant of that mail.
-
What is Connection Pooling?
subrataadhyaroy
- Mar 11th, 2008
Connection pooling is the ability of re-use your connection to the Database. This means if you enable Connection pooling in the connection object, actually you enable the re-use of the connection to more than one user.
gptnitesh
- Sep 11th, 2007
Connection pooling is the process of managing the connections effectively and efficiently by optimizing the usage of database connections.The way the connection pooling works is,1. It initializes a po...
-
What is Diff. Between Use Defined Function and Array.
lalita.p
- Dec 9th, 2006
Array is collection of variable of similar datatypes saves unser the same name.while user definded function are like the store procedures but more effective than store proceures.we can pass the parame...
Swapna Gentyala
- Oct 30th, 2006
An array is a collection variables of similar datatypes. User Defined Function is a set of Visual Basic statements which accepts one or more parameters and perform the operations defined in the body of the function and return a Value to the Calling program
-
Define class, module and access specifiers.
mayankbhatnagar
- Jan 5th, 2010
Class is a reserved data type which is used to encasulate similar type of methods and objects. For eg Cars is a class which holds Maruti 800 as object in it and tyres, seats etc are its methods ...
chintan.desai
- Jul 31st, 2009
Class is a type where you can create your own type. Just as int data type in .Net which takes only integer values and having default API's such as toString(). Similarly, you can cre...
-
I want to show user a dialog box(modal window - already ready) when user deletes any task on ultragrid and hits on save button on main screen, this modal window should get displayed on screen, stating that user has to enter comment/reason for deleting that task, how i can show that modal window, pl explain its needed very urgently.
lalita.p
- Dec 25th, 2006
Hi,I am giving u an example see whether it helps or not.dim str as stringstr=msgbox("do u what to give reason?",vbquestion)if str=vbyes thenstatementend if
-
-
-
What is Server Object?
Controls the ASP execution environment. It can set the amount of time script can run before an error occurs. Converts a virtual path to a physical path on the server. Takes a user supplied string and encode it into proper format for a URL string.
Swapna Gentyala
- Oct 30th, 2006
Server ObjectThe ASP Server object is used to access properties and methods on the server. Its properties and methods are described below:PropertiesProperty Description ScriptTimeout Sets or returns t...
