How can I get column names from a table in SQL Server?
I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But … Read more
sql-server
How can foreign key constraints be temporarily disabled using T-SQL?
Are disabling and enabling foreign key constraints supported in SQL Server? Or is my only option to drop and then re-create the constraints? … Read more
Update a table using JOIN in SQL Server?
I want to update a column in a table making a join on other table e.g.: UPDATE table1 a INNER JOIN table2 b … Read more
Function vs. Stored Procedure in SQL Server
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 … Read more
Exclude a column using SELECT * [except columnA] FROM tableA?
We all know that to select all columns from a table, we can use SELECT * FROM tableA Is there a way to … Read more
Search text in stored procedure in SQL Server
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 … Read more
How do I get list of all tables in a database using TSQL?
What is the best way to get the names of all of the tables in a specific database on SQL Server? 19 s … Read more
When should I use CROSS APPLY over INNER JOIN?
What is the main purpose of using CROSS APPLY? I have read (vaguely, through posts on the Internet) that cross apply can be … Read more
Parameterize an SQL IN clause
How do I parameterize a query containing an IN clause with a variable number of arguments, like this one? SELECT * FROM Tags … Read more
SQL update from one Table to another based on a ID match
I have a database with account numbers and card numbers. I match these to a file to update any card numbers to the … Read more