SQL Server Interview Questions

Define frequently used joins, projections, and selections as views so that users need not specify all the conditions and qualifications each time an operation is performed on that data. Display diffe...

if you have created view and if you want to update something in view it will also be update in table

sp_help dbo.customers;

worked for me just fine.

Thanks to the OP, this runs perfectly on SQL 2008 R2, do not know about other versions

To see the structure (description ) of the table in Sql Server the followed command surely works....
sp_help person

Note:***
to display the structure of the table in Sql Server wer use the followed command ...it has the accurate rating ****
sp_help
sp_help person

yes,we can update the view as like a table.view is virtual table,basically it is not having any storage data. in a view data will be coming from table.if u delete the table .we wont update the view.

Yes but you remember views, represents a virtual table but if you delete the table you wont be able to update the view

sqldatareader means only read the datas in the table..
sqldataadapter means the datas read and writes

select ename from emp group by ename,sal having sal>5000;

If we want to check any values to retrieve the data,case is the best.Case statement is simple and easy to understand.

Code
SELECT case when sal>1000 then ename end
FROM emp

SELECT ID FROM TBLSAMPLE GROUP BY ID OR SELECT DISTINCT (ID) FROM TBLSAMPLE

Code
SELECT ID FROM TBLSAMPLE GROUP BY ID
OR
SELECT DISTINCT (ID) FROM TBLSAMPLE 

Good Code...however the code will delete all the duplicates... you may want to add:

delete top(n) clause in your delete statement to exactly delete the required number of records.

It is good.I understood if you put some brief explanation with data, is very usable to the persons who are not understanding about normalization like me. ...

Your Explnation may be good but it was too dificult to understand with out examples

SELECT YourColumn, COUNT(*) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

Code
SELECT EMAIL, COUNT(*)  "REPETED EMAIL" FROM EMP GROUP BY EMAIL; 

As a basic rule of query building: 1. The WHERE clause should be used to limit the number of rows returned by or affected by the a SQL statement. 2. The GROUP BY clause is used to group a selec...

From your SQL Server Management Studio, you open Object Explorer, go to your database where you want to load the data into, right click, then pick Tasks > Import Data. Select the options based on the excel file

Begin Try

--
--
End Try
Begin Catch

Declare @errMsg varchar(1000),@errSev int
select @errMsg=error_message(),@errSev=error_severity()
RaisError(@errMsg,@errSev,1)

End Catch

1) CLR is integrated in SQL Server 2005. Hence we can use below code for Exception Handling. BEGIN TRY SELECT * FROM Employees; END TRY BEGIN CATCH SELECT ERROR_NUMBER() ...

Try using Server Management Objects (SMO) classes

Covering Indexes are useful for Input / Output intensive workloads.
Covering indexes are smaller in size
Covering Indexes are sorted by values
It is easier to cache date in Covering Indexes

Covering Indexes cannot be used to select all the columns / entire table.

Try these and see...

Go To Options -> Run SQL
Set "Statement Delimiter" to None

Go To Options -> Technical Parameters
Tick "Use SQLExecDirect"

High Water Mark (HWM) represents total number of extent blocks used by a table. The value of High Water Mark could sometime be more then the actual size required/used by a table. This is because, some...

Steps to set / modify Global Setting for Query Studio: 1. Stop the Cognos 8|ReportNet server. 2. On the Cognos 8|ReportNet Server, go to the directory /c8|crn/templates/ps/async/ 3. Either create a n...