Viewing 15 posts - 301 through 315 (of 1,048 total)
The information is not sufficient to provide you the solution...
Can you please some more detailed information so that we can help you?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 2, 2013 at 12:42 am
please provide some more information like what output you required so that we can help you..........
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 1, 2013 at 7:18 am
Try in this manner-
create procedure test_sp
AS
BEGIN
declare @count int
Select @count = COUNT(*) from test
RETURN @count
END
Declare @storevalue int
EXECute @storevalue = test_sp
SELECT @storevalue
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 1, 2013 at 6:20 am
yes, your syntax is incorrect...
it should be like this:
INSERT INTO table_name
SELECT coumn_names from table_name
Follow the post of laurie, it will works
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 1, 2013 at 6:07 am
Erland Sommarskog (7/31/2013)
Running dynamically generated queries through OPENQUERY requires strict discipline in order to protect your mental health. Look at http://www.sommarskog.se/dynamic_sql.html#OPENQUERY for some tips.
Excellent article Somm 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 31, 2013 at 11:44 pm
Easy one for the day 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 31, 2013 at 10:58 pm
you haven't specified the condition thats why you are getting values for all the year....
Put a where clause too in your query....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 31, 2013 at 5:25 am
Hugo Kornelis (7/31/2013)
karuppusamy.kk (7/31/2013)
Please clarify my following concern about this question..Why not DBCC CHECKIDENT?
The short and simple answer: because Microsoft didn't build DBCC CHECKDB to include CHECKIDENT.
The longer and more...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 31, 2013 at 3:04 am
SELECT name from tempdb.sys.objects
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 31, 2013 at 1:19 am
L' Eomot Inversé (7/30/2013)
PHYData DBA (7/30/2013)
thierry.vandurme (7/30/2013)
Hi Philipthat indeed explains it. Thx a lot! I was almost losing my mind over this 🙂
Chrz
Thierry
Thierry,
That explanation is not correct for TSQL. ...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 30, 2013 at 10:27 pm
Nice question,........
Thanks Steve 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 30, 2013 at 10:16 pm
GilaMonster (7/30/2013)
http://msdn.microsoft.com/en-us/library/cc280372%28v=sql.100%29.aspx
Thanks Gail for the useful link 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 30, 2013 at 4:44 am
Koen Verbeeck (7/30/2013)
A unique index can also be filtered, while a PK...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 30, 2013 at 4:17 am
Gila,
can you please tell me about this Eager pool? I am not aware of this thing
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 30, 2013 at 3:41 am
Good one Paul 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 30, 2013 at 3:35 am
Viewing 15 posts - 301 through 315 (of 1,048 total)