For questions specific to the 2005 version of Microsoft's SQL Server.
3
votes
0answers
185 views
Quickest method for matching nested XML data against database table structure
I have an application which creates datarequests which can be quite complex. These need to be stored in the database as tables. An outline of a datarequest (as XML) would be...
<datarequest>
...
2
votes
0answers
438 views
Pass parameters to temp variables in MS Query on SQL Server from Excel
I have created a parameter query using microsoft query as mentioned here
http://superuser.com/questions/197453/run-an-sql-query-with-a-parameter-from-excel-2007
But when I want to pass parameters to ...
2
votes
0answers
185 views
Create a faster regular expression clr function
I am trying to improve the Clr function in the link http://msdn.microsoft.com/en-us/magazine/cc163473.aspx .
public static partial class UserDefinedFunctions
{
public static readonly ...
2
votes
0answers
198 views
Read multiple xlsx files in a folder and enter a foreach loop in SSIS
I am new to SSIS and would like to know how to read multiple XLSX format files from a folder and enter them in a foreach loop so that they can insert into the database.
I was reviewing this examples:
...
2
votes
0answers
160 views
SQL Server 2005 Query for getting multiple records which have same pattern in QC project database
We access the SQL Server 2005 server from the QC Application.
In order to access the data present in the SQL Server 2005 server we use the Dash Board Module in Quality Center Application.
Sorry I ...
2
votes
0answers
376 views
SqlDbType.Date SQL Server 2005
I have a property like this:
private SqlParameter DateOfBirthSqlParameter
{
get
{
return new SqlParameter("@date", SqlDbType.Date)
{
Value = ...
2
votes
0answers
171 views
Running an exe with in a CLR method for Sql Server 2005
I wrote a CLR method for sql server 2005 and trying to run an exe through it.
Here is the code:
[Microsoft.SqlServer.Server.SqlFunction]
public static SqlString Function1()
{
...
2
votes
0answers
91 views
SMSS Formatting of characters
In SSMS 2005, If I inset the following character (‑) it changes the font of adjacent letters and I'm unsure why. It doesn't seem to have any adverse effect as it selects the data I want (which are ...
2
votes
0answers
3k views
Cannot load JDBC driver class 'net.sourceforge.jtds.jdbc.Driver'
I have some problems with jtds.
I'm using Hibernate, Tomcat 5.5 on Linux Red Hat Server, SQL Server 2005 with WIndows Server
I save the library into Web-iNF/lib and i'm using the version jtds-1.2.2
...
2
votes
0answers
239 views
Access control and user information in main db
We have one database to carry out our operations. The application is fetching the records from Oracle database and MSSQL is processing those records, tally them with biometric machine data and then ...
2
votes
0answers
204 views
Find first parent that satisfies condition sql server
So I'm faced with a bit of a difficult problem, at least for me.
Imagine I'm working with not-so-fictional hierarchy data that contains branches, regions, etc. I've got some code that consumes data ...
2
votes
0answers
107 views
Query Notification doesn't work for multiple tables
I have the following setup:
A WCF service which uses the query notification to monitor
changes on "Table1" say WCFService1
Another WCF service which uses the query
notification to monitor changes on ...
2
votes
0answers
267 views
Jdbc Ms SQL Driver 3.0 callable statement using default parameters
What is the best way to reuse a CallableStatement
I want to use the same msp_updateOption in different ways and make it reusable code.
Also the CallableStatement should take input as parameter type ...
2
votes
0answers
607 views
SSIS XML Source, no output although using inline xsd schema
I have an xml file with some data and inline schema attached to it.
If i use it in SSIS (2008 or 2005) xml source component, I get no output to any destination (tried, raw file, flat file, excel, ole ...
2
votes
0answers
218 views
JDBC SQL Server Out of Memory Exception
I am writing a small utility that index's a SQL Server 2005 table data to LUCENE data store. i am using a JDBC SQL Server driver for connectivity. The result set returned from the server has around 2 ...
