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 are sub reports and how to create them?

113


Is it true, that there is no difference between a rule and a check constraint?

690


Explain the database you used in your final year project?

712


How to access the deleted record of an event?

745


What is a data collection table?

723






What is replication with database mirroring? : sql server database administration

701


What action plan is preferred if sql server is not responding?

766


what is a transaction? : Sql server database administration

646


can a table be moved to different filegroup? : Sql server administration

715


please differentiate between delete and truncate?

732


What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

805


What is the report builder?

119


What is use of attributehierarchyenabled? : sql server analysis services, ssas

799


What program is used to store the data source file?

672


Which tcl commands are available on the sql server?

771