Top "Sql-server" questions

Difference between JOIN and INNER JOIN

Both these joins will give me the same results: SELECT * FROM table JOIN otherTable ON table.ID = otherTable.FK vs …

sql sql-server join inner-join

How to write a foreach in SQL Server?

I am trying to achieve something along the lines of a for-each, where I would like to take the Ids …

sql-server tsql

SQL Server Insert if not exists

I want to insert data into my table, but insert only data that doesn't already exist in my database. Here …

sql sql-server sql-server-2008 stored-procedures

How do I use cascade delete with SQL Server?

I have 2 tables: T1 and T2, they are existing tables with data. We have a one to many relationship between …

sql-server cascading-deletes

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

I am getting the following error. Could you please help me? Msg 547, Level 16, State 0, Line 1 The INSERT statement conflicted with …

sql sql-server sql-server-2005 foreign-keys

What is the difference between Integrated Security = True and Integrated Security = SSPI?

I have two apps that use Integrated Security. One assigns Integrated Security = true in the connection string, and the other …

sql-server security connection-string database-security

Call a stored procedure with parameter in c#

I can do a delete, insert and update in my program and I try to do an insert by call …

c# asp.net sql-server stored-procedures ado.net

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 …

sql-server tsql foreign-keys constraints

SQL Client for Mac OS X that works with MS SQL Server

How can I connect to a remote SQL server using Mac OS X? I don't really need a GUI, but …

sql-server macos

Syntax of for-loop in SQL Server

What is the syntax of a for loop in TSQL?

sql sql-server loops tsql syntax