Recent questions tagged TSQL

0 votes

725 views

1 answer

NOTE: It's probably a duplicate but I can't find working answer. Following is what i'm trying todo, notice a ' ... a lookup table (ID<->Name). See Question&Answers more detail:os...

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

0 votes

532 views

1 answer

tsql - How to read a Text file using T-SQL?

What's the best way to read a text file using T-SQL? I've seen the BULK INSERT and many different ... direction will be really appreciate it. See Question&Answers more detail:os...

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

0 votes

482 views

1 answer

tsql - Properly sorting dotted numbers stored as character in SQL Server

I have a SQL table that stores a custom item number. Each of these can have a child broken off from it with a separator ... , 20....3, 30, etc. See Question&Answers more detail:os...

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

0 votes

590 views

1 answer

tsql - Most succinct way to transform a CSV string to a table in T-SQL?

-- Given a CSV string like this: declare @roles varchar(800) select @roles = 'Pub,RegUser,ServiceAdmin' -- Question: ... + '''' exec(@rolesSql) See Question&Answers more detail:os...

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

0 votes

597 views

1 answer

tsql - How do you specify 'DEFAULT' as a SQL parameter value in ADO.NET?

I have a parameterized SQL query targetted for SQL2005 which is dynamically created in code, so I used the ADO ... practice in such an instance? See Question&Answers more detail:os...

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

0 votes

551 views

1 answer

tsql - How to generate all possible data combinations in SQL?

I'm developing a shop web site. I have a database table, ProductOption, that represents the various options ... using SQL Server 2005? Thanks See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

tsql - How can I query the name of the current SQL Server database instance?

It is a bit of a "chicken or egg" kind of query, but can someone dreamup a query that can return ... database instance rather than the server. See Question&Answers more detail:os...

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

0 votes

573 views

1 answer

tsql - Can a stored procedure have dynamic parameters to be used in an "IN" clause?

I want to run a query like this: SELECT * FROM Studio WHERE Id IN (134, 144, 132, 138, 7432, 7543, ... available, which one is better? Thanks. See Question&Answers more detail:os...

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

0 votes

551 views

1 answer

tsql - SQL Server 2008 Generate a Series of date times

I am trying to generate a table with a series of date times in it. I have the specified start date time and ... of insert statements to make :( See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

tsql - How do I convert an int to a zero padded string in T-SQL?

Let's say I have an int with the value of 1. How can I convert that int to a zero padded string, such as 00000001? See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

tsql - Use multiple words in FullText Search input string

I have basic stored procedure that performs a full text search against 3 columns in a table by passing in a @Keyword ... 1) ORDER BY [Name] ASC See Question&Answers more detail:os...

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

0 votes

606 views

1 answer

tsql - Where is the Query Analyzer in SQL Server Management Studio 2008 R2?

I have some SQL thats getting run and it is taking to long to return the results / parse / display, ... replacements for the Microsoft tools? See Question&Answers more detail:os...

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

0 votes

757 views

1 answer

tsql - SQL: How to fill empty cells with previous row value?

I need to produce the column "required" in the following table using SQL without using loops and correlated sub ... that with a valid value. See Question&Answers more detail:os...

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

0 votes

816 views

1 answer

tsql - SQL Server remove milliseconds from datetime

select * from table where date > '2010-07-20 03:21:52' which I would expect to not give me any ... I make the query ignore milliseconds? See Question&Answers more detail:os...

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

0 votes

615 views

1 answer

tsql - Stored procedure hangs seemingly without explanation

we have a stored procedure that ran fine until 10 minutes ago and then it just hangs after you call it. Observations ... . So here's the points! See Question&Answers more detail:os...

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

0 votes

521 views

1 answer

tsql - SQL Server: What are batching statements (i.e. using "GO") good for?

I know that in SQL Server GO is considered a batch separator. My question is: What is the point of ... GO (source: technet documentation): See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

tsql - SQL Views - no variables?

Is it possible to declare a variable within a View? For example: Declare @SomeVar varchar(8) = 'something' ... near the keyword 'Declare'. See Question&Answers more detail:os...

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

0 votes

658 views

1 answer

tsql - Is there a way to disable a SQL Server trigger for just a particular scope of execution?

In SQL Server 2005, is there a way for a trigger to find out what object is responsible for ... /1,289483,sid87_gci1170220,00.html#trigger See Question&Answers more detail:os...

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

0 votes

577 views

1 answer

tsql - How do I drop a foreign key in SQL Server?

I have created a foreign key (in SQL Server) by: alter table company add CountryID varchar(3); alter ... drop the CountryID column? Thanks. See Question&Answers more detail:os...

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

0 votes

691 views

1 answer

tsql - What is PAGEIOLATCH_SH wait type in SQL Server?

I have a query that is taking a long time in the middle of a transaction. When I get the wait_type of the ... and how can this be resolved? See Question&Answers more detail:os...

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

0 votes

507 views

1 answer

tsql - time format in SQL Server

Does anyone know how can I format a select statement datetime value to only display time in SQL Server? example: Table ... I can do it in mssql? See Question&Answers more detail:os...

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

0 votes

694 views

1 answer

tsql - Is there an "IF EXISTS" test for a linked server?

I want to be able to programmatically (in T-SQL) check if a specific linked server already exists for my ... assume the link always exists? See Question&Answers more detail:os...

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

0 votes

566 views

1 answer

tsql - T-SQL Between Dates Confusion

I am working with T-SQL in SQL Server 2000 and I have a table TRANSACTIONS which has a date column TRANDATE ... from some folks first. Thanks! See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

tsql - A real recursion with CTE?

I just discovered CTE this afternoon and after enjoying them during 2 hours, I realized that they did not ... team2 team3 team3-1 Thanks See Question&Answers more detail:os...

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

0 votes

777 views

1 answer

tsql - SQL Server error "Implicit conversion of because the collation of the value is unresolved due to a collation conflict."

I getting this error while developing stored procedure Implicit conversion of varchar value to varchar cannot be ... a collation conflict. See Question&Answers more detail:os...

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

0 votes

759 views

1 answer

tsql - Pivot multiple columns based on one column in SQL Server

I have the following source and destination tables in SQL Server 2008R2. How can I do pivot(s) in TSQL to transform ... 1/1/2099 NULL NULL NULL See Question&Answers more detail:os...

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

0 votes

750 views

1 answer

tsql - How do I remove non-breaking spaces from a column in SQL server?

I'm trying to remove a non-breaking space (CHAR 160) from a field in my table. I've tried using ... non-breaking space from the column? See Question&Answers more detail:os...

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

0 votes

567 views

1 answer

tsql - Need a datetime column in SQL Server that automatically updates when the record is modified

I need to create a new DATETIME column in SQL Server that will always contain the date of when the record was ... it will happen very often. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags