I stand by my comment that this entirely too vague to provide an answer. What does...

Questions 1 and 5 do not have enough details to provide an answer. I would be asking for a lot of clarity about what those mean. 2, 3 and 4...

nick.wright 69367 (12/4/2012)

---

That's great, Sean. Unfortunately, being an "agile" kind of developer, the ink on my code is still wet as it goes into a live environment ;-). The new...

It would not work inside a stored proc. It would end the batch. 🙂

For example if you have a script that create a stored proc and a view you HAVE...

Sounds like you should look into a calendar table. Check out this article. http://www.sqlservercentral.com/articles/T-SQL/70482/%5B/url%5D

Hi and welcome to SSC. In order to be able to provide an answer we need some details. Specifically we need ddl (create table statements), sample data (insert statements) and...

Or even this.

IF cast('12/04/2012' as datetime) < cast('03/01/2013' as datetime)

select 1

Shadab Shah (12/4/2012)

---

anthony.green (12/4/2012)

---

GO is a batch sperator.

So you could say

Do Something

Do Something Else

Do Something More

GO

Do Something Even More

Do Something Better Than Before

GO

And it would execute the first three things...

nick.wright 69367 (12/4/2012)

---

Thank you very much for this. I wouldn't normally use a while loop in a function, but looking at the replace/substring code I've written in the past to...

Isn't this the same question you posted yesterday??

http://www.sqlservercentral.com/Forums/Topic1391849-391-1.aspx

Please stop cross posting. You don't need to start a new thread for each follow up question.

http://www.sqlservercentral.com/Forums/Topic1392324-391-1.aspx

Hi an welcome to SSC. It is impossible to provide any detailed help based on your post because there just aren't any details. I think that maybe what you want...

It is called SARGability. When you add that where clause it causes a full scan. It has to evaluate every single row to determine if it belongs in the result...

There are basically 3 ways to handle storing binaries with sql.

1) Store the files on disc in a folder and then store the file name in sql. You basically just...

boobalanmca07 (12/4/2012)

---

i have using two query in stored procedure, i want to use insert query in some time only

alter proc proc_emp1

@i int,

@pempid int,@pempname varchar(30),@pm1 int,@sm1 int

as

print @i

if @i<=1

begin

--if @i='I'

insert...