Find Nth highest salary using RANKING functions
Suppose you want to find nth highest salary from a table,Then
you can use DENSE_RANK() function.Here i show some example that...
2012-12-19
50,509 reads
Querying Microsoft SQL Server
Partitioning Table in SQL Server:
Partitioning Table in SQL Server: When your database has large tables. Then partitioning will be beneficial
in terms of performance, scalability and maintainability....
2012-12-10
1,320 reads
Sending Querying Data on Mail as Attached File
Sending
Querying Data on Mail:
Sometimes we need to send data fetched from query on
mail automatically. You can
create report and after running...
2012-12-07
733 reads
Linked Server setup with Oracle
Linked Server
Setup with Oracle in SQL Server:
Suppose you want to access data from
oracle or other database products using T-SQL via...
2012-10-23
2,258 reads
Basics of Triggers in SQL Server
Querying Microsoft SQL Server : Basics of Triggers in SQL Server: SQL Triggers: A trigger is a procedural code like stored...
2012-09-29
1,407 reads
Basics of Indexes in SQL Server
Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in...
2012-09-29
1,278 reads
Connection String from Visual Studio
Querying Microsoft SQL Server : Connection String from Visual Studio: Connection String: A connection string contains connection information need to connect...
2012-09-22
879 reads
Data Types in SQL Server
Querying Microsoft SQL Server : Data Types in SQL Server: Data Type Description Remarks BIGINT Used for large Integer data.(Range -2^63 ...
2012-09-22
393 reads
Functions in SQL Server
Functions in SQL Server: Functions in SQL Server In SQL Server functions are subrotienes that encapsulate a group of T-SQL...
2012-09-22
597 reads
Error Handling in T-SQL
Error Handling in T-SQL: Error handling in T-SQL: Error handling in T-SQL is similer to other programming languages as C#,C++,Java.A...
2012-09-22
622 reads
Blogs
Speaking at the 2025 PASS Data Community Summit
By Brian Kelley
I will be back in Seattle this year attending the 2025 PASS Data Community...
The Book of Redgate: Motivation
By Steve Jones
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...
A Six Week Break
By Steve Jones
Today is my last day of work for six weeks. I start my sabbatical...
Forums
Three Times a Day
Comments posted to this topic are about the item Three Times a Day
SUM([value]) and highest record type
Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...
should i expect data types in task->export data from ssms?
Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...
Question of the Day
Multiple Defaults
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers