Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

If a stored procedure is taking a table data type, how it looks?

Answer Posted / yagnik rohit

declare @temptable table(col1 int,col2 int)
insert into @temptable select 1,2
select * from @temptable

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you know about normalization and de- normalization?

931


Can another user execute your local temporary stored procedures?

990


What is sql sandbox in sql server?

1233


What does select 1 mean?

937


Explain what is log shipping?

1139


Explain what you mean by 3 tier architecture.

1077


Explain various data region available in ssrs with their use?

936


Can foreign key be duplicate?

1067


Why use stored procedures in sql server?

1019


What is difference between index and primary key?

1101


what is a join? : Sql server database administration

1254


What are locks in sql?

986


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1006


What is the difference between nvl and nvl2?

981


Can you please differentiate between a primary key and a unique key?

1010