What is Data model and how to prepare a data model.?
What is dirty page?
How to enforce security in sql server? : sql server security
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
What are different backups available in sql server?
how would you improve etl (extract, transform, load) throughput?
How to convert numeric expression data types using the cast() function?
Is sql server 2016 free?
What is the language structure to add a record to a table?
How we can refresh the view?
hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting
How to use group functions in the select clause in ms sql server?
What are triggers? How do you invoke a trigger on demand?