Recent questions tagged SQL

0 votes

811 views

1 answer

sql server - Retrieve varbinary value as BASE64 in MSSQL

I'm looking for a way for retrieving Entity Data Model (EDM) from __MigrationHistory table using only T-SQL (so ... here, but it looks ok. See Question&Answers more detail:os...

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

0 votes

284 views

1 answer

sql server 2008 - SQL to return first two columns of a table

Is there any SQL lingo to return JUST the first two columns of a table WITHOUT knowing the field names? Something ... ? How would I do that? See Question&Answers more detail:os...

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

0 votes

556 views

1 answer

sql - SSDT failing to publish: "Unable to connect to master or target server"

I'm attempting to use SSDT to publish to a SQL Server database in Azure. When I do so, I am seeing the ... cause of the problem. Any ideas? See Question&Answers more detail:os...

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

0 votes

307 views

1 answer

sql server - T-sql Reset Row number on Field Change

Similar to a recent post of mine "t-sql sequential duration" , but not exactly the same, I want to reset ... to 1 Any assistance is appreciated. See Question&Answers more detail:os...

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

0 votes

383 views

1 answer

sql server - EF Code first, how to register same table name with different schema?

We are using Entity Framework, Code First and in our database we have several tables that have the same name but ... for your help in advance! See Question&Answers more detail:os...

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

0 votes

450 views

1 answer

sql - Stored Procedure return multiple result sets

I need a SP to return multiple sets of results. The second set of results would be based on a column of ... = (select field0 from @myTable1) See Question&Answers more detail:os...

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

0 votes

238 views

1 answer

sql - What's the difference between "using" and "on" in table joins in MySQL?

Is this ... T1 join T2 using(ID) where T2.VALUE=42 ... the same as ... T1 join T2 on(T1.ID=T2.ID) ... the join vs if its in the where clause? See Question&Answers more detail:os...

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

0 votes

289 views

1 answer

sql server 2005 - How to self JOIN recursively in SQL?

I have a table: Series ======== ID SeriesName ParentSeriesID A series can be a "root" series, ( ... sure how to progress from here. See Question&Answers more detail:os...

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

0 votes

371 views

1 answer

sql server 2005 - SQL Insert Into Temp Table in both If and Else Blocks

I'm trying to populate a temp table based on the result of a condition in SQL 2005. The temp table will have ... to make this work? Thanks, Matt See Question&Answers more detail:os...

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

0 votes

394 views

1 answer

sql - DB2- How to check if varchar field value has integers

Is there an inbuilt DB2 function or any query to check if the character i have is a number? (I cannot use user defined functions) See Question&Answers more detail:os...

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

0 votes

289 views

1 answer

sql - Does a SELECT query always return rows in the same order? Table with clustered index

Will my select * query always return the rows from my database table in the same order? My table has a ' ... . Does that change the answer? See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql - What is "Structured" in Structured Query Language?

What does the "Structured" word means in SQL? Is it because this(SQL) language statements are organized into ... it called "Structured" ? See Question&Answers more detail:os...

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

0 votes

631 views

1 answer

sql - Jdbi - how to bind a list parameter in Java?

We have an SQL statement which is executed by Jdbi (org.skife.jdbi.v2). For binding parameters we use ... that should be already supported. See Question&Answers more detail:os...

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

0 votes

426 views

1 answer

sql server - C# SQLConnection pooling

Can anyone brief me how to do Connection Pooling in ADO.Net, I do need to connect to 3 separate databases. 2 ... one. Better with code snipts.. See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

sql server - Create an index on SQL view with UNION operators? Will it really improve performance?

I am trying to create an index on the following view: SELECT 'Candidate' AS Source, CandidateID AS SourceId, ... this view? Thanks in advance! See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql server express - Connection String to Connect to .MDF

I've created a new project in VS2008, and added a .MDF file to the project. This is the first time I've ... there an easy way to find out? See Question&Answers more detail:os...

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

0 votes

357 views

1 answer

sql - alter table then update in single statement

I have a requirement where I need to Alter (Add 2 columns) and then update the same table. Here is the ... one help me resolve this problem. See Question&Answers more detail:os...

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

0 votes

364 views

1 answer

sql - How to pass a comma separated list to a stored procedure?

So I have a Sybase stored proc that takes 1 parameter that's a comma separated list of strings and runs a query ... to pas an array to a sproc See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

sql - Opposite of MySQL FIND_IN_SET

How can I do the equivalent of: !FIND_IN_SET('needle', haystack) See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql server - How to automatically reseed after using identity_insert?

I recently migrated from a PostgreSQL database to a SQL Server database. To switch the data over I had to enable ... it is after max(RID)? See Question&Answers more detail:os...

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

0 votes

860 views

1 answer

sql - Dealing with System.DBNull in PowerShell

EDIT: As of PowerShell 7 Preview 2, -not [System.DBNull]::Value evaluates to $true, thanks to Joel Sallow ... I exhausted my options for now? See Question&Answers more detail:os...

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

0 votes

378 views

1 answer

sql - Why does PostgreSQL not return null values when the condition is <> true

I was confused behind the reasoning of the following: SELECT * FROM table WHERE avalue is null Returns x number of ... I wanted to learn why. See Question&Answers more detail:os...

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

0 votes

265 views

1 answer

sql - Declaring & Setting Variables in a Select Statement

I'm attempting to write a simple query where I declare some variables and then use them in a select statement in ... or am I mssing something? See Question&Answers more detail:os...

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

0 votes

440 views

1 answer

sql - Why isn't SET XACT_ABORT ON the default behavior?

Reading things like this post on Dan Guzman's blog, I wonder: why isn't SET XACT_ABORT ON the default ... /efficient than SET XACT_ABORT OFF? See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql server - The transaction log for database 'databasename' is full.

The transaction log for database '' is full. To find out why space in the log cannot be reused, see the ... this issue. Thanks in advance. See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql - NULL values are excluded. Why?

This is about a bizarre behaviour I found in Microsoft Sql Server. Please correct me if I'm wrong. SELECT COUNT(*) ... this? How can I fix it? See Question&Answers more detail:os...

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

0 votes

349 views

1 answer

sql server - SQL Dynamic DatePart when using DateDiff

Is there a way to pass the DatePart parameter of DateDiff as a variable? So that I can write code that is ... platform is MS SQL Server 2005 See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql - Pass a TABLE variable to sp_executesql

I'm trying to pass a TABLE variable to the sp_executesql procedure: DECLARE @params NVARCHAR(MAX) SET @params = ' ... )... Any help appreciated! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags