ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
how to give input dynamically to a insert statement in 
sqlserver
 Question Submitted By :: Y Babu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how to give input dynamically to a insert statement in sqlserver
Answer
# 1
Declare @sql_tmp varchar(100)

set @sql_tmp="insert into table1(col1,col2..)
select 'val1','val2','') "

sp_executesql @sql_tmp
 
Is This Answer Correct ?    0 Yes 1 No
Senthil Kumar.m
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?  1
Hi..here i would like to know the Backup and Restore models? HCL2
What is the basic functions for master, msdb, tempdb databases? CSC2
What is ACID Property of Transaction?  3
what is meant by sql injection with example and one more question how to catch the errors in sqlserver  1
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005  1
What is the difference between a Application Server and a Database Oracle1
i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj IBM5
Explain Active/Active and Active/Passive cluster configurations  1
What are the types of backup and tell me the difference between full and differential backup? TCS3
HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE TCS14
what is the importence of the trigger in sqlserver2000? ATI1
what is the main difference between constraints(like primary key etc..)& joins? Annik2
what are the joins,primary key,foriegn key, candidate key, super key and expain them?  2
i need some interview questions on sql server developer plz any onee send some links.  1
What are Magic Table? Evalueserve10
In which year relase the 7.0& 2000 & 2005?  1
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com Symphony19
Wht is SQL Injection Attack ?  1
what is difference between having and where clause ?  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com