Tag: t-sql


Found 881 results for 't-sql'.


1) sql-server - Is there an efficient way to match multiples headers that have the same set of details?
2) sql-server - Is there a T-SQL equivalent for punctuation as [0-9] is for numbers and [a-z] is for letters?
3) t-sql - Subqueries for JSON path where outer query is part of a UNION result in strings rather than JSON
4) sql-server - Why is SQL doing an index scan and seek with the same XML query structure?
5) sql-server - Problem in formatting result set in desired format
6) sql-server - Replacing NULL values with one string from provided list
7) sql-server - Select Into removes IDENTITY property from target table
8) sql-server - Find Ancestry From JSON
9) sql-server - Distinct Children rows ordered by a column of Parent
10) sql-server - Adding a varchar to a datetime column and dealing with nulls
11) sql-server - Export/import data from Excel into a table with queries
12) sql-server - Import CSV file - dynamic path
13) sql-server - Tsql help - doing a large update from CSV file to a table in ssms
14) sql-server - After Update Trigger When Multiple Rows To Update
15) sql-server - Trigger Not Updating
16) sql-server - Create Field With Default Value Of Different Field With No Data Loss
17) sql-server - How to update price where value of rows exist in value of column in sql?
18) sql-server - T-SQL CTE Compare previous non-NULL and current row to filter out by difference value
19) sql-server - Database design for one payment and monthly payments
20) sql-server-2012 - Setting Select Permission on 100+ tables in a database
21) sql-server - Matching a ] (closing square bracket) with PATINDEX using the "[ ]" wildcard
22) sql-server - Why do SQL Server row estimates change when I add a join hint?
23) sql-server - Optimize select on subquery with COALESCE(…)
24) sql-server - T-SQL: Assign identifier to block of results
25) sql-server - SQL Server Full-Text Indexer with stoplists/stopwords
26) sql-server - Is there an operator or an easy way to match an expression one or more times with the LIKE operator in SQL?
27) sql-server - String that contains letters representing a negative number
28) sql-server - Equivalent of Oracle RR date format in SQL Server
29) sql-server - Implicit conversion: when does it hurt performance a lot?
30) sql-server - Handling duplicate values using trigger
31) sql-server - Eliminate filter operator before columnstore index scan operator
32) sql-server - Handling sql column with mixed varchar and float data types
33) sql-server - how to convert this varchar to datetime format?
34) sql-server - Cast varchar into int, converting any value under 0 to 0
35) sql-server - SQL Server 2016 suddenly produces Error:402,State:1,Class:16 updating a sproc with DATETIME/DATE/TIME arithmetic, that was fine before
36) t-sql - Union from Multiple Tables in many databases and group results in batches of n
37) sql-server - Return All Data From Left Table
38) sql-server - Microsoft SQL Joins and Where Clause
39) sql-server - Combining data from multiple large tables
40) sql-server - The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values
41) sql-server - Aggregates per half hour intervals within a time span
42) sql-server - Full Outer Join With Where Clause
43) sql-server - SQL Formatting: Add Space within query result
44) sql-server - comparing left join and outer apply doing the same thing
45) sql-server - LEFT JOIN Producing Inflated COUNT() numbers
46) sql-server - SELECT Parent-Child with SORT
47) t-sql - Compare possible null values in one query
48) sql-server-2012 - Help with Replacing characters with text string chops of last character of string
49) t-sql - Simplifying Function with Recursive CTE and/or Window Function
50) sql-server - Forwarding records in #temp table