Lab Sql

i have one excel file that contains a1 to a5 rows with values now a6= sum(a1:a5) I want a6 value to… Read more Insert Data From More Than One Excel Sheet Of One File Into Table Using Ssis?

As i am having AMD processor in my laptop i am using GENYMOTION as an emulator. I have stored the d… Read more How To See The Data Stored In Sqlite In Android Studio Using Genymotion As Emulator

I want to use the following SQL statement in a small C# application. The SQL statement runs perfec… Read more C# Parameterized Query With Domain Aggregate Functions (dmin)

I am working with loading XML files contents into a table in a SQL Server database, for which I wan… Read more Deleting And Restoring Foreign Key Values In Sql Server Database Table

I am just wondering any good tools or software that you can recommend me to protect / encrypt my st… Read more Sql Server : Encrypt / Protect Stored Procedure

string que = 'SELECT Name FROM StudentInfo where StudentNo=textBox1.Text '; Every time I r… Read more Getting Value From A Database Using Textbox

i have table with following structure and data: I would like to get grouped data by months in give… Read more Sqllite Strftime Function To Get Grouped Data By Months

How to convert string '۱۳۹۴' to '1394'? I try change collation but does not work. P… Read more Convert Unicode String To Ascii In Sql Server

I have a hive table, htable that's partitioned on foo and bar. I want to create a small subset … Read more Hive - How To Efficiently Create Table As Select?

I have a table vw_Lab_Space which lists out all of my labs, and has a Lab_Space_Id column which is … Read more Need Help Creating An Outer Join To Count Spaces

I could see the below entries in the ULS log 02/08/2010 14:36:46.12 w3wp.exe (0x15F4) … Read more Issue With Sql Stored Procedure

this is my docker-compose file.yaml: version: '3.3' services: db: container_name: db… Read more Run Java In Docker-compose

I am trying to remotely connect to a Microsoft SQL Server from Node (using node-mssql). var sql = r… Read more Which Ip To Use To Remote Connect To Sql Server?

I am getting this error while I am fetching value from resultset. Error : com.microsoft.sqlserve… Read more The Column Name Is Not Valid - Error

Im working with a Sqlite database in C#, when I insert my date into it, everything works fine (in t… Read more Sqlite Cuts Off Zeros, When Updating Database

I have a table names Employee which is referenced to almost 85 tables in database. I want to make f… Read more Drop And Recreate Constraints Script

There is a column that can have several values. I want to select a count of how many times each dis… Read more Sql: Select Sum Of Each Individual Value Of A Column

I have a table with is simply a list of dates and user IDs (not aggregated). We define a metric ca… Read more Google Bigquery: Rolling Count Distinct

I am developing a web app that interfaces with an ERP production database and the data is being ret… Read more Making A Laravel Model Use Complex Query As Table

I want to create an Express REST API and will use MSSQL for the database part. I use the mssql modu… Read more Transaction For Prepared Statements Using Node Mssql