| Other SQL Server Interview Questions |
|| Asked @
|Name three version of sql server 2000 and also their
|Creating Tables Using SELECT
|What is the difference between Stored Procedure , Function
1. how many blocks in Package and what are they.
|How To Change Column Ordinal Position in SQL Server 2005
using Query i.e I Want To Add Column at Particular Ordinal
Position in SQL Server 2005
|What are the various Isolation levels?
|How many types of indexes are there in SQL Server?
|can any one say how to update the following senario
I have a table <srabank>
in which the table structure is as follows
ANAME ACCNO LOCATION ACCTYPE BAL
SBanuPrakash 31518746291 Punganur deposit 4000
Sreenivas 31518746292 mahoobnagar current 14000
Ranjith 31518746293 Karimnagar Savings 2000
Giresh 31518746294 Chennai deposit 40000
Boo 31518746295 Chennai Savings 20000
Jay 31518746296 Valachari Savings 1000
tirumalraj 31518746297 Vellore Savings 8000
The senario is
We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account .
in the from account the amount need to be reduced and in the to account the amount needed to be added.
for the <accountno> <31518746291> the balance is <4000>
for the <accno> <31518746292> the balance is <14000>
after transferring the balance the details will look as follows
<accno><31518746291> <bal> <2000>
<accno><31518746292> <bal> <16000>
the above mentioned two statment will come under the final result.
|select names starts with a,b,c
|wat is mean by trigger?.......normally wat use......when
trigger used in sql...........
plz cleary say with example.......
|Can a stored procedure call another stored procedure. If yes
what level and can it be controlled?
|When do we use the UPDATE_STATISTICS command?
|There are two tables (T1, T2) with different rows. Find the
output of query. Select count(*) from T1,T2.
|For more SQL Server Interview Questions Click Here |