What are different types of schemas?
What are data files?
What languages bi uses to achieve the goal?
What is policy based management (pbm)? : sql server database administration
how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100
When you first load SQL SERVER you will startup with what all databases?
Can you explain different types of joins?
Where the sql logs gets stored? : sql server database administration
Explain magic tables in sql server?
What is equi join with example?
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
What is the use of floor function in sql server?
How self join is different from outer join?