How to update existing rows in a table?
Answer / priyanka rani
By using Update statement. For example Update table_name set column_name='value' where column_name='your condition'
if required use where condition
Is This Answer Correct ? | 0 Yes | 0 No |
Which are new data types introduced in sql server 2008?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What is the parse query button used for?
What is trigger and different types of Triggers?
Explain the architecture of ms sql reporting service?
What do you understand by mirroring?
How to create new tables with "select ... Into" statements in ms sql server?
How to remove duplicate rows from table except one?
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
What is the use of group by clause?
What does it mean to normalize a database and why would you do it?
Where are full-text indexes stored?