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 isnull() operator?
Tell me about normalization in DBMS.
What are rows and columns?
Explain the properties of sub-query in sql server?
What are group functions in query statements in ms sql server?
Wht is the difference between stored procedure and trigger
How to truncate a table first before running a package?
What is Left Outer Join?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Explain fundamentals of Data ware housing & OLAP?
What are binary string data types in ms sql server?
How do I create a stored procedure in dbml?
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)