sql Archives - Page 5 of 71

WordPress

IT Nursery

Automatically generate Post/Page from searched Database item?

I’m currently working with a WordPress developer for my site and we are attempting to create a WordPress post/page for every item in ...

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

MySQL, Programming

IT Nursery

Import SQL file into mysql

I have a database called nitm. I haven’t created any tables there. But I have a SQL file which contains all the necessary ...

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

IT Nursery

How to see the values of a table variable at debug time in T-SQL?

Can we see the values (rows and cells) in a table valued variable in SQL Server Management Studio (SSMS) during debug time? If ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL – Get row number on select

Can I run a select statement and get the row number if the items are sorted? I have a table like this: mysql> ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

How to change the CHARACTER SET (and COLLATION) throughout a database?

Our previous programmer set the wrong collation in a table (Mysql). He set it up with Latin collation, when it should be UTF8, ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

How do I dump the data of some SQLite3 tables?

How do I dump the data, and only the data, not the schema, of some SQLite3 tables of a database (not all the ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

MySQL “NOT IN” query

I wanted to run a simple query to throw up all the rows of Table1 where a principal column value is not present ...

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