sql-server Archives - Page 2 of 39

Programming, sql

IT Nursery

How to Select Every Row Where Column Value is NOT Distinct

I need to run a select statement that returns all rows where the value of a column is not distinct (e.g. EmailAddress). For ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

SQL Server loop – how do I loop through a set of records

how do I loop through a set of records from a select? So say for example I have a few records that I ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

Why can’t I use an alias in a DELETE statement?

In SQL Server Compact Edition in Visual Studio 2010 (maybe SQL Server and SQL in general, I don’t know), this command works: DELETE ...

June 1, 2022
0 Comments

Programming, sql-server

IT Nursery

How do I check if a SQL Server text column is empty?

I am using SQL Server 2005. I have a table with a text column and I have many rows in the table where ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

Foreign key constraint may cause cycles or multiple cascade paths?

I have a problem when I try to add constraints to my tables. I get the error: Introducing FOREIGN KEY constraint ‘FK74988DB24B3C886’ on ...

June 1, 2022
0 Comments

Programming, sql-server

IT Nursery

Checking if a SQL Server login already exists

I need to check if a specific login already exists on the SQL Server, and if it doesn’t, then I need to add ...

June 1, 2022
0 Comments

Programming, sql-server

IT Nursery

How to strip all non-alphabetic characters from string in SQL Server?

How could you remove all characters that are not alphabetic from a string? What about non-alphanumeric? Does this have to be a custom ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

What is the benefit of using “SET XACT_ABORT ON” in a stored procedure?

What is the benefit of using SET XACT_ABORT ON in a stored procedure? 5 Answers 5

June 1, 2022
0 Comments

Programming, sql

IT Nursery

How do I remove the first characters of a specific column in a table?

In SQL, how can I remove the first 4 characters of values of a specific column in a table? Column name is Student ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

Error on renaming database in SQL Server 2008 R2

I am using this query to rename the database: ALTER DATABASE BOSEVIKRAM MODIFY NAME =...

May 31, 2022
0 Comments