Lab Sql

I have a simple schema in which soft deletes are used (that's how it is designed and that can&#… Read more Method For Cascading Soft Deletes In Parent-child Relationships

I have a stored procedure that I need to convert so that it reads a linked server variable from a t… Read more Converting A Query To Dynamic SQL With Linked Server Variable

I have below query for pivot table only for products 0 , 3 , 11 SELECT * FROM ( SELECT … Read more T Sql Pivot Table Selecting For IN

I need to broadcast the real time database table to my web application (Asp.net). I know I can impl… Read more Broadcast The Real Time MySQL Database Table Data

We are using entity framework to query a SQL server database. The LINQ expression is IQueryable. Th… Read more Entity Framework Performance Tuning

For SqlDataSource I can configure the external source for the incoming paramater. For example it mi… Read more How To Use User.Identity.Name As A Parameter For SqlDataSource In ASP.NET?

I want to extract the value of Decision using sql from table TRAPTABCLOB having column testclob wit… Read more Extract Data From XML Clob Using SQL From Oracle Database

I have a MySQL database set up through the Azure Portal, currently hosted on ClearDB. I have create… Read more Set Up MySQL Back-end In Azure For Xamarin Offline Sync

I have a new idea and question about that I would like to ask you. We have a CRM application on-pre… Read more Synchronize SQL Server Databases

I have a table with around 30 billions rows in Redshift with following structure, userid itemid … Read more Find Top 1000 Entries Along With Count And Rank From Table

What is the correct way to add reference column migration in Rails 6 without getting SQLite3::SQLEx… Read more How To Add Reference Column Migration In Rails 6 With SQLite

Below are the two different attempts I have made in trying to achieve a multi-column unique constra… Read more SQLAlchemy Not Producing Proper SQL Statement For Multi Column UniqueConstraints

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 need to find groups in time series data. Data sample I need to output column group based on val… Read more How To Split Data Into Groups In Pyspark

I have finally succeeded in summing the results of two sql sum queries. One small step for this gu… Read more Significance Of Random Letter At The End Of Sub-query In FROM Clause - SQL

i have string type abc_01, abcd_01 or 02 now i want the substring upto _ ie abc_,abcd_ etc. I am us… Read more Database: SUBSTRING Upto First Occurence Of Character

While I can certainly see the advantages of using parameters for SQL queries, especially when deali… Read more SQL Injection: Isn't Replace("'", "''") Good Enough?

As I build bigger, more advanced web applications, I'm finding myself writing extremely long an… Read more Queries Within Queries: Is There A Better Way?

I have recently installed Visual Studio 2019 and installed the 'Data Storage and processing'… Read more Visual Studio 2019 - SSDT

My PC name is IBALL1. I get an error Login Failed for user 'iball1\User1'.(Microsoft SQL s… Read more Microsoft SQL Server Error: 18456 + Windows Authentication