What are the 2 types of classifications of constraints in the sql server?

1123

How do I run sql server 2014?

998

What does select 1 mean?

927

What are different types of join?

1315

What are triggers? How do you invoke a trigger on demand?

1318

Where sql server usernames and passwords are stored in a sql server?

989

How do you delete duplicate records in sql server?

1056

what is datawarehouse?

1114

Do you know what are the steps to process a single select statement?

974

What are cursors in ms sql server?

1179

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.

1594

What is difference between delete & truncate commands?

1083

What stored by the tempdb ? : sql server database administration

1047

How to create user defined functions with parameters?

1235

What is page in sql server?

947