Lab Sql

I have an Excel workbook with the below code - Sub Button1_Click() Dim conn As New ADODB.Connec… Read more Insert New Records Only Into Sql Table Using Vba

I want to search all employees with the corresponding ids stored in the serialNumberList and add al… Read more How To Use Setparameter In Hibernate

I have a table, lets call it tblINVOICE. The invoice can hold one or more item and for each item on… Read more Sql Pivot Insertion

A carer can provide support to two different service at the same Start time and End time this is ca… Read more How Do I Put A Condition In The Select Statement In T-sql

I need to get the folder with full path of my SQL Server instance installed on my machine, using vb… Read more How Do I Get Sql Server Instance Path Using Vb.net Code

I am getting this error when I try to write rows to a table via SqlBulkCopy and a DataTable object.… Read more Sqlbulkcopy Failed To Obtain Column Collation Information For The Destination Table

How can I execute SQL statements from a C program. For example I want to display the output of sele… Read more How To Execute Sql Statements From A C Program?

I am trying to insert data from one of my existing table into another existing table. Is it possibl… Read more "select * Into Table" Will It Work For Inserting Data Into Existing Table

It looks like each one covers the basic cases like selecting certain columns and filtering by predi… Read more How Does Clojureql Compare To Clojure.contrib.sql?

I want to write a sql statement to trim a string 'Hello' from the string 'Hello World&#… Read more Trim Left Characters In Sql Server?

I have a database which contains significant number of tables. Some of the tables are owned by post… Read more How To Alter The Ownership Of Some Tables Inside A Database From Postgres To Another User?

I am trying to do an Ordering System where you can put many Products in one order. I have very litt… Read more Multiple Values In One Field (foreign Keys?)

Trying to update a table on a linked server (SQL 2000/2005) but my server name will not be known ah… Read more Fully Qualified Table Names With Sp_executesql To Access Remote Server

I'm trying to export some data from MATLAB to a database. I use a PostgreSQL database via ODBC … Read more Why Am I Getting This Error When Creating An Sql Query In Matlab?

I'm using IW for weekly result and MM for Monthly result. But I always get an error: ORA-00979:… Read more Using Iw And Mm In Oracle

I would like to install SQLExpress2005 as an instance 'SQLExpress' and install SQLExpresss2… Read more Can Sqlexpress 2005 And 2008 Be Installed On Same Machine Without Issue?

I want to start using datetime2 fields in SQL Server and I need to insert into the tables via ADO f… Read more Using Sql-server Datetime2 With Tadoquery.open

I'm usinq Laravel 5 with MS Sql Server 2014. I want to create a unique constraint but it should… Read more Laravel Eloquent How To Create Unique Constraint With Duplicate Nulls

Apologies if this question has already been answered, I've already done an extensive search but… Read more Advanced Mysql Alphabetical Sort With Prefix?

I installed SQL Server 2008 (not express) on my PC, but when tried to connect with SSMS, got this m… Read more Why Can't I Connect To My Local Sql Server Database Instance?