Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins
I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types...
2010-01-02
24,842 reads
Vivek's SQL Notes
Sql Server- Difference between Stored Procedure and Function
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to...
2009-12-22
2,178 reads
Difference between Delete and Truncate Command
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...
2009-12-17
1,254 reads
Sql Server - How to write a Stored procedure in Sql server
Stored Procedure:-Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are...
2009-12-05
1,504 reads
Sql Server - Union and Union All
Union and Union All, both are used to select data from one or more than one tables but still they...
2009-11-17
4,489 reads
IDENTITY Property in SQL Server
IDENTITY PropertySometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose,...
2009-11-11
1,865 reads
Technology with Vivek Johari: How to make database offline or online
Technology with Vivek Johari: How to make database offline or online
2009-10-19
670 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Multiple Sequence Values
Comments posted to this topic are about the item Multiple Sequence Values
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers