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  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 
Is it possible to create tables in stored procedures using 
a variable for the table name?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Is it possible to create tables in stored procedures using a variable for the table name?
Answer
# 1		 
create proc ShowMeHow
as

declare @Cities table(
   AirportCode char(3) not null primary key,
   CityName varchar(255) not null
)

insert into @Cities values('LAX', 'Los Angeles')
insert into @Cities values('ORD', 'Chicago')

select * from @Cities
go
 
Is This Answer Correct ?    2 Yes 0 No
Skybeaver
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the difference between having and where clause?  3
What is a trigger?  3
What is blocking and how would you troubleshoot it?  1
syntax for deleting the database in T SQL  3
What types of integrity are enforced by a foreign-key constraint  1
What's the difference between a primary key and a unique key?  3
What is Query Execution Plan? How does it help optimize or tune a database driven application? Accenture1
What is the use of DBCC commands?  1
What is the datatype returned by count(*) Asian-CERC16
hi i gone though satyam interview. what is Acid Properties? Satyam2
how to retrive only second row from table in sql server 2000? CTS7
What does the INSTEAD OF trigger do?  2
In clustered and non clustered indexes which one is faster while executing a query ?  1
How to determine the service pack currently installed on SQL Server? HCL2
What is BCP? When do we use it?  1
What is a cursor in SQL Server 2000 and their types?  2
why cluster and non clusterindex are used in sqlserver 2000? explain with example  1
What are the type of Indexes? which one is best, why?  5
Can you explain the role of each service?  1
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply Covansys1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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