Viewing 15 posts - 5,521 through 5,535 (of 7,429 total)
I am confussed by that statement, SQL does not care where an item appears in a table. Nor should a program if done properly. The only time order will be...
June 10, 2002 at 10:20 am
Please do not cross post. Duplicate thread please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4708&FORUM_ID=9&CAT_ID=1&Topic_Title=SQLServer++Newbie&Forum_Title=General
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 10, 2002 at 5:26 am
When you get to the point in your Import where you select the sheets to import to SQL "Select Source Tables and VIews" in the grid slide over to the...
June 10, 2002 at 5:24 am
Also many companies have invested too much money in purchasing their developers these tools. Many will also decide that VB.NET as well as the whole .NET framework need to age...
June 10, 2002 at 5:19 am
Check out this thread, another poster had a similar piece. http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4082&FORUM_ID=23&CAT_ID=2&Topic_Title=Parameter%20to%20the%20TOP%20operator&Forum_Title=General
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 9, 2002 at 6:15 pm
Look at SET ROWCOUNT which will offer the ability to do this in a SP much better.
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
June 9, 2002 at 1:32 pm
A table without a clustered index is in heap thus any data added is always added to the end and the data never fragments. A clustered index can potentially add...
June 9, 2002 at 12:22 pm
WHat mail client are you using? When you have this issue check your client to see if the mails show sent or still in the outbox.
"Don't roll your eyes at...
June 8, 2002 at 7:29 am
Take a look here and see if any help http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=msall&Query=BLOB%2520values%2520is%2520not%2520supported&Queryc=BLOB+values+is+not+supported&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 7, 2002 at 8:30 pm
Thanks Andy I for some dumb reason had my thought in reverse. Guess time to hit the bed. Sorry.
"Don't roll your eyes at me. I will tape them in place."...
June 7, 2002 at 8:26 pm
SO may so no, but they are. ISNULL can only check one item for a null value and return a none null value. With COALESCE you can check multiple columns...
June 7, 2002 at 8:22 pm
Sorry you cannot do this directly as table data type is not supported as of yet. However I haven't tried this but it may work the same or at least...
June 7, 2002 at 8:12 pm
I don't believe it hasn't changed. This code is great if nothing is being updated or inserted in the database. The big problem is this from BOL
June 7, 2002 at 8:08 pm
Also with an app role you won't be able to use profiler to see who is doing what or look in current activity. Even on a developement server you want...
June 7, 2002 at 7:58 pm
From what I remember and I don't believe this has changed that answer is no. Also as printed in SQL BOL
quote:
June 7, 2002 at 7:56 pm
Viewing 15 posts - 5,521 through 5,535 (of 7,429 total)