sql-servertsql-CodePudding

Tags > sql-servertsql

02-05EnterpriseConverting subquery into window function
02-03NetGetting individual dates from a date range using T-SQL
02-01databaseConvert date into YYYYMMDD HH24:MI:SS format
01-31Software designGet database name dynamically
01-30MobileThere is already an object named 'name' in the database - stored procedure error - SQL Ser
01-28EnterpriseReplacing words in a string
01-27BlockchainHow can a constraint be violated when the SQL query excludes it?
01-24MobileHow to flag a group of columns based on data in a second column?
01-11NetCan I use the IF ELSE SQL statement without BEGIN and END?
01-09MobileHow do I update column with NULL values
01-08Software designHow to pivot data without aggregations and with variable amount of columns?
01-07NetHow to convert nvarchar to numeric
01-06Back-endReturn Customer ID if all records added in the same month
01-05otherSpecial character in JSON_VALUE in MSSQL 2017
01-04NetCompare two columns, identify duplicates and select a larger integer if available in the other colum
12-30BlockchainDoes NOT EXIST (in the absense of where clause in the subquery) implicitly assume that where clause
12-22front endSQL Server - How to remove duplicates within select query?
12-16databaseHow to use an INTEGER value to perform a lookup into a STRING array in a SQL SELECT statement and re
12-15MobileT-SQL CAST only failing when within IN clause
12-10otherBehavior of TOP with WHERE clause . Why is this query returning a value instead of NULL?
12-09NetHow can I combine 2 existing data with the same Id Li from a single column time data, one as the sta
12-09Software engineeringWhat is "dummy" in CREATE PROCEDURE statement
11-28NetUPDATE column on ORDER of another column
11-28NetUPDATE field on ORDER of another field
11-13BlockchainStoring Email addresss in SQL Server
11-10Software engineeringMerge multiple lines into one
11-10EnterpriseHow to pass single quote string to a stored procedure in SQL Server?
11-09OSCombine two consecutive dates in different rows
11-03MobileHow to group the recipe base with the datetime wise
11-03Software engineeringHow can I get all of them after the second "_" separation in a string data in mssql?
10-31Back-endHow to find consecutive numbers like 123456 in a column in SQL Server
10-31Back-endERROR Message- "Foreign Key '... ' references invalid column '...' in refer
10-26OSTSQL How to select element by index in a grouped query
10-25OSGenerate rownumber based on table result from an sp
10-14Software engineeringSet session attribute that is readable from external
10-13NetGet value from multiple tables in all databases on MSSQL server
10-12Software designwhat happen if has free space in datapage on mssql server
10-07OSConvert data stored as varchar in DD MMM YYYY format to DATETIME
10-06BlockchainHow can I control several columns at the same time?
10-04Software designT-SQL Grouping Dynamic Date Ranges

47 1 2 Next Last