sql-server Archives - Page 2 of 16

I need to implement the following query in SQL Server: select * from table1 WHERE (CM_PLAN_ID,Individual_ID) IN ( Select CM_PLAN_ID, Individual_ID From CRM_VCM_CURRENT_LEAD_STATUS ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

Keeping it simple and how to do multiple CTE in a query

I have this simple T-SQL query, it emits a bunch of columns from a table and also joins information from other related tables. ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

Sql Server string to date conversion

I want to convert a string like this: '10/15/2008 10:06:32 PM' into the equivalent DATETIME value in Sql Server. In Oracle, I would ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL Server database backup restore on lower version

How to restore a higher version SQL Server database backup file onto a lower version SQL Server? Using SQL Server 2008 R2 (10.50.1600), ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

Using varchar(MAX) vs TEXT on SQL Server

I just read that the VARCHAR(MAX) datatype (which can store close to 2GB of char data) is the recommended replacement for the TEXT ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL Server String or binary data would be truncated

I am involved in a data migration project. I am getting the following error when I try to insert data from one table ...

May 30, 2022
0 Comments