MS-SQL Server - DT-CITL & परिदृश्य

DT-CITL & परिदृश्य

Drop Table, Change Isolation Transaction Level & Scenario

https://learn.microsoft.com/en-us/sql/t-sql/statements/drop-table-transact-sql?view=sql-server-ver16

Change Isolation Transaction Level

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver16

Partitioned Tables and Indexes

https://learn.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver16

Download Microsoft JDBC Driver for SQL Server

https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16

Linked Server
https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-ver16

One Scenario Based Question

For example a single column in a table that is having either a single digit (0-9) or a single character (A-Z). Write a SQL query to print ‘Gold’ for a numeric value or ‘Silver’ for alphabetical value for all values in that column.

Example:

{'A', 'S', 'T', 3, 'M', 1, 6, 2 ,7,'V'}

... output:-

{'Gold','Gold','Gold','Silver','Gold','Silver', 'Silver', 'Silver','Silver','Gold'}

Best Regards

T. Amit Vaid S.