how to get rank of diffrent student in same table based on newly inserted row in sql server2008
what's the difference between SQL & MY-SQl...? And what we learn from these ....?2 4352
what is diffrent between store procedure and trigger2 2650
can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -2 2084
can any one say how to update the following senario
I have a table
syntax and example for bitmap index in sql???1 3011
One table how may column and Primary key3 2280
Simple example for difference between select and cursor in sql1 2543
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
If the job running very slow what is the action you do
what is checksum in sql server.........???
what are the Prerequisites for Replication?
what is the sql equivaent of the dataset relation object ?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Delete duplicate rows without using rowid.
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
how can you attach more than 20 ldf files in sql server
What is the difference between NOROW and LOCKROW?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Tell about MOM Tool(Microsoft Operator Manager)?