Viewing 15 posts - 9,871 through 9,885 (of 15,374 total)
komal145 (12/4/2012)
Sorry the questions is like this: Design a table, how to track phone call.
I stand by my comment that this entirely too vague to provide an answer. What does...
December 4, 2012 at 10:17 am
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...
December 4, 2012 at 8:39 am
nick.wright 69367 (12/4/2012)
December 4, 2012 at 8:33 am
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...
December 4, 2012 at 8:28 am
Sounds like you should look into a calendar table. Check out this article. http://www.sqlservercentral.com/articles/T-SQL/70482/%5B/url%5D
December 4, 2012 at 8:21 am
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...
December 4, 2012 at 8:18 am
Or even this.
IF cast('12/04/2012' as datetime) < cast('03/01/2013' as datetime)
select 1
December 4, 2012 at 8:16 am
Shadab Shah (12/4/2012)
anthony.green (12/4/2012)
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...
December 4, 2012 at 8:14 am
nick.wright 69367 (12/4/2012)
December 4, 2012 at 8:03 am
Isn't this the same question you posted yesterday??
http://www.sqlservercentral.com/Forums/Topic1391849-391-1.aspx
December 4, 2012 at 8:01 am
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
December 4, 2012 at 8:00 am
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...
December 4, 2012 at 7:56 am
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...
December 4, 2012 at 7:48 am
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...
December 4, 2012 at 7:43 am
boobalanmca07 (12/4/2012)
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...
December 4, 2012 at 7:35 am
Viewing 15 posts - 9,871 through 9,885 (of 15,374 total)