the trick is to use a combination of dateadd and datediff, here's sme examples of some firsts and lasts; to apply the logic to a specific daye, like "what...

there are a lot of options for linked server security; i've only used three ways, which i'll try to explain:

1: anyone accessing the linked server uses a specific logon from...

i think you are looking for the LUHN mod 10 credit card validation, right? googling "TSQL LUHN mod 10"

got me this tsql code snippet"

http://www.novicksoftware.com/UDFofWeek/Vol2/T-SQL-UDF-Vol-2-Num-47-udf_Bank_IsLuhn.htm

it looks like you have not added the PAYEE_ID yet:

ALTER TABLE #PAYEES

--add first item: column

ADD PAYEE_ID INT NOT NULL,

--add second item: constraint

CONSTRAINT PK_payeeID PRIMARY KEY CLUSTERED (PAYEE_ID) ...

i copied and pasted the example, and it works fine; it might be the case-sensitive collation of your database...i noticed i spelled it "tally" in one spot, and "Tally" in...

both of these syntaxes worked fine for me, against know tables for me; i don't get the syntax error you were using

ALTER TABLE [dbo].[MYTBL1] ADD DEFAULT (getdate()) FOR [APPLDT]

ALTER TABLE...

i believe you are correct, you can use it to find non latin characters. I'd need to test it against more varied data; is it working for you as expected?...

J-F if possilbe, can you get rid of the function and just add a persisted calculated column instead? persisted stores the value in the data pages, and would be much...

timscronin (1/6/2010)

---

I have this idea which works row by row, but I need it to be inline sql

DECLARE @drugName VARCHAR(20), @amp_position INT

SELECT @drugName = '100MGWaldorf'

SET @amp_position = CHARINDEX( 'MG', @drugName)...

I believe i've seen this condition when a users credentials has a default database other than the one being connected to.

What I mean is if i created a new user...

Based on what Jack said,...

while you can do it from within SQL server with some TSQL commands, guess what....all the work goes out to xp_cmdshell to call programs like 7zip/winzip/pkzip, and then the MOVE...

nope;obfuscating table definition itself is not possible. I'm sure you feel proud of your design, and feel someone could possibly reverse engineer some of your business practices simply by looking...

why not have the app itself test for inactivity, and log people out after say, 20 minutes? then you could have a pop-up screen that said they were logged out....

just so you know what the issue is:

in TSQL, a CASE statement is used to decide which data to return; it can only return one of the SQL datatypes. you...