Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server

Recursive query for nomenclature like table with parent contains sum of all cost from children

A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause in UPDATE

sql sql-server database

How can I get the difference of two dates from different tables and generate it as a summary using SQL query?

incorrect format for an int

Dapper parameterized query for string value causing issues?

c# sql sql-server dapper

multiple count on derived table

sql-server derived-table

SSIS: Conditional Split result to variable

sql-server ssis etl

How to update values from a table using a NTILE function?

sql-server t-sql

How to measure query duration without showing results of query?

sql sql-server

c# execute SqlCommand with Parameters in "using" code block

Create foreign key constraint on JSON column

json sql-server t-sql

Error in @@ROWCOUNT inside SQL Server 2019 UDF

SQL Server threads - one does all the work, the other MAXDOP - 1 (5..30) do nothing

Oracle equivalent of T-SQL SET @var = @var + ' ';

selecting digits right of the last zero in SQL Server

sql sql-server t-sql

How to insert an integer value into a textbox using stored procedure calculations?

c# sql-server

Example of OUTPUT clause to get Identity with ado.net?

c# sql-server ado.net

How can we use EXEC sp_executesql for two dynamic SQL statements?

Determine dates by number of days, "what date is 180 days from now

sql-server datetime

How to import a shape file into SQL Server?

sql-server shapefile