plz send every query in sql server2000
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
What the different types of Replication and why are they used?
Can you tell me the difference between DELETE & TRUNCATE commands?
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 are the different authentication modes in sql server?
what's the information that can be stored inside a bit column? : Sql server database administration
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
can a table be moved to different filegroup? : Sql server administration
What is exporting and importing utility?
Where sql server usernames and passwords are stored in a sql server?
What happens if the update subquery returns multiple rows in ms sql server?