Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server

Call a stored procedure in multi scalar table-valued function?

Query Slow in Linq, Fast in LinqPad, SQL Management Studio and SQL Profiler

sql-server linq

How do create the transaction for particular connection only in sql?

c# sql-server t-sql

Table join on dynamic table names

sql sql-server t-sql join

NamedParameterJdbcTemplate causing an unwanted Metadata call

Selecting based on many to many filter

sql sql-server

Limit number of rows to be exported using SQL Server Import Export wizard

sql-server ssms

Filter by IS NOT NULL AND in sql

Delete all but top record in SQL server

Use table hints with variable table

Capture Linked server queries using SQL Extended Events

Deprecated feature 'DROP INDEX with two-part name' is not supported in this version of SQL Server

Text/string analysis in SQL Server

PHP Deprecated: Automatic conversion of false to array is deprecated adodb-mssqlnative.inc.php on line 154

Getting top n latest entries from SQL Server full text index

What is the difference between using `IF @@TRANCOUNT > 0` vs `XACT_ABORT` approach to rollback transaction? When do I use either of this approach?

sql-server t-sql

Connect to a database from Web.Config <appSettings> section C# / MVC

How to ignore string value using unpivot function finding the min value among other columns