Viewing 15 posts - 1,336 through 1,350 (of 5,590 total)
May 22, 2011 at 11:30 am
The issue is that the DELETE statement supports two FROM clauses. To make it even better, the first FROM keyword is optional. It is with the second FROM clause where...
May 21, 2011 at 5:50 pm
I remember reading about something with update and join, where you needed to have the first table in the from clause be the table being updated. Something Jeff mentioned about...
May 21, 2011 at 5:40 pm
You might want to check out the INSERT statement in BOL - specifically look at the "(column_list)" section.
May 21, 2011 at 2:38 pm
LutzM (5/21/2011)
This is designed to do the same sort of thing as Access's cascade delete function.
Why don't you add a (referential) foreign...
May 21, 2011 at 2:35 pm
Hi Tiya,
It's not so much CTE that you need to learn about, as it is WITH common_table_expression (Transact-SQL).
Edit: CTE is just an acronym for "common-table-expression".
May 21, 2011 at 2:28 pm
This post makes me want to see Rob's pre-conference session this October at the PASS Summit. Hopefully he will get picked and many of us will get the chance to...
May 21, 2011 at 12:53 pm
I wouldn't normally post a looping method, but for the number of lines that you're dealing with I'm not sure that you'll get any faster.
DECLARE @crlf CHAR(2);
SET @crlf = CHAR(13)...
May 20, 2011 at 3:22 pm
Ahh yes, much better. Excellent job Sean!
May 20, 2011 at 3:07 pm
jarid.lawson (5/20/2011)
I admit I am stuck on using loops too often. Part of why I'm on here is to...
May 20, 2011 at 12:51 pm
Sean Lange (5/20/2011)
Something like this?
declare @MyString varchar(max) = '----A375475960dkgjfkfkgjfkvkl!!!!!-------DAfkdfk55500---!'
select len(@MyString) - len(replace(@MyString, 'a', ''))
Very nice Sean.
One thing to point out (for all solutions for this) is that if you have...
May 20, 2011 at 12:47 pm
Grant Fritchey (5/20/2011)
Q: Ever heard of nHibernate?A: Yes
Q: Next candidate!
+10!
May 20, 2011 at 12:01 pm
This ORM link was just pointed out to me: EntityFramework 4.1 RC – Code first; review.
Wondering what you'll think of the "Lack of good identifiers generators" section? Especially the "any...
May 20, 2011 at 9:09 am
Mahesh Bote (5/20/2011)
Hopes, below code might help you out. However you need to look into the logic first, before executing it. And hopes you will make corrections in logic, if...
May 20, 2011 at 8:36 am
mahe2682 (5/20/2011)
Thanks for your responce. actually i copied somewhere that above code.can u help me for this.
Okay, let's look at this piece by piece, and see what we can...
May 20, 2011 at 8:34 am
Viewing 15 posts - 1,336 through 1,350 (of 5,590 total)