Programming SQL
in [Microsoft SQL Server]
|
How to specify ranges with batches while updating a column? (Shriram Chandrasekaran) writes: Thanks for ur suggesstion. i am having 2 million records in my database.while i try to update a column for all the records,it takes very very long time. How to specify ranges with batches while updating a column? SELECT @first = MIN(somecol) FROM tbl WHILE @first I... 17 Feb 2010 03:25
Search and Replace in a column I can't remember how I did this before and not having much success with my syntax. I just want to do a simple search and replace of all dashes in a field with a blank. Table = Vendor Column = PhoneNumber Basically: replace(PhoneNumber,'-','') I just want to strip the - (dash) from the field. What's ... 16 Feb 2010 22:55
Question about MS newsgroups posting Hi, Is posting to the MS newsgroups the same as posting to the MSDN and TechNet forums? Or are they completely separate? I don't want to cross-post duplicate messages. Thanks. Alan -- _____________________________ Alan Z. Scharf Grapevine Systems New York City ... 16 Feb 2010 22:55
transaction log backup / truncate / shrink Is there a general consensus on what the best practice is for setting up a job to keep the log file as small as it can be? thanks in advance, bob. ... 15 Feb 2010 16:39
Version Control of Database Anybody have any suggestions for products to do version control of database objects? TIA - Jeff. ... 15 Feb 2010 15:30
Using SqlBytes/SqlChar write method in CLR apologies for repeated post. i am using ddl to deploy clR function kj wrote: Using SqlBytes/SqlChar write method in CLR 14-Feb-10 Thanks for your reply I guess i am not using VS auto deploy. I deploy my assembly using create/alter assembly. My function looks like this SqlChars^ func1(SqlBytes Data... 15 Feb 2010 13:14
need a sql FUNCTION to show subscript with integer Hi All I have a requirement in which I need to get numeric data, and return it in the form of string but with subscript. Eg: 1 -> 1st 2 -> 2nd 3 -> 3rd 4 -> 4th 21 -> 21st 25 -> 25th Do we have such in-built function in MS SQL? Please revert asap. ... 16 Feb 2010 02:58
Technical Question Hi all I have a main server with some agents which each agent acts like a server. in each agent SqlServer is installed. How can I integrate all agents's data into main server. I know a solution is to merge them. Is there a better way to merge them ?? thanks in advance ... 16 Feb 2010 02:58
MS SQL Reporting Services Request.QueryString Problem Hi Guys, I am currently trying to complete a dynamic report in MS Reporting Services for MS CRM4.0. The problem at hand is that it seems almost impossible to case a QueryString value from MS CRM to the report within the IFrame that the report exists in. Here is the code I am currently using to get the Request.Qu... 15 Feb 2010 03:16
Using SqlBytes/SqlChar write method in CLR Thanks for your reply I guess i am not using VS auto deploy. I deploy my assembly using create/alter assembly. My function looks like this SqlChars^ func1(SqlBytes Data, SqlString a, SqlString b) { SqlChars ^output = gcnew SqlChars(); .. .. .. while ((bytesRead = Data.Read(offsetr,tmpInBuffer,... 14 Feb 2010 22:57 |