Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server

How to figure out how many tables are affected in database after inserting a record?

SCOPE_IDENTITY And Instead of Insert Trigger work-around

sql sql-server t-sql triggers

Why does the SQL language use IS NULL or IS NOT NULL instead of = NULL or <> NULL?

sql-server t-sql

How to convert Binary data in column to a file?

c# sql-server

How can I make T-SQL perform OPTION (FORCE ORDER) when defining views?

Remove xmlns="" name space declaration when using FOR XML EXPLICIT

Will TOP always return the same rows

Need to multiply rows based on Number column in SQL

sql sql-server

Computed column definition is null

sql-server

SQL - Finding common rows based on a column (intersect)

Subtotals and grand totals SQL Pivot

sql sql-server pivot

Localdb with the Configuration " MultipleActiveResultSets = True"

sql-server localdb

How to get primary replica info for the SQL availability group by powershell

rename a column in all the tables - SQL

sql sql-server

Does a full table scan read through all columns (for every row)?

Msg 9402, Level 16, State 1, Line 9 XML parsing: line 1, character 38, unable to switch the encoding

Edit asterisk symbol into list of column names in SSMS by wildcard expansion

SUM() takes less time than SELECT() in SQL. How it works?

Execute a Dataset based on parameter value -SSRS