Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
How self join is different from outer join?
Explain transaction server isolation?
What are the differences between char and varchar in ms sql server?
what purpose does OPENXML clause have in sql server stored procedure?
What is the difference between varchar and nvarchar datatypes?
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 inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Explain the etl (extraction, transformation, and loading)?
In which files does sql server actually store data?
Explain “not null constraint” in sql server?
What are the limitation of the Online Index Rebuild Operation?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
What is the maximum size of column 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)