Viewing 15 posts - 1 through 15 (of 25 total)
Unfortunately, it doesn't help
February 19, 2009 at 10:08 am
My question is "How to change the option ANSI_NULLs of existing table?"
February 19, 2009 at 9:53 am
Restart of the server didn't help.
The Sql-
alter table tablename
set SET ANSI_NULLs ON
is not correct
I get the error "Incorrect syntax near the keyword 'set'."
Do you know the correct syntax?
February 19, 2009 at 8:37 am
I 've changed the option for the database
Unfortunately, it doesn't change ANSII_NULLs option for the table
February 19, 2009 at 7:52 am
what code do you mean?
I can't recreate the table because ther are a lot of data in it.
It lookup table, so many other tables are connected to it .
February 19, 2009 at 7:47 am
Ken, thank you for your help.
Your idea is good, but there is a point that I need to get in result set
all fields from table1.
How can I get them...
April 18, 2007 at 9:49 am
I'm soryy for errors. I wanted to simplify my example.
Actual code is very complicated.
There are many tables in this query.
There ia a part from it:
select
m.minvc_id,
m.minvc_check_type ,
a.eqicf_tariff
from
dbo.metrology_inventory_checks m
...
April 18, 2007 at 9:24 am
Thank you very much.
The both answers are great.
It helped me.
November 22, 2006 at 4:17 am
It works great.
Thank you very much, David.
July 27, 2006 at 7:43 am
try
select rows
FROM sysindexes WHERE indid IN(1,2,255)
and object_name(id) = 'TableName'
December 29, 2005 at 8:21 am
declare @tab table (spid integer)
INSERT @tab
select spid FROM OpenRowset('SQLOLEDB', 'Server=(local);Trusted_Connection=yes',
'SET fmtonly OFF
exec master..sp_who2 ') A
where
dbname='DBASE'
and ProgramName='Microsoft (R) .NET Framework'
and hostname='devel'
and...
December 21, 2005 at 7:26 am
create table #test (trgname varchar(100), owner varchar(40),isupdate bit,isdelelete bit,isinsert bit,isafter bit, isinsteafof bit)
exec sp_msforeachtable 'insert into #test exec sp_helptrigger ''?'''
select * from #test
go
drop table #test
November 3, 2005 at 2:40 am
I'm sorry, but i don't understood
what you mean by "Windows group".
There are only concepts : login, users, roles in SqlServer.
Where can I create Windows group?
May 24, 2005 at 5:59 am
Thanks to everybody who tried to help me.
Karl, your solution with ANSI_NULLS is great, but your explanation convinced me to use 2 queries.
Frank, Maths! Your solutions don't work . They...
May 15, 2005 at 4:13 am
thank you very much for all answers. It really helped me.
February 14, 2005 at 10:20 am
Viewing 15 posts - 1 through 15 (of 25 total)