Hello experts, here is one for you geniouses out there.
Background:
I have an SQL Server that Transfers several tables from an AS400 daily and adds the data to a database. This is done so that ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21523520.html
I've added a stored procedure into an existing database which is trying to delete records in a table based on where clause criteria. When I try to execute it I get a 'DELETE failed due to setting A...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20790761.html
How to set ansi_null on a database level in MS SQL Server 2000
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21293905.html
the ANSI_Nulls and ANSI_Warnings options to be set for the connection. This ensures consitent query semantics.
Not being a dba, or database guru, I am hoping that someone could explain this in ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21495866.html
Hi Experts,
I'm using SQL Server 2000.
I'm trying to create an index on a view but SQL Server is complaining, 'Object 'tblIndividuals' was created with the following SET options off: 'ANSI_NU...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21568685.html
I have a number of stored procedures which I have created via the Server Explorer in Visual Studio. Subsequently I have created indexes on the (MSSQL) database which need the following database opt...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_21582891.html
Zones:
.NETDate Answered: 10/06/2005 Grade: B Views: 0
what is the purpose of this statement in a sql stored procedure
SET ANSI_NULLS ON
because all it does is allows null values to be unknown....whats the purpose of doing something like that?
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21876278.html
I am trying to write a function that will look up a value in the database but it is not returning anything:
set ANSI_NULLS OFF
set QUOTED_IDENTIFIER OFF
GO
ALTER FUNCTION [dbo].[fn_ProdBom_...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22010039.html
In the procedure below I am removing duplicates from a table.
The script works when run as a script but when put in a stored procedure it complains because the field reference is not created yet. ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22724999.html
Hi all,
I have setup a merge replication between two sqlservers and wrote a
custom conflict resolver
function to resolve conflicts in a table. The code of this stored procedure
is as foll...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20134764.html
