sql-server Archives - Page 36 of 39

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But ...

Are disabling and enabling foreign key constraints supported in SQL Server? Or is my only option to drop and then re-create the constraints? ...

I want to update a column in a table making a join on other table e.g.: UPDATE table1 a INNER JOIN table2 b ...

I’ve been learning Functions and Stored Procedure for quite a while but I don’t know why and when I should use a function ...

We all know that to select all columns from a table, we can use SELECT * FROM tableA Is there a way to ...

I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.name AS Object_Name, o.type_desc ...

What is the best way to get the names of all of the tables in a specific database on SQL Server? 19 s ...

What is the main purpose of using CROSS APPLY? I have read (vaguely, through posts on the Internet) that cross apply can be ...

How do I parameterize a query containing an IN clause with a variable number of arguments, like this one? SELECT * FROM Tags ...

I have a database with account numbers and card numbers. I match these to a file to update any card numbers to the ...