Recent questions tagged tsql

0 votes

523 views

1 answer

tsql - How do you drop a default value or similar constraint in T-SQL?

I know the syntax: ALTER TABLE [TheTable] DROP CONSTRAINT [TheDefaultConstraint] but how to I drop the default ... at CREATE TABLE time.) See Question&Answers more detail:os...

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

0 votes

478 views

1 answer

tsql - How to parse string into date?

How can I convert a String to a Date in T-SQL? My test case is the string: '24.04.2012' See Question&Answers more detail:os...

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

0 votes

619 views

1 answer

tsql - String.Format like functionality in T-SQL?

I'm looking for a built-in function/extended function in T-SQL for string manipulation similar to the String.Format method in .NET. See Question&Answers more detail:os...

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

0 votes

762 views

1 answer

tsql - How to ALTER multiple columns at once in SQL Server

I need to ALTER the data types of several columns in a table. For a single column, the following works fine ... 0), CM_CommodityID NUMERIC(18,0) See Question&Answers more detail:os...

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

0 votes

532 views

1 answer

tsql - T-SQL get SELECTed value of stored procedure

In T-SQL, this is allowed: DECLARE @SelectedValue int SELECT @SelectedValue = MyIntField FROM MyTable WHERE MyPrimaryKeyField ... I tried it!) See Question&Answers more detail:os...

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

0 votes

707 views

1 answer

tsql - How do I add string with auto increment value in SQL Server?

How do I add a string with auto-increment value in SQL Server? create table date (sno int 'emp_'+ ... need following as output emp_1 emp_2 See Question&Answers more detail:os...

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

0 votes

684 views

1 answer

tsql - Pivots with dynamic columns in SQL Server

I am working on an SQL Query using pvots with dynamic columns in SQL Server (T-sql). Rather than submitting ... hard coded? Thanks Leon Lai See Question&Answers more detail:os...

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

0 votes

553 views

1 answer

tsql - Is it possible to set start of week for T-SQL DATEDIFF function?

I use DATEDIFF function to filter records added this week only: DATEDIFF(week, DateCreated, GETDATE()) = 0 and I ... 0 in third column too. See Question&Answers more detail:os...

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

0 votes

693 views

1 answer

tsql - T-SQL calculate moving average

I am working with SQL Server 2008 R2, trying to calculate a moving average. For each record in my view, I ... data within a range of records. See Question&Answers more detail:os...

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

0 votes

628 views

1 answer

tsql - SQL Server A trigger to work on multiple row inserts

I am maintaining some code that has a trigger on a table to increment a column. That column is then ... trigger to avoid cursor based approach See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

tsql - Instead of trigger in SQL Server loses SCOPE_IDENTITY?

I have a table where I created an INSTEAD OF trigger to enforce some business rules. The issue is that when I ... How do I make this work? See Question&Answers more detail:os...

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

0 votes

469 views

1 answer

tsql - T SQL merge example needed to help comprehension

The following: MERGE dbo.commissions_history AS target USING (SELECT @amount, @requestID) AS source (amount, request ... with this mechanism. See Question&Answers more detail:os...

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

0 votes

911 views

1 answer

tsql - Truncate Datetime to Second (Remove Milliseconds) in T-SQL

What is the best way to shorten a datetime that includes milliseconds to only have the second? For example 2012-01-25 ... 2012-01-25 17:24:05 See Question&Answers more detail:os...

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

0 votes

636 views

1 answer

tsql - How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?

According to BOL (SQL Server Books Online) on sp_dbcmptlevel, This feature will be removed in a future version ... level without using GUI? See Question&Answers more detail:os...

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

0 votes

830 views

1 answer

tsql - How to change default language for SQL Server?

Now when I query SELECT @@language it gets 'us_english'. But I need russian. I can't use SET LANGUAGE russian ... (for all new sessions). See Question&Answers more detail:os...

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

0 votes

768 views

1 answer

tsql - Find non-ASCII characters in varchar columns using SQL Server

How can rows with non-ASCII characters be returned using SQL Server? If you can show how to do it for one ... SPACE (3210) through ~ (12710) See Question&Answers more detail:os...

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

0 votes

548 views

1 answer

tsql - How to use RANK() in SQL Server

I have a problem using RANK() in SQL Server. Here's my code: SELECT contendernum, totals, RANK() OVER ( ... numbers will have the same xRank. See Question&Answers more detail:os...

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

0 votes

805 views

1 answer

tsql - How to calculate difference in hours (decimal) between two dates in SQL Server?

I have to calculate the difference in hours (decimal type) between two dates in SQL Server 2008. I couldn't find ... it should return me 1.5. See Question&Answers more detail:os...

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

0 votes

560 views

1 answer

tsql - SQL Server - Auto-incrementation that allows UPDATE statements

When adding an item in my database, I need it to auto-determine the value for the field DisplayOrder. Identity ... there a better/simpler way? See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

tsql - SQL Server Query - groupwise multiplication

If we have a table like this: Grp Value Grp1 2 Grp1 5 Grp1 3 Grp2 3 Grp2 -5 Grp2 -2 Grp3 4 Grp3 0 Grp3 1 ... 0 Grp4 8 Grp5 7 Grp6 NULL Grp7 -10 See Question&Answers more detail:os...

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

0 votes

591 views

1 answer

tsql - How to convert a "dd/mm/yyyy" string to datetime in SQL Server?

I tried this SELECT convert(datetime, '23/07/2009', 111) but got this error The conversion of a varchar data type ... How to fix the 1st one ? See Question&Answers more detail:os...

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

0 votes

596 views

1 answer

tsql - INSERT INTO @TABLE EXEC @query with SQL Server 2000

Is it true that SQL Server 2000, you can not insert into a table variable using exec? I tried this script and ... that true, what should I do? See Question&Answers more detail:os...

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

0 votes

582 views

1 answer

tsql - How to determine the field value which can not convert to (decimal, float,int) in SQL Server

I have a SQL Server database. One field has values which are like ID VALUE 1 NEGATIF 2 11.4 3 0.2 4 A RH(+) ... add more filter like [-+ ()] ? See Question&Answers more detail:os...

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

0 votes

500 views

1 answer

tsql - Search for one value in any column of any table inside a database

Is there a way to search for one value (in my case it is a UID of the type char(64)) inside any column ... pain if the database is too huge. See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

tsql - How to split string and insert values into table in SQL Server

I have a string like this: 72594206916,2,1/2/08,Tacoma,WA:72594221856,5,5/7/13,San Francisco,CA:72594221871 ... its output into a table somehow? See Question&Answers more detail:os...

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

0 votes

505 views

1 answer

tsql - Call dynamic SQL from function

I am writing a function that returns a table. There are two parameters that are passed to the function and ... SP_EXECUTESQL @SQL RETURN END GO See Question&Answers more detail:os...

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

0 votes

629 views

1 answer

tsql - SQL Server variable columns name?

I am wondering why I cannot use variable column name like that: declare @a as varchar; set @a='TEST' select @a from x; Thank you See Question&Answers more detail:os...

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

0 votes

483 views

1 answer

tsql - SQL Server: Index columns used in like?

Is it a good idea to index varchar columns only used in LIKE opertations? From what I can read from query ... has been optimized with an index? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags