Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged tsql

0 votes
913 views
1 answer
    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
    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
639 views
1 answer
    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.2k views
1 answer
    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
625 views
1 answer
    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
572 views
1 answer
    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
651 views
1 answer
    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
492 views
1 answer
    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
583 views
1 answer
    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
894 views
1 answer
    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
648 views
1 answer
    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
710 views
1 answer
    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
    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
568 views
1 answer
    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
551 views
1 answer
    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
646 views
1 answer
    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
718 views
1 answer
    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
544 views
1 answer
    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
690 views
1 answer
    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
520 views
1 answer
    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
    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
498 views
1 answer
    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
608 views
1 answer
    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
656 views
1 answer
    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
448 views
1 answer
    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
556 views
1 answer
    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
632 views
1 answer
    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
524 views
1 answer
    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)
Ask a question:
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...