Viewing 15 posts - 10,561 through 10,575 (of 15,381 total)
jrichards54 (9/27/2012)
I have created a database in ACCESS and named it "ConnectionTest.mdb"...
September 27, 2012 at 12:10 pm
vivekkumar341 (9/27/2012)
instead of having multiple if blocks, can't you use switch statements?
There is no switch statement in t-sql which I suspect is why there are so many nested if-else conditions.
September 27, 2012 at 12:06 pm
SQL_Loser (9/27/2012)
1.What is the purpose of self referential foreign keys ? or why do we create it?
2.In a many to...
September 27, 2012 at 12:00 pm
harri.reddy (9/27/2012)
hii want to insert 1000 rows in a table without any loop.
how can i do it?
Start with the first link in my signature.
September 27, 2012 at 11:57 am
Duplicate post. Please direct all replies to the original thread. http://www.sqlservercentral.com/Forums/Topic1365421-146-1.aspx
September 27, 2012 at 11:57 am
Luis Cazares (9/27/2012)
I disagree, varchar can hold up to 8000 characters in 2000 (nvarchar will only hold up to 4000, though).http://msdn.microsoft.com/en-us/library/aa258242(SQL.80).aspx
Another option is to use text columns
Doh!!! You are right...
September 27, 2012 at 11:54 am
D.Post (9/27/2012)
Before inserting the data, find out what the MAX(LEN(Col)) is for each column. Compare the results to your variable declarations and destination table design.
Btw, varchar(max) isn't recognized in...
September 27, 2012 at 7:35 am
I found this one a bit off. I assumed that the two lines setting IDENTITY_INSERT were typos because otherwise this entire batch would insert no rows. However if you fix...
September 27, 2012 at 7:29 am
dwain.c (9/26/2012)
Using it, I'd like to offer a slightly less verbose solution:
SELECT *, WaitTime=DATEDIFF(minute
,CAST(check_in AS TIME)
,CAST(STUFF(appt_time, 3, 0,...
September 27, 2012 at 7:15 am
I see you are new around here. It is generally considered best to post ddl and sample data in a consumable format. I did this for you as an example...
September 26, 2012 at 4:04 pm
Can you ddl and sample data for TableC? Also, a clear explanation what you are trying would help. I am not sure I understand your requirements.
September 26, 2012 at 3:46 pm
scottichrosaviakosmos (9/26/2012)
I want to make a view from the query . will this CTE works for view.?
create view DidYouTryIt as
WITH CTE AS(
selectcalcid,
salesamount,
productid,
ROW_NUMBER() OVER( PARTITION BY productid ORDER BY calcid) rn
from...
September 26, 2012 at 2:43 pm
komal145 (9/26/2012)
Thank you .I filtered the title like isnumeric(title)=1
If that is what you used it is obvious you didn't read that article very clearly. If this is a one time...
September 26, 2012 at 2:38 pm
Nice job posting ddl and sample data!!!!
i have a table with 3 columns. i want to get the salesamount for previous calcid for a perticular productid.below is script for table...
September 26, 2012 at 1:56 pm
roh_ranjan (9/26/2012)
What i mean to say that user have maximum right to perform addition/deletion/substitution.Assuming I/you have all access and now request came to add/delete/substitute user...
September 26, 2012 at 1:13 pm
Viewing 15 posts - 10,561 through 10,575 (of 15,381 total)