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 |
Define DML and DCL statements?
explain the storage models of olap? : Sql server database administration
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the disadvantages of index?
Can two tables have the same primary key?
What is indexing in sql server with example?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is in place upgrade in sql server?
Which language is supported by sql server?
What new changes are being made in SQL Server?
Can we use where clause with group by?
What is the purpose of a table?
Oracle (3253)
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)