Recently a friend of mine has shown me a question as under declare @t table(data varchar(50)) insert into @t select ' _ |_ |_ ' God knows from where he got this idea ! How can I find that it is CL How to do that in a set-based manner? Thanks a lot ...
Can somebody shed some lights on how SQL Server 2005 deals with may request issued by a client using ADO.NET 2.0. Below is the shortend output of SQL Trace. I can see that connection pooling is working (I believe there is only one connection being pooled). What is not clear to me is why we have so many sp_reset_connection calls i.e a ser...
Hi, This in continuation to the forum http://stackoverflow.com/questions/1998959/identifying-deleted-columns . Thanks to help i found in the forum i was able to identify that the columns are deleted. However i am still not able to find as to which columns are deleted. Can anybody help me figure this out. Thanks Jude ...
in my previous workplace we used oracle enterprise manager for viewing statistics and bottlenecks of queries that are running against oracle10g. In my new workplace we use Microsoft SQL Server (2005). Is there any tool like enterprise manager of oracle in SQL Server - I need to see all the jdbc SQL queries i make and how long they are ta...
Help says: By default, the maximum precision returns 38. Examples: SELECT @@MAX_PRECISION Of course it is. That should mean, you can somehow change it, right? But I can't find an option for it. Is there some hidden crypted registry key or something? The problem is that not all applications support precision > 24 and treat...
I'm working on a Delphi/WIN32 application that uses an SQL Server database as back-end, using ADO to access the data. There are many users who use this application, but one user is using a special setup: they have multiple database schema's and every schema contains the complete datamodel for the application. Every schema also has a data...
Hi all, I am currently working on a project where I want to search for employees via just one input search term. For this I am using the SQL FTS. The table schema looks like this Employee table EmployeeId, Firstname, Lastname Sample data 1, John, Miller 2, Chuck, Norris Address table AddressId, EmployeeId, CityId, Street, Str...
Hello, I have a table in the following format: smallint, binary(10), smallint, smallint, varbinary(max) I also have a csv file generated from the data in the table by one of our processes where binary data is exported as hexadecimal data. I tried generating INSERT INTO statements which worked but was very slow.. I tired BULK INSERT...
I'm curious which of the following below would be more efficient? I've always been a bit cautious about using IN because I believe SQL Server turns the result set into a big IF statement. For a large result set this could result in poor performance. For small results sets, I'm not sure either is preferable. For large result sets, wouldn'...
hi can anyone show me a sample connection string in asp page with sql server 2005 on vista? Or any solution to this problem: Dim cnn As ADODB.Connection throws an error http 500. I suppose ado is not correctly installed? Any ideas? ...
When you right-click on database, Reports...Disk Usage, I get a report. Because I have limited permissions, I only get the top portion, which shows "Transaction Log Space Usage" - that number alone could be useful to me. However, later I get error messages about not having permissions to run DBCC showfilestats, and I also definitely don...
Hiya, Long time reader, first time caller, and all that... Here's the business problem: a user makes one or more requests for documents. At some later time, a document is uploaded to the system. If that document matches one or more of the requests, the document request is fulfilled. So, there could be one or many requests for Document ...
If I have a table with a StartDate column and an EndDate column can I produce a query that returns a set including every day in the range. I could use a table variable and do some procedural code but I'd like to know if there's a way to do it in a query. E.g. StartDate = 1/1/2010, EndDate = 1/5/2010, result would be: 1/1/2010 1/2/201...
Using SQL Server 2005. This is something I've noticed while doing some performance analysis. I have a large table with about 100 million rows. I'm comparing the performance of different indexes on the table, to see what the most optimal is for my test scenario which is doing about 10,000 inserts on that table, among other things on othe...
What technical issues am I likely to encounter when migrating a database from SQL Server 2000 to SQL Server 2005? Are there any common problems I should be aware of? Should i be worried about any T-SQL changes that may break when stored procs are executed against the newer version of the database? What about DTS packages? Are there any...
Hello and good day, The title sums up my dilemma: "Configuring DBMail with SQL Server Management Studio Express" Anyone out in this august assemblage can help me out? Thanks in advance ...
I have a nvarchar(256) field in a SQL 2005 database table that contains several records in Chinese and I'd like to output this characters correctly in VB.NET code. What I have now doesn't work at all: Dim MyText As String = "推荐评论: 属于那～种类型的电影" Dim value As [String] = MyText Dim tc As Encoding = Encoding.GetEncoding(950) Dim bytes As Byt...
Here is my table and data of these tables Table name: Code CID Code 1 abc 2 def 3 xyz Table Name : Details ID Name CID 1 a 1 2 b 2 Resultant Table: ID Code Name 1 abc a 2 abc Null 3 def b 4 def Null 5 xyz Null 6 xyz Null I nned to ...
I have a table tblUser , there is userId,firstName,LastName,Mobile,.......,QuestionID. Another table it's name tblResults There is questionID,Question,choiceID,choice,......... EG: tblUser userID - FirstName- LstName -Mobile ... ... ... - QuestionID - ChiceID 001 - xx - yy - 03212 - ...
I have table data like this id id1 name 1 1 test1 1 1 test1 1 2 test2 2 1 test1 2 2 test2 3 1 test1 3 2 test2 3 2 test2 now from table i want the data as below like for id = 1 order by id1 asc the first name = test1 so i want the first two row id id1 name 1 1 test1 1 1 test1 not third r...