If a stored procedure is taking a table data type, how it looks?
Answer / 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 |
what is an extended stored procedure? : Sql server database administration
What are the disadvantages of merge replication?
How do I run a trace in sql server?
What is normalization according to you and explain its different levels?
What is the default fill factor value?
What is order of B+tree?
What is difference between clustered and non clustered index?
Explain transaction server auto commit?
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)