SMO

RE: Need a datetime validate function

• by mimorr

• Database Journal

• Reply

select * into newtable where isdate(hopefully_date_field) = 1 Insert into newtable select field1, case field2 when isdate(hopefully_date_field) = 1 THEN hopefully_date_field else null end Either of these help?

2003-05-02

RE: SQL 2K SP3 and Backups

• by Rodrigo Acosta

• Database Journal

• Reply

Are you doing your backups to a remote server? It seems that something happend in the network while executing the backups

2003-05-02

1 reads

Books recomended for SQL2000, Win2KSrv, Vb.NET

• by RAD

• Database Journal

• Topic

Can someone recommend good books on SQL2000, Win2KSrv, Vb.NET, ASP.net not for novice, but far from Andy, Brian

2002-03-22

4 reads

SQL to monitor # of Transactions?

• by Unsavory

• Database Journal

• Topic

Hello, Does anyone know if there is a way to query the system tables in SQL server to get a breakdown of how many total transactions or transactions per minute are occuring for each individual database in an instance? I know in Oracle, it is tracked in the system tables and I'm sure it is […]

2002-03-21

1 reads

How to simulate Access 2000 password Input mask

• by kaw

• Microsoft MSDN

• Topic

I have an application with an Access 2000 user interface where the user has the option of using Access Jet Engine as back-end database or SQL Server. With SQL Server though, I've kept 1 table in Access 2000 because I don't know how to handle the Access "Password" input mask for 1 of the fields […]

2002-03-18

5 reads

Parsing a string in an UDF and returning values

• by sdonoghu

• MSDN Communities

• Topic

I am trying to create a UDF that will parse a string based up on delimeter (e.g. '_'). I want to call the UDF and have it return all the sub-strings. Can a UDF return multiple strings? What the best way to parse the following statement: DATA1_DATA2_DATA3 ? Assume: 1. Each part can vary in […]

2002-03-14

DMO; reporting service pack levels

• by column8

• SimpleTalk

• Topic

I'm writing an app using DMO to extract basic info. about my servers. (part of a change control app). A key element in this is being able to ascertain the service pack level of each level. I can extract the Version Number (7, 8 etc) no worries, but can't find a property that will report […]

2002-03-12

3 reads

TABLE data type X Temporary tables

• by Mateus-Espadoto

• SimpleTalk

• Topic

Is the TABLE data type the solution for the old tempdb contention problem ?

2002-03-08

3 reads

Inserting new records using trigger

• by satish

• SimpleTalk

• Topic

I think this maybe a repeat question. How do i insert any new records from table A to table B using triggers? assuming that table A and Table B have same columns.

2002-03-05

SQL.txt will exist in my C:\

• by libniz

• SQLServerCentral.com

• Topic

When I execute my SQLServer(SQL2000) in my local computer,I find a file, which is "SQL.txt" will exist in my C:\.This file can incremental itself and I feel the performance of my SQLServer getting slow.How to solve this problem? The content of "SQL.txt" is: n 5e4-668 ENTER SQLAllocHandle SQLSMALLINT 1 <SQL_HANDLE_ENV> SQLHANDLE 00000000 SQLHANDLE * 0012EBF4 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-02-03