ehat is the default port no of sql 2000?
Answers were Sorted based on User's Feedback
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h
What do you do in data exploration
What do you mean by an execution plan? Why is it used? How would you view it?
How to write a query with a full outer join in ms sql server?
What are Spatial data types in SQL Server 2008
how to create a scrollable cursor with the scroll option? : Sql server database administration
How to create a view with data from multiple tables?
When would you use the stored procedures or functions?
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?
Where are SQL server users names and passwords are stored in sql server?
Explain the use of containers in ssis and also their types?
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,
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)