What is a transactions?

991

How to define the name and server for a new dsn?

1047

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

971

How to query multiple tables jointly?

933

What are sql server procedures?

944

What is the contrast between sql and pl/sql?

1094

What is the full form of ddl?

880

What is change tracking in sql server?

958

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

925

Explain datetime2 data type in sal server 2008?

875

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1007

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1027

Do you know what is xpath?

1024

Explain linked server in sql?

1172

What is the difference between substr and charindex in the sql server?

1027