SQL Server Development Questions

Questions and important topics in ASP.NET MVC SQL Server development, including queries, functions, stored procedures, views and tables

Script to create an index for a table variable

Table variables can have a non-clustered or a clustered index. Further, an order can be specified for index column(s). Script to...

Jan 52 min read

In SQL Server, if we try to INSERT rows using a SELECT ORDER BY statement as in the SQL mentioned below, then the inserted rows are not...

Jan 43 min read