Recent questions tagged sql

0 votes

417 views

1 answer

sql server - Why can't I put a constraint on nvarchar(max)?

Why can't I create a constraint on an nvarchar(max) column? SQL Server will not allow me to put a unique ... to the nvarchar(max) column? See Question&Answers more detail:os...

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

0 votes

303 views

1 answer

sql - @ Symbol - a solution for Recursive SELECT query in Mysql?

there are a lot of questions about Recursive SELECT query in Mysql, but most of answers is that "There NO ... the solution I just mentioned? See Question&Answers more detail:os...

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

0 votes

342 views

1 answer

sql - How to render all records from a nested set into a real html tree

I'm using the awesome_nested_set plugin in my Rails project. I have two models that look like this (simplified): ... may prove to be helpful. See Question&Answers more detail:os...

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

0 votes

285 views

1 answer

sql - Is Order Guaranteed When Inserting Multiple Rows with Identity?

When inserting multiple rows in a table, is there any guarantee that they go in in the order I specify? For ... a higher primary key than Timmy? See Question&Answers more detail:os...

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

0 votes

476 views

1 answer

sql - Entity Framework Hitting 2100 Parameter Limit

I'm migrating some of our code from LINQ-to-SQL to Entity Framework. Previously, when run up against a 2100 ... for any help you can provide. See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

sql - android cursor.moveToNext()?

I am trying to query all the columns in a table into one long text view and/or string. I know ... this information without using a ListView? See Question&Answers more detail:os...

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

0 votes

289 views

1 answer

sql - Are Determinants and Candidate Keys same or different things?

Here I found this: Definition: A determinant in a database table is any attribute that you can use to ... applicable for candidate keys too? See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql server - Kerberos double-hop in ASP.NET 4.0 & SQL2008R2

I have an ASP.NET 4.0 application within which I need to forward the authentication to the database. For the ... 7 and/or Windows Server 2008? See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql - Find last sunday

How will you find last sunday of a month in sql 2000? See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql - C# SqlParameters Short Hand

I'm taking data that is in a List of Record objects and putting their contents in to a database: // ... What could be causing the error? See Question&Answers more detail:os...

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

0 votes

349 views

1 answer

sql server - SQL: Group By on Consecutive Records

A slightly tricky SQL question (we are running SQL server 2000). I have the following table, StoreCount - ... they run in sequence together. See Question&Answers more detail:os...

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

0 votes

269 views

1 answer

sql server - Create ASP.NET Identity tables using SQL script

I am attempting to incorporate ASP.NET Identity into a new application that currently uses a SQL script to create the ... ).Property(iul => iul.UserId).HasColumnName("UserId");...

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

0 votes

547 views

1 answer

sql server - How can I subtract a previous row in sql?

What should I query if I wanted to subtract the current row to the previous row. I will use it on looping in ... query or VB6 code.Any will do. See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql - Is it possible to perform a "LIKE" statement in a SSIS Expression?

I'm using a Derived Column Task to change column data using a CASE WHEN statement. However, I need to be ... possible to use a LIKE operator? See Question&Answers more detail:os...

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

0 votes

680 views

1 answer

sql server - Convert a string with 'YYYYMMDDHHMMSS' format to datetime

I recognize there has been many questions posted about converting strings to datetime already but I haven't ... anyone have any suggestions? See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql server 2008 - SQL Script to find Foreign keys to a specific table?

Is there a query that will get me foreign keys directed at a specific table column? For example, say I had ... . Any help would be appreciated. See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql server - Optimizing Execution Plans for Parameterized T-SQL Queries Containing Window Functions

EDIT: I've updated the example code and provided complete table and view implementations for reference, but the ... bottom plan is bad. See Question&Answers more detail:os...

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

0 votes

457 views

1 answer

sql server 2005 - Difference Between Persist Security Info And Integrated Security?

In a SQL Server connection string, what's the difference between Integrated Security = True/SSPI and Persist Security = True? See Question&Answers more detail:os...

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

0 votes

217 views

1 answer

sql - MySQL Group By Hours

I'm trying to get a report from my history table by hourly usage. history table is; CREATE TABLE IF NOT EXISTS `history` ... | 9 23:00-00:00 | 1 See Question&Answers more detail:os...

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

0 votes

351 views

1 answer

sql - Find All Rows With Null Value(s) in Any Column

I'm trying to create a query that will return all the rows that have a null value across all but 1 column ... FROM Analytics WHERE P_Id IS NULL See Question&Answers more detail:os...

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

0 votes

289 views

1 answer

sql - How to drop a unique constraint from table column?

I have a table 'users' with 'login' column defined as: [login] VARCHAR(50) UNIQUE NOT NULL Now I want to remove ... ? Or at least any... Thanks. See Question&Answers more detail:os...

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

0 votes

279 views

1 answer

sql - Multiple OR Clauses in MySQL

I'm trying to grab content where id = 3 OR id = 9 OR id = 100... Keep in mind, I can have a few hundred of these ... =3 OR id=9 OR .... id-100)" See Question&Answers more detail:os...

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

0 votes

330 views

1 answer

sql - Using 'like' in ssrs expressions

I'm trying to highlight a field when the value has the word 'deadline' in it. I'm trying to use the ... difference. What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

641 views

1 answer

sql - SQLite loop statements?

Is there any loop statements in SQLite like FOR .. in .. LOOP or something like that? I have two columns StartRange ... value, contains 1, 2, 3. See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql - MySQL limit range

SELECT name FROM mydb ORDER BY score DESC LIMIT 10; The query above will return the first 10 ranks. How to ... 10th rank through the 20th rank? See Question&Answers more detail:os...

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

0 votes

252 views

1 answer

sql server - SQLCLR using the wrong version of the .NET Framework

During a recent restart of our development server the SQL Server started using .NET 4.0 for the SQLCLR. ... earlier version of the Framework? See Question&Answers more detail:os...

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

0 votes

763 views

1 answer

sql server - How can I use a SQL UPDATE statement to add 1 year to a DATETIME column?

I want to add 1 year to a datetime-type column in every single row in a table. Adding using an UPDATE statement ... sql so please be gentle... See Question&Answers more detail:os...

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

0 votes

647 views

1 answer

sql - How to set isolation level on SqlCommand/SqlConnection initialized with no transaction

The following method is supposed to peroform a dirty read on an open connection. There are no transactions. Where ... .ExecuteNonQuery(); } } See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags