| Other SQL Server Interview Questions |
|| Asked @
|When do we use the UPDATE_STATISTICS command?
|What is referential integrity? What are the advantages of it?
|How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.
|How can your resolve deadlocks?
|what is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?
|my problem is tempdb
tempdb(dbname) 77752.95 MB(db size) 25345.03 MB
suppose i increased temp db size 10 gb . after increase the
temp db showing
87 gb (dbsize) 25346.03MB(unallocated
size)--unallocated size is showing same .please clarify.
|what is Equity join?
|write sql program to get the detail of student in a class?
|Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
Can you give me the required sql query
|How do we get current date in SQL Server 2000, Oracle, MS
I need query help for below senorio, could you please help
TableName = City
CITYID ContinuationID CITYNAME
1 1 SAN
1 2 DIEGO
2 1 SAN
2 2 FRANCISCO
3 1 CHICAGO
4 1 NEW
4 2 YORK
4 3 CITY
Could you please help me to write a generalized SQL that
returns results as given below in the
CITYID NAME1 NAME2 NAME3 NAME4 NAME5
1 SAN DIEGO
2 SAN FRANCISCO
4 NEW YORK CITY
|how to update a null value field in sql server
a table contains 3 fields id,name,salary
and 3 records
salary of 1 record is null
i want update the nullfield
111 arun 300
112 ddd 200
113 ttt null
i want to update table with add 100 to every record include null
the recrds should be
111 arun 400
112 ddd 300
113 ttt 100
|For more SQL Server Interview Questions Click Here |