yeah!! Whats the logic of splitting 23 into 4 rows. the sum of minimum values in the four rows comes to 43...

susant the link is http://jumpstarttv.com/

video is at http://www.jumpstarttv.com/backing-up-your-database-with-smo_411.aspx

My Goals

1. Switch to a new job

2. Get Married

3. Learn SQL Server 2005

Just a follow up query on this!

If i'm writing DLLs for extended stored proc, do i need to use C++/C# or Can i use the DLL written in VB 6.0...

Incidently we've implemented the same algorithm as mentioned in the article mentioned by Steve. 128 bit blowfish algorithm.

Would suggest Pavas to download the toolkit and implement it. you can...

Jeff, I must say the way you play around with T-SQL is really amazing. Atleast I couldnt think of using PARSENAME in this example:w00t:

I guess u're referring to SELECT.

=========================

I've a table (reccalldetails) with appx 200,000 rows in it.

I created a non-clustered index on the column POLICYNO in it.

I fired this statement:

Case I

select *...

Vishal Singh (12/26/2008)

---

Yes but in the above condition, once the first update finish the row will be released for other queries.

But if I mix "IS NULL" the update will go...

Whenever you fire an update statement, all the rows under scope will be locked. In first case, you're firing one update statement, the duration of row lock on that particular...

create table #patname

(

FullName varchar(100),

FirstName varchar(100),

MiddleName varchar(100),

LastName varchar(100)

)

insert into #patname(FullName)

select 'John,David Robert'

UNION ALL

select 'sustaita,corie m'

UNION ALL

select 'pena,geneva jesus'

-- Assumption, the field full name contains last name, a comma, first name, a...

susant (12/25/2008)

---

Hi All

I am developing one Windows application... That application using one database named as INVENTORY..All my tables and SP are there in that INVENTORY database...

Requirement

---------------

I hve one menu 'Take...

hi all

Problem

----------------

There are number of databases in my SQLExpress-2005.. like..

1: Master

2: Pubs

3: Inventory..

My application related database is Inventory...

Requirement..

-----------------

1: No can open that database..

sug..

-------

I...

you can use trigger in this scenario. I'm assuming empid is not an identity column and u're manually inserting data in that column.

===================================

create table employees

(

empid int,

empcode varchar(10),

ename varchar(100)

)

create trigger trg_empCode

on...

sp_who2 works just fine for finding sessions. u can also query sysprocesses table.

Merry Christmas to Everyone at SQL Server Central [Steve, Gail, Jack, Michael, Jeff, Barry, Seth, Grant, Jerry and to all wonderful people who selflessly guide us sail through all problems...