This is my query. And I want all rows of BF and matched rows of FT. It returns only 2 rows but the real row count is 135. How should I change my query? SELECT BF.FaturaNo, K.KlinikAdi, FT.teslimAlindi, FT.TeslimAciklama, FT.kurumTeslimAldi, FT.kurumTeslimAciklama, BF.basilmisFatura_id, K.klinik_id FROM BasilmisFatura...
I'm having trouble with stored procedure here and I'm not sure what to do or how to approach this. I'm sure there's a genius out here that can help me out! :D I want my stored procedure to return Anuncio's idAnuncio, titulo, precio, descripcion, and by using it's foreign keys return Categoria's descripcion and Imagenes's imagen. But ...
I can't pull up my tables so I can use them in my stored procedure. Any reason why they aren't showing? ...
Does vista supports sql 2008 ..... ...
I'm having an issue where this query statement is giving me repeating GoalText in the results. Any ideas? The complete query statement: Select g.GoalText, convert(nvarchar, g.GoalID) + '|' + convert(nvarchar, r.GoalReqID) as GoalID, GoalReqID from Goal g inner join GoalRequirement r on g.GoalID = r.GoalID where GoalReqID in (Select...
Create Proc CargarAnuncioPorBusqueda @searchString varchar(max) AS select * from Anuncio where titulo Like '%'+ @searchString + '%' Say the user writes: "pools", would this Stored Procedure return everything that has "pools" in the "titulo"? Thank you. :) ...
Create Proc CrearNuevoAnuncio @Titulo varchar(250), @Precio int, @Descripcion varchar(250), @IDCategoria int, @IDImagen int, @Login varchar(200) AS INSERT INTO Anuncio VALUES( @Titulo, @Precio, @Descripcion, @IDCategoria, @IDImagen, @Login ) The error is because the table anuncio ...
I have this: Create Proc CrearNuevoImagen @imagen image AS INSERT INTO Imagenes(imagen) VALUES( @imagen ) I see that @imagen is of type 'image'. My question is save that I have an .jpg image, on my front-end (my asp.net website code), how could I convert the .jpg image to fit into the 'image'-type column? Or does...
I am working on .aspx page that uses a t-sql query that uses a multivalued input parameter (a set of labnames) using an array that would store all the labnames prior to running the query. I have the following parameters for the query. With c.Parameters .Add(New SqlParameter("@sdate", sdate.text)) .Add(New SqlPar...
When I execute a sql statement like "Select ...", I can only see "...100%" completed... I want to log the number of rows affected. How can we do that? ...
I have a DataTable that I manually created and loaded with data using C#. What would be the most efficient way to create a table in SQL Server 2005 that uses the columns and data in the DataTable? ...
Does the length of the CommandText of an SqlCommand make a difference? I'm not talking about thousands of characters either. Here's what I have: SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; for (int i=0; i<1000; ++i) { string name = i.ToString() + "Bob" + i.ToString(); string email = i.ToSt...
I have an auditing/logging system that uses raw XML to represent actions taken out by an application. I'd like to improve on this system greatly by using an XML column in a table in the application's SQL Server database. Each row in the table would contain one log entry and each entry should contain one or more tags that are used to de...
What I'd like to be able to do via SQL somehow is with a table name as input determine all the fields that make up the primary key. sp_columns doesn't seem to have this field. Any ideas as to where to look? EDIT: This is SQL Server 2005 Statement on Answer: While others may have been right his was the cleanest and easiest to implemen...
I guess everything is possible but I am wondering how easy is it for someone to hijack a connection string with a network packet analyzer or equivalent tool. A winforms application fetches data directly from an MSSQL server. (Supposing there are no webservices in the middle for extra protection) 1) Is it possible for someone with an a...
I have two MS SQL 2005 servers, one for production and one for test and both have a Recovery Model of Full. I restore a backup of the production database to the test server and then have users make changes. I want to be able to: Roll back all the changes made to the test SQL server Apply all the transactions that have occurred on the ...
Dear friends, I have single big table in Ms access 2k daabase and i need a way to copy this table and then populate my two already ready tables on sql server . I can use Migration tool but is there any way we can do it from Ms access like a form which executes the stored procedure or ODBC connection. what i am thinking is to create a ...
Executing the following statement with SQL Server 2005 (My tests are through SSMS) results in success upon first execution and failure upon subsequent executions. IF OBJECT_ID('tempdb..#test') IS NULL CREATE TABLE #test ( GoodColumn INT ) IF 1 = 0 SELECT BadColumn FROM #test What this means is that something is co...
Hi, I'm using SQL Express 2005 for an asp.net application which only uses Membership management.I've known that this edition has 4GB limit,but even it has I wish to know how much space I'm using in. Is limit possible to be checked from either SQL Express Management Studio or by code (c#)? (i.e 2.34 GB is in use) ...
I have a SSAS 2005 database with 10 cubes. When I create the cubes from an XMLA script, it works fast, and I can browse cubes from SSMS, just as I should. After processing the cubes during the night, eveyrthing starts to work VERY slow. Opening cube list in SSMS takes few minutes, and it is like this all the time. What can cause this? ...