I've got a SQL2008 database with 2008R2 Express loaded.
In VS2012 if I right click a table and select New Query, I get the Visual Designer.
In VS2013, same database, I get a blank page
I've tried a fresh install of 2012 and 2013 onto a fresh Win8.1, same thing. SQL2012 Express, same. If I use an LocalDB option, again no tools. I've tried Ultimate to see if it's something not in Pro.
Also the "code only" query doesn't connect me to the file properly, so even if I accept doing the query by hand, I have to paste a connection string every time.
I'm expecting it to do as per VS2012, and the VS2013 pages in [URL] My database is an attached file from an ASP.NET project App_Data folder.
I'm building a custom Data Processing Extension (DPE), and I was hoping test it inside Visual Studio report designer, instead of doing it on the server side in Reporting Services.
Note that I have gotten the RS configuration working.
I'm using Microsoft Visual Studio 2005 to design reports. Is there any way to use one single image as background for a whole report-page? I only managed to set seperate background images for page header, body and footer, so the only 2 possibilities to solve this problem would be to either
* divide the image into 3 parts so that they fit exactly to the page parts or * not use any page header and footer.
Is there another possibility that I've missed?
Any help is highly appreciated! Thanks in advance,
Using SQL Server Management Studio Express 2005 for the first time and have a question. After creating a query using the Design Query, can the same query be visually modified using the Design Query again?
Seems whenever the Design Query is used again with an open query, the tool opens empty ready for a new query instead of the open query.
I have SSRS in Visual Studio. I created a query that works fine in SQL Server Management Studio, but when pasted into Visual Studio I get the error "An expression of non-boolean type specified in a context where a condition is expected, near '('.
Here is the query. Can anyone help on why this isn't working? Thanks.
SELECT CASE WHEN MONTH(dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate) = MONTH(GETDATE()) AND YEAR(dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate) = YEAR(GETDATE()) THEN dbo.MAS_CCS_ARO_InvHistoryDetail.SOExtChargeAmount ELSE 0 END AS CurrentMonth, CASE WHEN SubString(dbo.MAS_CCS_GL_Account.Account,1,3) = '400' THEN 'ALEDO' ELSE ' ' END AS Location, dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate, dbo.MAS_CCS_ARN_InvHistoryHeader.InvoiceNumber, dbo.MAS_CCS_AR1_CustomerMaster.CustomerName, dbo.MAS_CCS_ARO_InvHistoryDetail.DetailSeqNumber, dbo.MAS_CCS_ARO_InvHistoryDetail.LineType, dbo.MAS_CCS_GL_Account.Account, dbo.MAS_CCS_ARO_InvHistoryDetail.SOExtChargeAmount FROM dbo.MAS_CCS_AR1_CustomerMaster, dbo.MAS_CCS_ARN_InvHistoryHeader, dbo.MAS_CCS_ARO_InvHistoryDetail, dbo.MAS_CCS_GL_Account WHERE dbo.MAS_CCS_AR1_CustomerMaster.CustomerNumber = dbo.MAS_CCS_ARN_InvHistoryHeader.CustomerNumber AND dbo.MAS_CCS_ARN_InvHistoryHeader.InvoiceNumber = dbo.MAS_CCS_ARO_InvHistoryDetail.InvoiceNumber AND dbo.MAS_CCS_ARO_InvHistoryDetail.SOGLSalesAcct = dbo.MAS_CCS_GL_Account.AccountKey
I am used to run SQL server 2005 RDBMS with Visual studio 205 for development. recently, i wanted to try it with the inbuilt sql server express and being able to run the membership query / membership functionality. the proble is that i couldn't run the query using 'aspnet_regsql' from command prompt. It always throw error. please, can anybody help me out. Any suggestion will be highly appreciated and welcome. Kayode Banjo
Good day. I was able to connect to a database server using SQL ServerEnterprise Manager. The Server name specified on the tree isJOMARGON(Windows NT). But no server was detected using either VisualStudio .NET and SQL Server's query analyzer.I highlighted one database (master) on the SQL Server EnterpriseManager and chose 'SQL Query Analyzer' under the 'Tools' menu. Itworked. The Title of the Query Analyzer window isSQL Server Analyzer - [Query- JOMARGON.master.JOMARGONJM Gonzalezand below on the status bar, I can seeJOMARGON(8.0) and JOMARGONJM Gonzalez(52)But again, I cannot connect manually using Query Analyzer as nothing islisted in the SQL Server drop-down listThanks
I am trying to send a variable selected by the user and have all of the results that match that selection show in a datagridview. I tried using this query but it gives me not result. //code SELECT wasteDate, wasteFeed, wasteLbs FROM tbWaste WHERE (wasteDate = 'date1') //code date1 is being set by a datetimepicker I am getting no results when I run the program I have tried out every different combination of ways of coding it i can think of if anyone can help it would be greatly appriciated.
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason
I recently installed the Evaluation Edition of SQL Server 2005 x64 and it appears that MS Visual Studio 2005 is installed in stead of SQL Server Business Intelligence Development Studio. When I choose new project the only template available is "Blank Solution". How do I get all the templates (i.e. Analysis Server Project, Integration Services Project, Report Model Project, Report Server Wizard project, etc.)?
Or would it be better to uninstall MS Visual Studio 2005 and attempt to reinstall BIDS?
I am new to visual studio and I am still not sure of all its components and features.
I installed visual studio 2005 standard edition but cannot find SQL Server Management Studio?
I guess this must be because it is not included with Visual studio 2005 standard. Is it included with VS 2005 professional?
I want to add pictures of products to my shopping site using an SQL database and I’ve been told that SQL Server Management studio is required as it is a graphical tool.
How would I go about obtaining the SQL server management studio. There seems to be different versions of SQL server that it is confusing to know which one to purchase.
Will the SQL server 2005 version that comes with Visual studio standard be sufficient for me now right? I want to create a shopping site with hundreds, perhaps even thousands of products. I want to use an SQL server 2005 database. The database will include ‘dynamically generated’ product images if that is the correct terminology.
My goodness, it seems I still have so much to learn.
I have created a database under management studio and i want it to be connected in visual studio but it failed the error msgs said that the database can't be connected coz the database with same name exits but that is not true
Hi all!On a server computer, I have SQL server 2005 express edition installed, and am using that for my web server, but I want to develop the applications in Visual Web Developer on a remote machine on my LAN. This means I will have to connect VWD to the remote SQL server, to work with the databases.How do you connect VWD to a Remote SQL server?Thanks!
How do i get the database that i am using in visual studio into my SQL server management studio? i need to create some scripts to create stored procedures on a live server.
I wrote a function and a SQL to get the 3 columns Date,Total Orders & Amount, for dates between Date Started and Date Completed if I pass different Dates in the SQL I get the correct result but if I pass same dates then I don't get the result I am looking for .
For Instance,if I give Date From=1/02/2008 ;Date To=1/8/2008(Different dates )I am getting values for all the three columns. But I give same dates for Date From=01/02/2008 ;Date To=01/02/2008 then I am not getting the records.
Some how I could not trace what could be the error in my SQL Function.
I appreciate if I could get some work around for this.
Thanks!
create function dbo.CreateDateList(@start datetime, @end datetime) returns @t table ( [date] datetime ) as begin if @start is null or @end is null return
if @start > @end return
set @start = convert(datetime, convert(varchar(10), @start, 120), 120) set @end = convert(datetime, convert(varchar(10), @end, 120), 120)
while @start < @end begin insert into @t ( [date] ) values (@start) set @start = dateadd(day, 1, @start) end
return end
**********SELECT qUERY***********
SELECT Convert(Varchar(15), l.[date],101)as Date,COUNT(o.OrderID ) AS TotalOrders,ISNULL(Round(SUM(o.SubTotal),2),0) AS Amount , 1 as OrderByCol FROM dbo.CreateDateList(@DateFrom , @DateTo) l LEFT OUTER JOIN orders o ON o.Datecompleted >=Convert(Datetime, l.[date],101) and o.Datecompleted < dateadd(day,1,convert(Datetime, l.[date],101)) WHERE StoreID=@StoreID GROUP BY Convert(Varchar(15), l.[date],101) Union SELECT 'Grand Total' as Total,NULL AS TotalOrders, ISNULL(Round(SUM(o.SubTotal),2),0) AS Amount, 2 as OrderByCol FROM dbo.CreateDateList(@DateFrom , @DateTo) l LEFT OUTER JOIN orders o ON o.Datecompleted >=Convert(Datetime, l.[date],101) and o.Datecompleted < dateadd(day,1,convert(Datetime, l.[date],101)) WHERE StoreID=@StoreID Order by Date
I wrote a function and a SQL to get the 3 columns Date,Total Orders & Amount, for dates between Date Started and Date Completed if I pass different Dates in the SQL I get the correct result but if I pass same dates then I don't get the result I am looking for .For Instance,if I give Date From=1/02/2008 ;Date To=1/8/2008(Different dates )I am getting values for all the three columns.But I give same dates for Date From=01/02/2008 ;Date To=01/02/2008 then I am not getting the records.Some how I could not trace what could be the error in my SQL /Function.I appreciate if I could get some work around for this.Thanks! Function:create function dbo.CreateDateList(@start datetime, @end datetime)returns @t table ( [date] datetime )asbegin if @start is null or @end is null return if @start > @end return set @start = convert(datetime, convert(varchar(10), @start, 120), 120) set @end = convert(datetime, convert(varchar(10), @end, 120), 120) while @start < @end begin insert into @t ( [date] ) values (@start) set @start = dateadd(day, 1, @start) end returnend ---------SELECT qUERY---------- SELECT Convert(Varchar(15), l.[date],101)as Date,COUNT(o.OrderID ) AS TotalOrders,ISNULL(Round(SUM(o.SubTotal),2),0) AS Amount , 1 as OrderByCol FROM dbo.CreateDateList(@DateFrom , @DateTo) l LEFT OUTER JOIN orders o ON o.Datecompleted >=Convert(Datetime, l.[date],101) and o.Datecompleted < dateadd(day,1,convert(Datetime, l.[date],101)) WHERE StoreID=@StoreID GROUP BY Convert(Varchar(15), l.[date],101) Union SELECT 'Grand Total' as Total,NULL AS TotalOrders, ISNULL(Round(SUM(o.SubTotal),2),0) AS Amount, 2 as OrderByCol FROM dbo.CreateDateList(@DateFrom , @DateTo) l LEFT OUTER JOIN orders o ON o.Datecompleted >=Convert(Datetime, l.[date],101) and o.Datecompleted < dateadd(day,1,convert(Datetime, l.[date],101)) WHERE StoreID=@StoreID Order by Date
Hi all can you help me, I know that I am doing some thing wrong. What I need to do is set a variable to the current date so I can use it in a SQL query to an access database. This is what I have so far <script runat="server""> Sub Page_Load dim --all the variables for my sql connections-- dim ff1 As Date then my sql connection and queries sql="SELECT FullRate, " & ff1 &" FROM table1 WHERE hotelnumber = " & hotel This works is I set ff1 as a string and specify the string (my column headings are set as dates in my table) dim ff1 As string ff1="30/01/2006" but I need ff1 to be the current date and is I use ff1 As date it returns time and date Is there any way to set ff1 to the current date in this format "dd/mm/yyyy"
I have created two tables and receive a "columns in table ... do not match an existing primary key or UNIQUE constraint." error message.
Table1: GOSMapping
PK: AuthInd (bigint)
PK: GLCode (nchar(8))
-both columns were set as PK simultaneously
Table2: GOSTracking
PK: AdjID
FK: AuthInd (bigint)
FK: GLCode (nchar(8))
I open Table2 in the designer and right click, then select Relationships. I choose both of the columns that are the PK in Table1, and set the exact fields as the FK in Table2. I get the message when trying to save this relationship. All data types are congruent, and the primary key has been set as the combination of the two PK columns in Table1. Any ideas?
I'm very confused. I installed Visual Studio 2005 and thought I understood that SQL Server 2005 came with it, but it appears that it's SQL Server 2005 - Express. Can anyone tell me what I need to do in order to get Data Transformation Services loaded or the equivalent of DTS in SQL Express?
I have a workflow and when the request is completed in the email body I have included the completed date field - when the email is sent the date and time show and time is always 12 am. I really don't want the time - In sharepoint list I have in the field specifically said Date only - What or how can this be changed in SP Designer workflow email embedded code for Completed Date field. Completed Date: 5/30/2008 12:00:00 AM
within the mail body I can't make any changes in the embedded code.....
When I try to create a database that will have fields for a date and a time the only data type option in visual studio is datetime. This stores data as dd/mm/yyyy-00.00.
how can I set it to store either a date dd/mm/yyy or a time 00.00 but not both.
Hi all, Have tried running a dts package but Im unable to add the reference Microsoft.Sql.managedDts. Is there any other way that i can do tat from Visual studio code behind page? I need to let the user to trigger the package from the web application. Thks in advance.
