I need some tough and best questionaire to write sql queries in sql server/oracle.
This is for practice.
Is there any site or book available for this?
Thanks in advance.
I have nearly 50 pairs of tables. Each table has nearly 20 columns. I would like to find out the number of rows that are common in each pair of tables. I also would like to findout the count o...
I have a proc on SQLServer2000SP3, that excepts a large XML text, and parses the text parameter using 6 OpenXML() between a single sp_xml_preparedocument and sp_xml_removedocument.
eg:
...
How to create table to store datetime in the format dd/mm/yyyy
I thought I read this some where but is it possible to routinely export data from SQL Server into a text file (ASCII) in a binary format? I have the pleasure of creating an interface to deliev...
i am getting this error Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ':'.
Server: Msg 259, Level 16, State 2, Line 4
Ad hoc updates to system catalogs are not e...
I am working on a report that pulls data from a stored procedure. The application prompts the user for parameters and then passes them into the stored procedure so the result set can be tailo...
Currently facing a very strange problem. What ever i do to the database or the record, the sql server always timeout at a particular point. if i change the content of the particular record, th...
I am using MS SQL Server 7.0 and MS VB 6.0 (SP6).
I have in SQL Table1 the following values in Field1:
ABC
ABc
AbC
abc
aBc
abC
When I execute the following statement in my VB 6.0...
What is the iif equivalent in MS SQL. How to use it ?
error 1827: create/alter database failed because the resulting cumulative database size would exceed your licensed limit of 2048 MB per database.
I'm trying to copy a database to my local m...
Hi
I am trying to extract some data fom oracle server to the MS SQL server and in between i am converting few fileds to str,Text using Data conversion accordingly but It throws me Errors :
...
I have a column in the data source for my report that will be containing multiple items. In the cell that displays them, I would like each to be on a new line. I've tried (in the data source...
I have installed SQL Server 2005 on our brand new Windows Server 2003 R2 Standard Edition server using all the default settings. I have WSUS installed and ISA 2004 which both use the SQL Serve...
I would like to write a query accessing two tables using ADO in VB6. The syntax for fully qualified tables names is [server].[databasename].[owner].[table name].
When the server name is SQL...
Hi, I need to convert Julian dates to datetime. For example, 105031 is the 31st day of the 5th year of the 21st century, or 1/31/2005, or 98129 is the 129th day of the 98th year of the 20th c...
Hi All,
We're getting the following error whenever we run our billing system:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv())
or sometimes:
[Microsoft][ODBC SQ...
Hi,
We run a SQL Server 2005 server with Reporting Services enabled, both running on the same machine; Windows Server 2003 Standard R2 x64. We keep running into the "unable to load client p...
I am using SQL Server Management Studio Express 2005 and I am trying to create a database from a backup file. I have done it before in here, but this time I am getting the attached error. I ...
Hi,
Im having a big problem with yet another simple task :)
Trying to get MS SQL to convert its datetime type to a UNIX timestamp
How can this be done? I know in MySQL there is the UNIX_TI...
The last line of the code snippet causes and error. How would I go about assigning the return value of the execute statement to a variable.
I need to check the value through a conditional st...
I have a string (51739) - what I need to do is to insert a '-' after the first char/int - so:
51739
becomes
5-1739
I have a SQL 2000 server and a database that I want to drop.
A drop command returns "Cannot drop the database 'MyDB' becuase it is currently in use.
I tracked down the process stopping t...
Hello,
In our SQL Server database we have money values that are negative. But I need to convert all negative values to positive values. I am using the following code in Query Analyzer:
...
Ok i am trying to build a rather large dynamic stored procedure. The jist of this procedure is to create a history table and tag each line with a particular value so that if it needs to be upd...
