tagged [sql]
Should I be using SQL transactions, while reading records?
Should I be using SQL transactions, while reading records? SQL transactions is used for insert, update, but should it be used for reading records?
- Modified
- 20 Jul at 15:40
Entity Framework - SQL Azure Retry Policy
Entity Framework - SQL Azure Retry Policy Could anyone guide me how to implement a retry policy with EF to SQL Azure, please.
- Modified
- 2 May at 22:49
SQL query to find Primary Key of a table?
SQL query to find Primary Key of a table? How can I find which column is the of a table by using a query?
- Modified
- 11 Sep at 23:42
How to check active transactions in SQL Server 2014?
How to check active transactions in SQL Server 2014? I am using SQL Server 2014 and want to know how to check my active transactions?
- Modified
- 12 Aug at 07:23
Insert the same fixed value into multiple rows
Insert the same fixed value into multiple rows I've got a table with a column, lets call it `table_column` that is currently `null` for all rows of the table. I'd like to insert the value `"test"` int...
- Modified
- 3 May at 21:23
Favourite performance tuning tricks
Favourite performance tuning tricks When you have a query or stored procedure that needs performance tuning, what are some of the first things you try?
- Modified
- 27 Aug at 11:44
Most efficient T-SQL way to pad a varchar on the left to a certain length?
Most efficient T-SQL way to pad a varchar on the left to a certain length? As compared to say:
- Modified
- 19 Mar at 01:29
SQL - Query to get server's IP address
SQL - Query to get server's IP address Is there a query in SQL Server 2005 I can use to get the server's IP or name?
- Modified
- 26 Sep at 21:37
how do you insert null values into sql server
how do you insert null values into sql server In sql server enterprise manager, how do you write an insert statement and pass in `null` values?
- Modified
- 25 Apr at 12:57
How to detect if a string contains special characters?
How to detect if a string contains special characters? How to detect if a string contains special characters like #,$,^,&,*,@,! etc (non-alphanumeric characters) in SQL server 2005?
- Modified
- 20 May at 14:59
Do while loop in SQL Server 2008
Do while loop in SQL Server 2008 Is there any method for implement `do while` loop in SQL server 2008?
- Modified
- 8 Aug at 03:38
how to convert numeric to nvarchar in sql command
how to convert numeric to nvarchar in sql command I need to convert a numeric value to nvarchar in sql command. Can anyone please help me.
- Modified
- 7 Dec at 06:45
Turn off constraints temporarily (MS SQL)
Turn off constraints temporarily (MS SQL) I'm looking for a way to temporarily turn off all DB's constraints (eg table relationships). I need to copy (using INSERTs) one DB's tables to another DB. I k...
- Modified
- 8 Apr at 20:35
Convert Xml to Table SQL Server
Convert Xml to Table SQL Server I wonder how can i read a xml data and transform it to a table in TSQL? For example: ``` 8 3 8 8 25 4568457 3
- Modified
- 16 Feb at 15:59
How do I find duplicates across multiple columns?
How do I find duplicates across multiple columns? So I want to do something like this sql code below: To produce the following, (but ignore where only name or only city match, it has to be on both col...
- Modified
- 24 Dec at 10:10
How to convert Varchar to Int in sql server 2008?
How to convert Varchar to Int in sql server 2008? How to convert Varchar to Int in sql server 2008. i have following code when i tried to run it wont allowed me to convert Varchar to Int. Column1 is o...
- Modified
- 1 Nov at 21:34
Count records for every month in a year
Count records for every month in a year I have a table with total no of 1000 records in it.It has the following structure: I want to calculate no of records for every month in year-2012 Is there any w...
- Modified
- 27 Mar at 11:46
CROSS JOIN vs INNER JOIN in SQL
CROSS JOIN vs INNER JOIN in SQL What is the difference between `CROSS JOIN` and `INNER JOIN`? ``` SELECT Movies.CustomerID, Movies.Movie, Customers.Age,
- Modified
- 12 Dec at 08:55
How do I set a column value to NULL in SQL Server Management Studio?
How do I set a column value to NULL in SQL Server Management Studio? How do I clear the value from a cell and make it NULL?
- Modified
- 25 Mar at 13:50
How to limit rows in PostgreSQL SELECT
How to limit rows in PostgreSQL SELECT What's the equivalent to SQL Server's `TOP` or DB2's `FETCH FIRST` or mySQL's `LIMIT` in PostgreSQL?
- Modified
- 6 Mar at 13:46
How to detect if a string contains at least a number?
How to detect if a string contains at least a number? How to detect if a string contains at least a number (digit) in SQL server 2005?
- Modified
- 7 Sep at 10:41
I want to show all tables that have specified column name
I want to show all tables that have specified column name How can I get a list of all the tables that have a specific column name?
- Modified
- 7 Mar at 10:3
Find all tables containing column with specified name - MS SQL Server
Find all tables containing column with specified name - MS SQL Server Is it possible to query for table names which contain columns being ?
- Modified
- 25 Apr at 13:48
How to list files inside a folder with SQL Server
How to list files inside a folder with SQL Server How do I list files inside a folder in SQL Server without using the `xp_cmdshell` stored procedure?
- Modified
- 19 Jul at 12:12
SQL "between" not inclusive
SQL "between" not inclusive I have a query like this: But this gives no results even though there is data on the 1st. `created_at` looks like `2013-05-01 22:25:19`, I suspect it has to do with the tim...
- Modified
- 12 Feb at 02:54