Skip to content Skip to sidebar Skip to footer
Showing posts from October, 2024

Optional Parameters, "index Seek" Plan

In my SELECT statement i use optional parameters in a way like this: DECLARE @p1 INT = 1 DECLAR… Read more Optional Parameters, "index Seek" Plan

"debug"(get Information) On A Running Stored Procedure In Ms Sql Server

i aked myself if it is possible in MS SQL-Server 2005 to get information of a running stored proced… Read more "debug"(get Information) On A Running Stored Procedure In Ms Sql Server

How To Solve Requestfeature() Must Be Called Before Adding Content In Android

I am creating an application that consists of the simple and small registration form pop up in an a… Read more How To Solve Requestfeature() Must Be Called Before Adding Content In Android

Editing Multiple Rows By Their Order Index

Q: How would I go about using / applying the row number of each row in a query to a certain column … Read more Editing Multiple Rows By Their Order Index

How To Use Sql Parameters For A Select Query?

I need to fetch the records based on a 'like' match against a set of records, The below que… Read more How To Use Sql Parameters For A Select Query?

Best Way To Do A Case Where Clause Sql Server

I am trying to build an SQL SP to do a query for report. It has several arguments that could be NUL… Read more Best Way To Do A Case Where Clause Sql Server

How To Store 'fully Qualified' And 'name Only' File Name In Ssis Variable

I have an SSIS package that has a Foreach Loop container loading all .txt files in a static folder.… Read more How To Store 'fully Qualified' And 'name Only' File Name In Ssis Variable

Sql: Count Distinct Values From One Column Based On Multiple Criteria In Other Columns

I am trying to do count distinct values based on multiple criteria. Sample data exercise included b… Read more Sql: Count Distinct Values From One Column Based On Multiple Criteria In Other Columns

How To Use A Sql Select Statement With Access Vba

I have a combobox whose value I want to use with a SQL WHERE clause. How do you run a SELECT statem… Read more How To Use A Sql Select Statement With Access Vba

Select All Fields From A Table Where A Field In Another Table With An Id Is Equal To A String

I have 2 tables: Ads: Fields ID, A, B and C: +----+---+-------+------+ | ID | A | B | C | +-… Read more Select All Fields From A Table Where A Field In Another Table With An Id Is Equal To A String

Multiplicity Constraint Violated. The Role Child_parent_target Of The Relationship Child_parent Has Multiplicity 1 Or 0..1

I did a lot of research but haven't found any answer that matches my problem. I even tried to u… Read more Multiplicity Constraint Violated. The Role Child_parent_target Of The Relationship Child_parent Has Multiplicity 1 Or 0..1

When I Try To Execute The Stored Procedure In Coldfusion, Then Not All Of The Information Is Returned

When I try to execute the stored procedure in ColdFusion, then not all of the information is return… Read more When I Try To Execute The Stored Procedure In Coldfusion, Then Not All Of The Information Is Returned

Delete One-to-one Relationship In Flask

I'm currently developing an application using flask and I'm having a big problem to delete … Read more Delete One-to-one Relationship In Flask

Sqlalchemy - Create Expression For Complex Hybrid Property

I have a hybrid property like this in MyModel: @hybrid_property def state(self): states = [dumm… Read more Sqlalchemy - Create Expression For Complex Hybrid Property

Cascade Delete In Many-to-many Self-reference Table

Table DISPLAY_TAB below is a self-reference table that can contain both parent and child tabs. A pa… Read more Cascade Delete In Many-to-many Self-reference Table

Sql Server Stored Procedure Looping Through A Comma Delimited Cell

I am trying to figure out how to go about getting the values of a comma separated string that's… Read more Sql Server Stored Procedure Looping Through A Comma Delimited Cell

Sql To Select Row From Each Day Of A Month

I have a table which store records of all dates of a month. I want to retrieve some data from it. T… Read more Sql To Select Row From Each Day Of A Month

Using A Cursor In A Stored Procedure To Loop Rows Mysql

Scenario: I have a stored procedure that gets data from a table based on 2 inputs: a date and a str… Read more Using A Cursor In A Stored Procedure To Loop Rows Mysql

Sql Server "restore Filelistonly" Resultset

I'm trying to write an automated backup and restore T-SQL scripts. I've done BACKUP part bu… Read more Sql Server "restore Filelistonly" Resultset

Sql Constraint To Make 2 Clumns Not Equal To Each Other

I have a table that has two columns to store id from another table. Column1 gets id from ABC table … Read more Sql Constraint To Make 2 Clumns Not Equal To Each Other

Mysql Many To Many Relationship Query. How To Get All Tags Of Filtered Posts?

I have gone through tons of questions about this issue here in Stackoverflow but I think this is di… Read more Mysql Many To Many Relationship Query. How To Get All Tags Of Filtered Posts?

Not A Valid Month In Oracle When Add_months Is Used

I have given the below code in query. where to_date(cal_wid,'yyyymmdd') between a… Read more Not A Valid Month In Oracle When Add_months Is Used

What Kind Of Index Would Be Efficient When There Is In Clause?

Here is my query: DELETE FROM events WHERE type = 4 AND author_id IN (?, ?) AND post_id IN (?, ?) … Read more What Kind Of Index Would Be Efficient When There Is In Clause?

Nhibernate Dynamic Columns Number

In my C# project I need create in code one database with one table with dynamic columns number. Lik… Read more Nhibernate Dynamic Columns Number

Creating A Character Sequence On Postgresql

So, I have this sequence referenced on a table column where everytime I do an insert its value is d… Read more Creating A Character Sequence On Postgresql

Search Multiple Columns In Sqlite Select From

I use this code to search for Column A. What modification should I make if I want to search Column … Read more Search Multiple Columns In Sqlite Select From

Oracle Sql First And Last Day Of Quarter Of Any Year

Is there any way i can calculate the first and last day of the three quarters in any year . 2012 , … Read more Oracle Sql First And Last Day Of Quarter Of Any Year

An "entity" Specific Sequence

Background I have a lot of different 'things' (a domain specific item/entity/subject) that … Read more An "entity" Specific Sequence

Get Ssis Package Name With C#

I'm copying SSIS packages from one SQL server to another in a C# program via DTUTIL. The packag… Read more Get Ssis Package Name With C#

Using Pdo For An Insert And The_geom

I'm switching my code to PDO for increased security. My insert works until I add a special colu… Read more Using Pdo For An Insert And The_geom

Sqlite How To Use Integer For Storing Price Value

I am using real type to save price value in SQLite database but it does not return correctly value.… Read more Sqlite How To Use Integer For Storing Price Value

Which Record Will Group By Choose In Sql

If I have an SQL query like this one: SELECT playerno,town FROM players GROUP BY town In this case… Read more Which Record Will Group By Choose In Sql

How To Speed Up Update Query On Massive Table

I am currently in the process of transferring one of our existing databases onto a new ontology. Th… Read more How To Speed Up Update Query On Massive Table

Unable To Change Identity Specification To Yes In Sql Server Table

This may be a dumb question, but why can't I change the Identity Specification or (Is Identity)… Read more Unable To Change Identity Specification To Yes In Sql Server Table

Sql Table - Semi-unique Row?

I have an SQL table with basically the following structure: PK (int, primary key), userID (int), da… Read more Sql Table - Semi-unique Row?

How To Select The Max Of Two Element Of Each Row In Mysql

I have got a table that is a result of a (My)SQL query. In this table I have the post creation time… Read more How To Select The Max Of Two Element Of Each Row In Mysql

Mysql Update With A Subquery In Safe Update Mode

I have the following database: The following query calculates the total amount, that comes from mu… Read more Mysql Update With A Subquery In Safe Update Mode

Attempting To Avoid Polymorphic Associations

I'm creating a MySQL database and I ran into an instance in which I needed polymorphic associat… Read more Attempting To Avoid Polymorphic Associations

How To Choose Returned Column Name In A Select For Xml Query?

MS SQL has a convenient workaround for concatenating a column value from multiple rows into one val… Read more How To Choose Returned Column Name In A Select For Xml Query?

I'd Like To Have Characters Only (no Signs, Numbers And Spaces At All)

It should be done with SQLite just like this; yes, I know, it is quite easy task, If I use UDF(Use… Read more I'd Like To Have Characters Only (no Signs, Numbers And Spaces At All)

Converting Geometry(spatial) To Longitude And Latitude

I've uploaded .SHP files to my table in sql and I got geometry column with data. I can see poin… Read more Converting Geometry(spatial) To Longitude And Latitude

Tempdb Has Reached Its Size Quota: How To Increase Size Quota For Tempdb On Azure Sql

We are getting an error while loading data from one table to another. We do some monthly/quarterly … Read more Tempdb Has Reached Its Size Quota: How To Increase Size Quota For Tempdb On Azure Sql

Return A Value If No Rows Match

The [authorityID] (TinyInt) column will never be null. What I want is to return a 15 if there are … Read more Return A Value If No Rows Match

Select Data (join?) From Only One Table Using An Id From Another Table

I have two tables, that we'll call t1 and t2. I want to select the data in t1 that has a certa… Read more Select Data (join?) From Only One Table Using An Id From Another Table

Why The Mssql Object Can Not Be Identified?

I am getting below error when using mssql object in script as: var mssql =request.services.mssql; … Read more Why The Mssql Object Can Not Be Identified?

Is It Bad To Omit Semicolon In Mysql Queries?

I've been omitting the semicolon at the end of my MySQL queries recently, and it occurred to me… Read more Is It Bad To Omit Semicolon In Mysql Queries?

Using Regexp_substr With Strings Qualifier

Getting Examples from similar Stack Overflow threads, Remove all characters after a specific chara… Read more Using Regexp_substr With Strings Qualifier

How To Debug A Script Component In Ssis

It's simple but I can't make it work, and I read in so many places a lot of solutions but n… Read more How To Debug A Script Component In Ssis

Trouble With Copying Dictionaries And Using Deepcopy On An Sqlalchemy Orm Object

I'm doing a Simulated Annealing algorithm to optimise a given allocation of students and projec… Read more Trouble With Copying Dictionaries And Using Deepcopy On An Sqlalchemy Orm Object

Sql Server: Generate Primary Key Based On Counter And Another Column Value

I am creating a customer table with a parent table that is company. It has been dictated(chagrin) t… Read more Sql Server: Generate Primary Key Based On Counter And Another Column Value

Android Check Duplicate Values Before Inserting Data Into Database

String new_recorded_lastname='a lastname'; ////record to database...... Cursor curs… Read more Android Check Duplicate Values Before Inserting Data Into Database

Normalised Database - One To Many - Search Through All Joined Data Sets

I am trying to construct a MySQL query that will allow me to pull the song title of a track in the … Read more Normalised Database - One To Many - Search Through All Joined Data Sets

How To Convert An Ebcdic Zoned Decimal To A Decimal In Ms Sql Server 2014?

Hi everyone this is major chunk for me I have been trying lot but not getting success there is dat… Read more How To Convert An Ebcdic Zoned Decimal To A Decimal In Ms Sql Server 2014?

Filemaker 13 Odbc Firebird Connection Possible?

I want to connect a Filmaker 13 Database with a Firebird Database trough ODBC. So far I could conne… Read more Filemaker 13 Odbc Firebird Connection Possible?

Changing Column Datatype From Decimal(9,0) To Decimal(15,0)

Can you please help me concerning this matter (I didn´t found it in the Teradata documentation, whi… Read more Changing Column Datatype From Decimal(9,0) To Decimal(15,0)

How To Make Sqlcontext.pipe.send In Sqlclr Stored Proc Work With Unicode?

I'm having problems with SQL CLR integration with unicode (Hebrew and Russian text). As a test,… Read more How To Make Sqlcontext.pipe.send In Sqlclr Stored Proc Work With Unicode?

Convert Float To Datetime

I have a FLOAT field for a date which looks like this: +-----------+ | FloatDate | +-----------+ | … Read more Convert Float To Datetime

How To Get The Date And Time From Timestamp In Postgresql Select Query?

How to get the date and time only up to minutes, not seconds, from timestamp in PostgreSQL. I need … Read more How To Get The Date And Time From Timestamp In Postgresql Select Query?