How to get a list of columns using the "sys.columns" view in ms sql server?

965

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1140

How to dump a table from a database.

1030

What is the full form of dba?

623

State the difference between local and global temporary tables?

1128

How to define a data source name (dsn) in odbc manager?

1046

Is pl sql and postgresql same?

1144

How to commit the current transaction in oracle?

1139

How to convert numeric expression data types by assignment operations?

1098

What is optimistic concurrency control? : Transact sql

996

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

986

wat wil hapn if we give the both read and deny read permission to user?

2120

Is sql port 1433 encrypted?

1039

explain about mysql and its features. : Sql dba

1023

What is the difference between form and report in ms access?

918