the only things you identified so far is a slight shortening of a couple of keywords....saving a handful of keystrokes doesn't mean that's an improvement, just a preference.

same thing, different way:

[font="Courier New"]UPDATE mytable

SET myfield= '************' + RIGHT(myfield,4)

WHERE LEN(myfield) = 16 --only change items that are exactly 16 chars

SELECT * FROM mytable WHERE LEN(myfield) <> 16 [[/font]

...

do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

everyone uses the "View Latest Posts", so you need to post this only...

do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

everyone uses the "View Latest Posts", so you need to post this only...

do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

everyone uses the "View Latest Posts", so you need to post this only...

do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

everyone uses the "View Latest Posts", so you need to post this only...

I've done something similar, but made sure it was an application that happens to conenct to SQL server, not do it via SQL server itself.

.NET DataSource object has the ability...

eashoori (3/13/2009)

---

Thank you so much Lowell, do we call this procedure before restore command in another SSIS step or cna we just incorporate it in the same?

thanks a lot for...

if the stored procedure returns 10 columns, you'll have to have a temp table that catches all ten columns...after that, you could ignore the other columns and continue from...

this proc might come in handy: sp_kill

usage is simply sp_kill YOURDBNAME

kills all the sessions connected to the database you identify:

[font="Courier New"]--enhanced 02/04/2005 to also list hostname

CREATE PROCEDURE sp_Kill

@DBNAME VARCHAR(30)

--Stored...

the info is in the registry...i've got this script saved in my snippets, it used to work well:

CREATE TABLE #GetPort

(

token varchar(100),

value varchar(20))

go

DECLARE @inst varchar(200)

DECLARE @inst1 varchar(100)

--Determine registry path and key

IF(charindex('\',@@servername)...

great code examples; what if i wanted to generate X number strings, for arguments sake lets say 10...i can't seem to visualize how to generate multiple records though.

rub my nose...

yes.

whether the PK is identity, or a non identity PK:

both of these examples work:

[font="Courier New"]

CREATE TABLE A( empno INT IDENTITY(1,1) PRIMARY KEY, emp VARCHAR(64),empaddress VARCHAR(64))

GO

CREATE VIEW V AS  SELECT empno, emp...

ahh Lynn I like that code;

I parameterized the TOP (64) with @top, and can use that to generate any length whether 64 here, ro whatever i might need.

very nice!

Thanks...

i had to base the business rule on the prototype trigger you showed me, plus the 3 strikes your out rule.

your trigger implied if 3 specific fields were NOT NULL,...