Lab Sql

What's the most efficient way to calculate the last day of the prior quarter? Example: given t… Read more Calculate The Last Day Of The Prior Quarter

I want to filter some data by both yyyymmdd(date) and hhmmss(time), but clickhouse don't suppor… Read more How To Select Data Basing On Both A Period Of Date And A Period Of Time In Clickhouse

I have encountered a problem where in my database I have a column that is a bit either 0 or 1 speci… Read more Retrieving A Bit Column From Sql Database In Vb Net

The answers to my previous post encouraged me mixing SQL and NoSQL db. What is the best practice im… Read more Spring And Mixing Sql And Nosql Db

I am getting the 'interval' wise (30 min, 15 min, 45 min) data in my stored procedure now I… Read more I Want Combine My Time Slots As Per Interval (15,30,,45,60) And Do The Additon Of Columns In Sql Stored Procedure

I've come across a scenario where I want to pass a large amount of data to a Stored Procedure f… Read more Sql Server Clr Stored Procedure Json Parameter

I'm trying to import .CSV files using BULK INSERT on SQL Server and a Format File. I have creat… Read more Comma's Causing A Problem Using Bulk Insert And A Format File

I have 2 tables Delivery -------- deliveryid int (PK) description long varchar DeliveryHistory --… Read more Join Record With Most Recent Record On Second Table

I have a stored proc that has this UPDATE query: UPDATE TOP(1) Batch_tbl SET locked = 1 OUTPUT inse… Read more Sql Server: Can Concurrent Threads Update Same Row?

In sql-server-2012 I want to generate view with all points from geometry type. How can I do this? V… Read more Generate View With X And Y From Geometry Type

I've checked and rechecked and looked over and over at it but can't understand what's w… Read more Update Sql Command Syntax Error

Currently I have data from #temp where I extract it from other tables. The #temp table format is as… Read more How To Transpose Rows Of Data Into A Single Row With Different Columns In Sql Server

I have a SQLite table of user actions on a website. Each row is the same action on a web site, jus… Read more Sqlite: How To Get A Count Of Group Counts

The following sql query executes fine when ran in TOAD editor and shows results,but does not fail o… Read more Sql Query Works Fine In Toad , But Not When Placed In Java Code

In my iphone application i used sqlite3 for creating database. Now i want to take backup of a data… Read more How To Upload Sqlite Database File To Server From Iphone Application In Ios

I have two tables: Book(BookID, Title, Author, Decision) BookShipment(BookID, ShipmentID) CREATE TA… Read more Adding Constraints That Check A Separate (linked) Table For A Value

I am reading blobs with size between 100kb and 1000kb from SQlite in my Android App using the follo… Read more Fast Read Of Blobs Within Sqlite Using Simplequeryforblobfiledescriptor?

For a web application database, from a security standpoint only, what are arguments counter to the … Read more Stored Procedures Vs No Stored Procedures - Security Viewpoint

I'm trying to use ADO to create several tables at once, into MS Access. Is it possible to do mu… Read more Running Multiple Sql Statements In The One Operation

I'm struggling for many hours now using activerecord-jdbcmssql-adapter with Rails 5.1 (or 5.2).… Read more Gem Load Error Is: Undefined Method `type_cast_from_database' For Class `arjdbc::mssql::uuidtype'