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
What are sub reports and how to create them?
Is it true, that there is no difference between a rule and a check constraint?
Explain the database you used in your final year project?
How to access the deleted record of an event?
What is a data collection table?
What is replication with database mirroring? : sql server database administration
What action plan is preferred if sql server is not responding?
what is a transaction? : Sql server database administration
can a table be moved to different filegroup? : Sql server administration
please differentiate between delete and truncate?
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?
What is the report builder?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What program is used to store the data source file?
Which tcl commands are available on the sql server?