Recent questions tagged TSQL

0 votes

758 views

1 answer

tsql - What does "&" means in this sql where clause?

What does the "&" mean here: select pt.TrTp, sum(pt.TrTp) from ProdTr pt where TransSt & 16 <> 16 // ... i don′t understand.. group by pt.TrTp See Question&Answers more detail:os...

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

0 votes

838 views

1 answer

tsql - Rounding milliseconds in T-SQL

In SQL Server 2008, I have the below column of type DateTime in a table. +-------------------- ... ---+ Greatly appreciate your help in advance. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

tsql - SQL Server sort comma separated string in one column

How do I sort within a varchar column? Such as I have a column called [Country], it may contain all kinds of ... UK, USA" in [Country] column. See Question&Answers more detail:os...

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

0 votes

816 views

1 answer

tsql - Transact-SQL: How do I tokenize a string?

I want to be able to tokenize an input string from a text box to do my query. Example: user enters "abc ... , I am an absolute beginner Thanks. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

tsql - How to resolve "Could not find installable ISAM." error for OLE DB provider "Microsoft.ACE.OLEDB.12.0"

I am trying to import data from Excel 2007 (.xlsx) files into SQL Server 2008 using a T-SQL OpenRowset() ... a step forward?!) Any thoughts? See Question&Answers more detail:os...

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

0 votes

795 views

1 answer

tsql - Weird SQL Server 2005 Collation difference between varchar() and nvarchar()

Can someone please explain this: SELECT CASE WHEN CAST('iX' AS nvarchar(20)) > CAST('-X' ... for the database is SQL_Latin1_General_CP1_CI_AS. See Question&Answers more detail:os...

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

0 votes

809 views

1 answer

tsql - How to use CASE alias in WHERE CLAUSE?

I'm trying to put the "val" into where clause, but it returns error: Select ff.FormID, ff.FieldID, ff. ... Any kind help is appreciated :) See Question&Answers more detail:os...

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

0 votes

955 views

1 answer

tsql - SQL Server 2000: remove duplicates from comma-separated string

I have been looking into this for a while now and I cannot find a way to remove duplicate strings from a ... would you return test,test2,test3? See Question&Answers more detail:os...

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

0 votes

745 views

1 answer

tsql - Return the id of the just added row

In a similar vein to my previous question I again ask the SO guys for your collective wisdom and help. In a ... way? How would you do this? See Question&Answers more detail:os...

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

0 votes

755 views

1 answer

tsql - syntax error table variable

This is the code: declare @Ids table ( Id int identity(1,1)); SET IDENTITY_INSERT @Ids ON; and I get: Incorrect ... 's wrong. Any ideas? Thanks. See Question&Answers more detail:os...

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

0 votes

857 views

1 answer

tsql - How do I strip the date off of a datetime string in SQL SSIS?

I'm working on a data warehouse project and would like to know how to (preferably in a Derived Column component in a ... simply "11:32:21 AM". See Question&Answers more detail:os...

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

0 votes

787 views

1 answer

tsql - How does SQL Server determine the style for convert when it isn't specified?

Update: This is a bug but won't get fixed until the next release of SQL Server due to backward compatibility ... "2010-09-03" */ ROLLBACK See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

tsql - Advantages on using cursor variable in SQL Server (declare @cn cursor)

In T-SQL a cursor can be declared in two ways (that I know of): declare CursorName cursor for ... ... vs while with temp/table variable. See Question&Answers more detail:os...

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

0 votes

862 views

1 answer

tsql - Update Target Button is disabled in Sql Server Database Schema Comparison

I use Visual Studio 2013 Professional Update 4 in combination with multiple SQL Server 2012 Enterprise servers/instances. The ... (12.0.50318.0) See Question&Answers more detail:os...

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

0 votes

725 views

1 answer

tsql - T-SQL Insert - Select in Table variable is very slow

I have a table variable and I am inserting in it some values using the "Insert Into - Select" statement. The ... Any ideas how to optimize it? See Question&Answers more detail:os...

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

0 votes

755 views

1 answer

tsql - Why does SQL Server thinks a Temp Table already exists when it doesn't?

Background: There's a stored procedure which does "stuff" with a temp table of a given name. The procedure is ... just accept the sproc as is? See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

tsql - How to insert JPEG into a SQL Server 2000 database field of image type using Transact SQL

I'm trying to figure out how to insert a .JPG file into a SQL Server 2000 database field of type image using Transact SQL. Thanks. See Question&Answers more detail:os...

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

0 votes

752 views

1 answer

tsql - ORDER BY in a Sql Server 2008 view

we have a view in our database which has an ORDER BY in it. Now, I realize views generally don't order, ... specified by the ORDER BY clause. See Question&Answers more detail:os...

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

0 votes

777 views

1 answer

tsql - SQL Server: What does 1 ++ 2 mean?

SQL Server's T-SQL syntax seems to allow multiple plus signs in succession: SELECT 1 + 2 --3 SELECT 1 ++ 2 --3 ... " ++ exist? What does it do? See Question&Answers more detail:os...

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

0 votes

780 views

1 answer

tsql - SQL Server automatic update datetimestamp field

In SQL Server 2008 R2" I am trying to insert a formula in SQL Server that will update the current value in ... every time the record is updated. See Question&Answers more detail:os...

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

0 votes

820 views

1 answer

tsql - Break into multiple rows based on date range of a single row

I have a table which captures appointments, some are single day appointments and some are multi day appointments, so ... not based on table data See Question&Answers more detail:os...

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

0 votes

630 views

1 answer

tsql - When we go for cross apply and when we go for inner join in SQL Server 2012

I have small question about SQL Server. When do we use cross apply, and when do we use inner join? Why use ... write this query in SQL Server. See Question&Answers more detail:os...

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

0 votes

773 views

1 answer

tsql - sql missing rows when grouped by DAY, MONTH, YEAR

If I select from a table group by the month, day, year, it only returns rows with records and leaves out ... data is present, in T-SQL? See Question&Answers more detail:os...

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

0 votes

840 views

1 answer

tsql - Dynamic SQL Server Pivot Table

I found a nice script that dynamically creates by column names for my pivot table, but I am not getting the ... C4054 34-1500-013 88-0000 See Question&Answers more detail:os...

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

0 votes

826 views

1 answer

tsql - Query to find Number of Parameters in a Stored Procedure or Function in Sql Server?

Well, if i want to find parameter count of any stored procedure or function inside SQL SERVER, what is the ... would be appreciated. thanks. See Question&Answers more detail:os...

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

0 votes

843 views

1 answer

tsql - How to split string and save into an array in T-SQL

I am writing a cursor to populate data in new table from main table which contains data in below manner Item ... Nested cursor for this purpose. See Question&Answers more detail:os...

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

0 votes

763 views

1 answer

tsql - Creating composite foreign key constraint

I am trying to create a composite foreign key relationship/constraint. All tables are empty. I have this table: ... Where am I going wrong? See Question&Answers more detail:os...

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

0 votes

674 views

1 answer

tsql - Can one have multiple queries in streaming analytics job?

As the title says, can you have more than one query in an Azure Streaming Analytics job? If so, how should that be structured? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags