Recent questions tagged TSQL

0 votes

905 views

1 answer

tsql - SQL Server 2008: how to format the output as a currency

I have a query string which returns a value that has several decimal places. I want to format this to a ... a currency with 2 decimal places. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

tsql - T-SQL: issue with string concat

I have a set of audio files with names GreenLine1.mp3, GreenLine2.mp3 e.t.c. I'm going to write ... @variable, expected STRING, or TEXT_LEX See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

634 views

1 answer

tsql - SQL Server default values: why with one or two parentheses?

if you run this script to retrieve all default value definations in a database: select c.name as columnname, t ... exactly when scripting T-SQL? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

tsql - Transaction context in use by another session

I have a table called MyTable on which I have defined a trigger, like so: CREATE TRIGGER dbo.trg_Ins_MyTable ... record+execute the trigger? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

610 views

1 answer

tsql - How to update multiple tables at the same time?

I'm trying to update fields from three different tables but I'm getting some errors: UPDATE a, b, c SET a. ... Line 2 Incorrect syntax near ','. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

566 views

1 answer

tsql - SQL SERVER - Understanding how MIN(text) works

I'm doing a little digging and looking for a explanation on how SQL server evaluates MIN(Varchar). I found this ... BOL a little better. Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

639 views

1 answer

tsql - SQL Server : Split string to row

How to turn data from below: CODE COMBINATION USER 1111.111.11.0 KEN; JIMMY 666.778.0.99 KEN 888.66.77 ... but my production is SQL Server 2014. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

481 views

1 answer

tsql - Recording SQL Server call stack when reporting errors

This is a follow up to the question Nested stored procedures containing TRY CATCH ROLLBACK pattern? In the catch ... () and ERROR_LINE(). See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

556 views

1 answer

tsql - T-SQL - how to swap rows and columns

I have a resultset structure like this ID Value Name 1 Oranges Reponse 1 42 Count 2 Apples Reponse 2 65 Count 3 ... a way to do this? thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

884 views

1 answer

tsql - SQLite equivalent of SQL Server DateAdd function

I need help reproducing the following SQL statement to a statement that SQLite understands. SELECT * FROM ... help is much appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

639 views

1 answer

tsql - How do I iterate through the Nodes of a XML Field in T-SQL?

I have an XML field that I know will have at least one "ChildNode" in it, but possibly more. I am trying to make ... nodes one by one in T-SQL? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

676 views

1 answer

tsql - SQL Convert Rows To Columns

I know this has been asked a few times before, but I can't find any solution that fits my example. I ... 0 Your help is much appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

tsql - C# Dapper using JSON_VALUE for SQL Server 2016

I want to query data from my table using JSON_VALUE: var str = "123"; var value = "Name" using(var conn = ... 123' How should I adjust my code? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

555 views

1 answer

tsql - How to list the source table name of columns in a VIEW (SQL Server 2005)

Just wondering how to list column name and table name in one query for a view. For example: A view named ... where table_name='viewC' together? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

546 views

1 answer

tsql - The proper way to implement unique constraint that allows multiple NULL values in SQL Server

I need 1 column in the table to hold unique non-null values or NULL. TSQL UNIQUE constraint treats 2 NULLs ... case? Thanks for your answers. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

634 views

1 answer

tsql - using CASE in T-SQL in the where clause?

Im trying to use case to vary the value im checking in a where clause but I'm getting the ... (select mwebID from tmp_csv_dawis_bruger0105) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

715 views

1 answer

tsql - How do I suppress the results from a stored procedure from within a stored procedure?

I've got a stored procedure (we'll call it A) that calls another stored procedure (we'll call this one B). ... complex than I want to mess with. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

536 views

1 answer

tsql - The proper way to implement unique constraint that allows multiple NULL values in SQL Server

I need 1 column in the table to hold unique non-null values or NULL. TSQL UNIQUE constraint treats 2 NULLs ... case? Thanks for your answers. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

667 views

1 answer

tsql - using CASE in T-SQL in the where clause?

Im trying to use case to vary the value im checking in a where clause but I'm getting the ... (select mwebID from tmp_csv_dawis_bruger0105) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

515 views

1 answer

tsql - How do I suppress the results from a stored procedure from within a stored procedure?

I've got a stored procedure (we'll call it A) that calls another stored procedure (we'll call this one B). ... complex than I want to mess with. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

tsql - Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"

When I run the following commmands in SQL Server 2012 exec sp_configure 'Advanced', 1 RECONFIGURE exec sp_configure 'Ad ... )". Any idea why? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

494 views

1 answer

tsql - SQL Server How to output one table result from multiple results with a WHILE query

From this answer: Is there a way to loop through a table variable in TSQL without using a cursor? I'm ... , Commission, TnnID FROM @Output; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

604 views

1 answer

tsql - How to remove duplicates from table using SQL query

I have a table which is as follows: emp_name emp_address sex matial_status uuuu eee m s iiii iii f s uuuu eee ... for this. an anyone pls help? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

637 views

1 answer

tsql - Convert to ASCII char in sql server

In Oracle I can convert ?êíABCDE to AEIABCDE using: SELECT CONVERT('?êíABCDE', 'US7ASCII') from dual; Output: ... do the same in SQL Server? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

444 views

1 answer

tsql - Query AD Group Membership Recursively Through SQL

Background I'm creating some SQL to assist with security auditing; this will take security info from various systems ... now run it exec(@sql) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

545 views

1 answer

tsql - T-SQL: Salted Passwords

I am looking for an example of salting passwords withing a T-SQL Stored Procedure. And of course the matching ... 50), @Password nVarChar(50)) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

620 views

1 answer

tsql - Compare two sets of XML data using XQuery in SQL Server

Suppose I store employee data in a xml column in my log table. Sometimes data is also updated in the xml ... guide me with code snippet. thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

521 views

1 answer

tsql - Find duplicates in SQL

I have a large table with the following data on users. social security number name address I want to find all possible ... name <> t2.name) > 1 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags