Sawaal
  • Home/
  • Searching for L

 Searching for "L"

Q:

Write SQL Query to display current date?

Answer

The built in function called GetDate() returns the time stamp.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Difference between a query and a statement in SQL?

Answer

An SQL statement is a string of characters that conforms to the syntax and format specified in the international standard.


A query is a statement that returns a record-set.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Write an SQL Query to find employees whose name starts with an ‘M’?

Answer

SELECT *FROM Employees WHERE EmpName like ‘M%’.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Define a temp table.

Answer

In a nutshell, a temp table is a temporary storage structure. It means you can use a temp table to store data temporarily so you can manipulate and change it before it reaches its destination format.


In table_user.gender column change ‘male to female’ and ‘female to male’ in one SQL statement.


UPDATE table_user


SET gender =


CASE gender


WHEN ‘male’ THEN ‘female’


WHEN ‘female’ THEN ‘male’


ELSE gender


END

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

How to create recursive query in SQL Server?

Answer

Recursive query can be create in SQL using stored procedure but you can also use CTE (Common table expression). It might be also worth asking about performance as CTE is not always very fast.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Which command using Query Analyzer will give you the version of SQL server and operating system?

Answer

SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel') and SERVERPROPERTY ('edition').

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

What is SQL Server Agent?

Answer

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). Its purpose is to ease the implementation of tasks for the DBA, with its full- function scheduling engine, which allows you to schedule your own jobs and scripts.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Which TCP/IP port does SQL Server run on? How can it be changed?

Answer

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL