How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Why the trigger fires multiple times in single login?
How to choose all records from the table?
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..
17 Answers 3i Infotech, Rolta, TCS,
Define the term DML, DDL and DTL?
Mention the different types of triggers?
How can windows applications connect to sql servers via odbc?
What is the difference between char and varchar2 datatype in sql?
What is the use of group by clause?
What is the difference between a "where" clause and a "having" clause?
How to change the system date and time from SQL Plus Terminal ?
What is an execution plan? When would you use it?
What is the need for group functions in sql?