Tip 1
Viewing Table Schema Details. When table is binded to schema you will get error when u access ALT + F1. You can access it below way
EXEC sp_help 'Schema.TableName'
Tip2
Handy Query to check for SQL Server Version
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Tip 3
Handy Query to check on isolation levels in database (Check Snapshot isolation levels)
select is_read_committed_snapshot_on, snapshot_isolation_state, snapshot_isolation_state_desc, sys.databases.[name] from sys.databases
Tip 4
I found it a bit late - Month function to get month, Year function to get year, Day function
SELECT MONTH(GETDATE()), YEAR(GETDATE()), DAY(GETDATE())
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment