2003-06-04
tables
RE: Copy data
Is the ID field an IDENTITY field?? If it is you can SET IDENTITY_INSERT ON Then you can insert your identity from table a into table b. AJ Ahrens SQL DBA Revenue Assurance Management - AT&T
2003-06-03
RE: Copy data
update db2.dbo.mytext set spanish = db1.dbo.mytext.spanish from db1.dbo.mytext inner join db2.dbo.mytext on db1.dbo.mytext.id = db2.dbo.mytext.id
2003-06-03
RE: Lost the MDF, have the LDF
If you don't have any complete database backup, it is impossible to restore database from just .ldf. Robert
2003-05-29
2003-05-28
RE: Problems executing Stored Procedures via JDBC
Hi, well I'n not very experienced in JAVA, but maybe you can post some code snippets. That will surely help! Cheers, Frank
2003-05-28
RE: Need a good Internet Mail Server
Another good free alternative could be 'Mercury' which is the complementary Mail Transport for the email client 'Pegasus Mail'. See . While I haven't used it in anger myself I did have a play with it some months back. Pegasus/Mercury is highly regarded software used extensively in UK Academic institutions due to it's support for […]
2003-05-27
RE: Can you run SQL server and IIS on same box?
Perhaps I shouldn't save the numbers then. I do not have the option of a different server. The project doesn't have the budget. I can just have the clients sign up for a year. and make them log in one time per year to re-up. I was just thinking I could write the contract such […]
2003-05-25
RE: Procedure cache - recompile problem
Example script: set nocount on go if object_id('cache_test') is not null drop table cache_test go create table cache_test ( id int not null, descr varchar(30) not null, rowcreateddt datetime not null default getdate(), rowcreatedby varchar(30) not null default right(system_user,30), testcolumn varchar(30) null, primary key (id) ) go create trigger cache_test_update on cache_test for update as […]
2003-05-15
2 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers