Recent content by fxthoth

Hello, try this: select ownType.name, systemType.name, ownType.max_length, ownType.precision, ownType.scale, ownType.is_nullable, ownType.is_user_defined from sys.types as ownType inner join sys.types as systemType on ownType.system_type_id=systemType.user_type_id where...

Of course, you can use directly: update @myTable set foo='new value' where (LEN(foo) - LEN(REPLACE(foo, '|' ,'')))=1 My mistake...

Hello, try this: declare @myTable table ( id int identity primary key not null, foo varchar(100) not null ) insert into @myTable values('abc|def') insert into @myTable values('abc|def|') insert into @myTable values('abcd|efgh') insert into @myTable values('abcd|efgh|ij|kl') --select values...

I have tested it also on Express 2008 and it works fine if you write all via sql code. Btw. I apologize, but on my Firefox didn't show any of adult ads. I used imagevenue a few years ago and they had any adult ads. So now I see, they have changed it. Of course first of all I tried use the...

You are right, I tested it and intellisence didn't work with manually created table. But it works with sql code created tables. So I suppose this should be the solution... :)

Hi. It really depends on what values can be there... Try this: create table example( foo varchar(100) ) insert into example values('PR10232A') insert into example values('123456A') insert into example values('65498566ABC') insert into example values('65AD123456AB') select...

I tried it and it works for me. I didn't create the table, but it is showed in intellisence. Look at picture: http://img240.imagevenue.com/img.php?image=21843_file01_122_514lo.jpg This is my version of SQL Server: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008...

Great.

Maybe it blocks antivirus or antispyware. Or net hardware like UTM. Try upload it to localhost at the same computer.

Hello, list of all errors is here for SQL Server 2005 or 2008: select * from sys.messages and here for SQL Server 2000: select * from master.dbo.sysmessages But you can catch errors in SQL Server 2005 or 2008 in T-SQL. Here is demonstration how TRY/CATCH works...

You can also write constraint: create table example( col1 int ) alter table example add constraint mod3 check (col1%3=0) insert into example values (0)--is ok insert into example values (1)--fails insert into example values (3)--is ok insert into example values (4)--fails

Thank you both for helpfull answers.

Hi. Is in T-SQL possible to do something like switch in PHP? www.php.net/switch I have this code: declare @variable int set @variable=3 if @variable=1 begin print 'a' print 'another t-sql commands continue...' end else if @variable=2 begin print 'b' print 'another t-sql commands...

Hi. First of all backup your data. Than you can use REPLACE(): select replace('myAccount@e-mail.com','e-mail.com','newe-mail.com') returns myAccount@newe-mail.com For UPDATE it could work like: update yourtable set email=replace(email,'e-mail.com','newe-mail.com')

In SQL server 2005 you can use DENSE_RANK(), which should do exactly what you want. declare @myTable table( start datetime, info varchar(20) ) insert into @myTable values ('20080501','Median deposit') insert into @myTable values ('20080501','Average deposits') insert into @myTable values...