Na Knowledge Share Chesukundam Ani Anukuntuna.......

[karna11]

[quote name='ghazni' timestamp='1343610148' post='1302222890']
endi mama testing aaa..... leka doubt aaa..... ofcourse naku kuda help avtundi le....... idi t-sql kada......

aina konchem real time lo adogochu kada mama.......
[/quote]
interview questions mama nenu calls p**** tesukuntaaa akkada face chesina questions eee ivannii

[Basavayya]

GP.....SSRS interst undhi class eppudo Cheypu Baya...Nen vinta

[ghazni]

[quote name='karna11' timestamp='1343610646' post='1302222917']
interview questions mama nenu calls p**** tesukuntaaa akkada face chesina questions eee ivannii
[/quote]
good aitey mama...... u can ask me all questions so i can answer..........

nuvu adigina question ki answer .....

select top 4* from table order by column desc

isthat right.......

[ChampakDas]

this would be right with an assumption that the data in the column is ordered by asc
[quote name='ghazni' timestamp='1343611198' post='1302222948']
good aitey mama...... u can ask me all questions so i can answer..........

nuvu adigina question ki answer .....

select top 4* from table order by column desc

isthat right.......
[/quote]

[Kakateyudu]

[velpu]

[quote name='PMR aka OM' timestamp='1343604385' post='1302222713']

vaakey start chesaaka..

oka pm pettu .. paina visa thread lo first page lo ekkado oka chot kaasta doorchesta.. future lo janalu refer chesukuntaar..
[/quote]


ante PMR aka OM= afdb-sai?

[karna11]

[quote name='ghazni' timestamp='1343611198' post='1302222948']
good aitey mama...... u can ask me all questions so i can answer..........

nuvu adigina question ki answer .....

select top 4* from table order by column desc

isthat right.......
[/quote]

yaaa idhii righteee, not in top 10* koda use cheyyachuuu

[karna11]

[quote name='ChampakDas' timestamp='1343610500' post='1302222906']
If your question is "How to track what operations(like insert, update or delete) are done on a table?" you need to use triggers.
[/quote]
trigger operation tabel loo save ayyidhhaa with time instance thoo sahaa, naku anthaa idea ledhuu Db, just asking,
i working on .Net

[Vaampire]

[quote name='karna11' timestamp='1343607753' post='1302222813']
my question i want to maintaine the one table history(like inser , update , delete,) in othertable in same schemaa, how?
[/quote]
create triggers.

[Vaampire]

[quote name='karna11' timestamp='1343612417' post='1302222995']

yaaa idhii righteee, not in top 10* koda use cheyyachuuu
[/quote]
r u kidding me?

[quote name='karna11' timestamp='1343609662' post='1302222871']
okeee neekosam simple question, i have 1 table with only1 column with 14 records, i want retrieve the last 4 records?
[/quote]

nee question column lo values ascending order lo insert avuthayi ani cheppaledhu. interview lo ee question ki aa answer isthey pothadi bhayya.

question lo ichina info saripodhu.

[Vaampire]

[quote name='karna11' timestamp='1343612534' post='1302223002']
trigger operation tabel loo save ayyidhhaa with time instance thoo sahaa, naku anthaa idea ledhuu Db, just asking,
i working on .Net
[/quote]
nee yenki. trigger ante task assign cheyyadam. trigger lo emaina cheyyochu.

.net basha lo cheppali antey.
if x=y then
' perform some operations.
end if

trigger kooda same to same.
if insert statement then do some operation.

[ChampakDas]

Yes, it does. Create triggers on the respective operations. So, any operation on a table will trigger an action. Logic in the trigger will be to insert statements that will save what happened, time stamp etc etc.. endhuku
[quote name='karna11' timestamp='1343612534' post='1302223002']
trigger operation tabel loo save ayyidhhaa with time instance thoo sahaa, naku anthaa idea ledhuu Db, just asking,
i working on .Net
[/quote]

[chelsea]

[saritha24]

[quote name='karna11' timestamp='1343607753' post='1302222813']
my question i want to maintaine the one table history(like inser , update , delete,) in othertable in same schemaa, how?
[/quote]


Change Data Capture (CDC) : [url="http://msdn.microsoft.com/en-us/library/bb522489(v=sql.105).aspx"]http://msdn.microsoft.com/en-us/library/bb522489(v=sql.105).aspx[/url]