How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))?????
can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)?
31
You have modified 100 store procedures and want to
replicate these changes from development to prodution, and
production can have users using the Server/DB, how would
you replicate without causing issues?
38
what are questions asked in TCS for database tester
(sqlserver)for 2-3 exp?
Write a Select Query to display title for each group of
records, which are collected with Compute Clause?
Like
titlefield
column-A column-B .....
.....
.....
Sum
...
titlefield
column-A column-B .....
.....
.....
Sum
...
How to write the storeprocedure with in the store procedure?
and how can we write the store procedure with in a trigger
vice versa? plz post me the exact answer?
my problem is tempdb
tempdb(dbname) 77752.95 MB(db size) 25345.03 MB
(unallocated size)
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.
if a parameter is not send to a stored procedure what type
of identifier is to be used in Stp and if that parameter is
not feed to the a query inside the Stp how to validate with
out useing IF condition
Scalability, Availability, Integration with internet, etc.)?
65
i use few third party softwares. they r all having their
own databases .
but the data is repeated in all these databases - say a
person is in all the three databases, but his name is
stoared in diff format in all databases
i want to create a centralised database ,and i dont want to
re-enter the records .
using the exisating records how can i build a centralised
database?
76
Which command displays the SQL command in the SQL buffer,
and then executes it?
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
