Is PDO for SQL Server support query contain Link Server ? I try using mssql_connect but it didn't work. I have try PDO but it alwas return error on query() method.
Hi,
I'm trying to do some work with my SQL table.
I have 2 buildings with room numbers 1 - 100 in building 1 and 101 - 199 in building 2.
I have a location field (which I've just created) and want to run a query to populate it with either 'Building 1' or 'Building 2' depending on which room number it has in the 'Room' field.
Many thanks for your help.
Regards
Scott
Situation:
Running a report on SQL Server Reporting Services
When I do a Preview of the Report all my charts look fine. No problems.
When I run a subscription for the report, the chart look different. Like completely different legends are gone etc.
Any ideas what the cause would be?
BTW the charts are Dundas Charts.
Hi all,
I have an sql query here and it returns a number of results. I'd like to show these results in groups.
What I mean is,
show the first 20 results in some part of the page,
show the next 20 results in another part of the page
etc...
How can I do that?
I'm doing a little digging and looking for a explanation on how SQL server evaluates MIN(Varchar).
I found this remark in BOL: MIN finds the lowest value in the collating sequence defined in the underlying database
So if I have a table that has one row with the following values:
Data
AA
AB
AC
Doing a SELECT MIN(DATA) would return back AA. I just want to understand the why behind this and understand the BOL a little better.
Thanks!
Hi, im trying to connect to a remote sql express server using win. authentication.
I´m logued with a user with username Administrator, but when loggin, i got the next error:
Login failed for user guest ...
Why is not using the Administrator account?
Thanks in advance.
I want to batch insert multiple records in sql server database using ADO.NET command/sqldataadapter and get identity value generated for all the rows in a single database trip.
What are my options?
I have been playing around with creation of pdf documents for a project that I'm working on. I would like to store the generated pdf document in a SQL database and then later be able to retrieve this pdf as well.
What are some suggestions for doing this? Can the document be stored in the database without physically creating the document on the server?
In my code I am using java.sql.PreparedStatement.
I then execute the setString() method to populate the wildcards of the prepared statement.
Is there a way for me to retrieve (and print out) the final query before the executeQuery() method is called and the query is executed? I Just want this for debugging purposes.
Thanks.
is it possible to retrieve by using connection.getschema() the description item from a sql server table column, just like it's possible to retrieve the column name, data type, is nullable, column default value, etc?
I have a SQL Server 2008 database with 300 tables. The application I have to design is an Windows Forms app, .NET 3.5, C#.
Which is the best way to work with LINQ2SQL ?
I intend to make a datacontext for each business entity.
Is there any problem ?
I need to know if this way of working with LINQ has any disadvantage or can create performance issues ?
Thanks.
I am looking for a publicly available SQL database with free access, where one can run some SELECT queries for free on some meaningful data (not item1, item2, item3). Have you seen any? Even better if it came together with some tutorial.
Vendor is not that relevant, as long as one can connect using a generic JDBC client.
My database has to store all the available departments in my company.
Some departments are sub-departments on another existing department. I've decided to solve this like this:
Departments
ID Description HeadOfDepartment ParentDepartment
ParentDepartment can be null, indicating it is a root department. If it has a parent I'll act accordingly, my question is how can I code this in Microsoft SQL?
Hi,
Is there any place where I can find all possible object dependencies in Sql Server?
What I mean by "object dependency" is a list of object that one object can depend on. For example, TABLE can depend on SCHEMA, TYPE, TABLE, FUNCTION, etc.
For Data Explorer I would like to add support for a Batch separator.
So for example if users type in:
select 'GO' go select 1 as go
Go
select 100
I would like to return the three result sets.
Its clear that I need some sort of parser here, my hope is that this is a solved problem and I can just plug it in. (writing a full T-SQL parser is not something I would like to do)
What component / demo code could achieve splitting this batch into its 3 parts?
Is there a tool around that would produce a diagram showing existing tables and their relationships given a connection to a database or by any other means?
This is for SQL Server 2008 Express Edition.
Im using Native SQL from ABAP language. The query to get data is something like this
SELECT COUNT(ROWID)
FROM <SCHEMANAME>.<TABLENAME>;@<DATABASENAME>
INTO :localvariable
I want to somehow set the schemaname and database name as default so that i do not need to use them in the SELECTs later. Then i can only use the table name in the SELECT.
thanks !!
Hi
I currently loook after 20 odd databases in SQL server 2005 and need a tool for monitoring the performance and keep me informed if a database is running slow. Is there anything I can run within Managment studio of any other good third party tool (Pref free) that can do the job.
Thanks
I have Table and i want to copy data from row to another and vice versa and i have the rows IDs.
is there any query to do that because i don't want make it by .net code i think sql query is easier than that.
thanks
I've stuck with syncing a Sql server 2008 having changes tracking enabled with a 2005 one that doesn't have this mechanism.
Would you please point me a right track, how can I handle this.
Thank you,
I have an sql statement that returns this result below,and I want that the num will drag the latest(by date) num that is not null. I can't get it right.
I want to add somthing like this:
case
when num is null then max(num where date<my_date)
my result now:
Date num
1.1 0
2.1 1
3.1 NULL
4.1 NULL
5.1 4
what I want:
Date num
1.1 0
2.1 1
3.1 1
4.1 1
5.1 4
I have to sanitize a part of sql query. I can do something like this:
class << ActiveRecord::Base
public :sanitize_sql
end
str = ActiveRecord::Base.sanitize_sql(["AND column1 = ?", "two's"], '')
But it is not safe because I expose protected method. What is a better way to do it?
I have the following Transact SQL query using a union.
I need some pointers as to how this would look in LINQ i.e some examples
wouldbe nice or if anyone can recommend a good tutorial on UNIONS in linq.
select top 10 Barcode, sum(ItemDiscountUnion.AmountTaken) from
(SELECT d.Barcode,SUM(AmountTaken) AmountTaken
FROM [Aggregation].[dbo].[DiscountPromotion] d
GROUP BY d.Barcode
UNION ALL
SELECT i.Barcode,SUM(AmountTaken) AmountTaken
FROM [Aggregation].[dbo].ItemSaleTransaction i
group by i.Barcode) ItemDiscountUnion
group by Barcode
Just doing an assignment for my database course and I just want to double check that I've correctly wrapped my head around relational algebra.
The SQL query:
SELECT dato, SUM(pris*antall) AS total
FROM produkt, ordre
WHERE ordre.varenr = produkt.varenr
GROUP BY dato
HAVING total >= 10000
The relational algebra:
stotal >= 10000(
?R(dato, total)(
sordre.varenr = produkt.varenr(
datoISUM(pris*antall(produkt x ordre))))
Is this the correct way of doing it?