sqlsrv_query() for a linux system?
- by Derek Adair
This question is related to a previous post.
Is there something comparable to sqlsrv_query() on a linux server?
Or something extremely simple to parameterize queries for a LAMP(php)/SQL server?
Search Results
Search found 27497 results on 1100 pages for 'sql joke'.
Page 511/1100 | < Previous Page | 507 508 509 510 511 512 513 514 515 516 517 518 | Next Page >
-
-
How to force username and password entry in C# / VS web app?
- by salvationishere
I am trying to force user to enter username and password when they run my C#/SQL web application. This was developed in VS 2008 on a 32-bit XP. The current connection string I'm using in my web.config file is: But it still doesn't prompt for a username and password. What am I missing?Read the article
-
Please tell me difference between running query directly and executing it using exec
- by Rajesh Rolen- DotNet Developer
Please tell me what is difference == if i write query directly in storedprocedure == and write query in string variable and than run it in exec in stored procedure. i am using ms sql server 2005Read the article
-
Calculating Average Percentage Yield (APY) with T-SQL
- by M. Travis Volker
How do you calculate Average Percentage Yield (APY) with T-SQL? Is there a system function to calculate APY or do I have to create one? Note: APY = (1 + r/n )^n – 1 where r is the stated annual interest rate and n is the number of times you’ll compound per year.Read the article
-
SQL is declarative, what about LINQ
- by pokrate
I can change SQL at runtime. Can I do the same with LINQ ? Can I have LINQ queries coming from an xml file, which I can edit at runtime ?Read the article
-
dynamiclly schedule a lead sales agent
- by Josh
I have a website that I'm trying to migrate from classic asp to asp.net. It had a lead schedule, where each sales agent would be featured for the current day, or part of the day.The next day a new agent would be scheduled. It was driven off a database table that had a row for each day in it. So to figure out if a sales agent would show on a day, it…Read the article
-
Domain Model + LINQ to SQL sample
- by lmsasu
Hello all, I wonder if there is an enterprise application sample, designed with Domain Model in the Business Logic layer and LINQ for the Data Mapper? I'm not so sure of how to use the UnitOfWork ability of LINQ to SQL in conjunction with business objects from the Business Layer. Thanks, LucianRead the article
-
Get Max() record from table by group
- by Garcia Julien
Hi, i've got a table like that : Article Number Last Voucher Number Last Voucher Date 0557934 519048 04/02/2005 0557934 519067 04/02/2005 0557934 528630 09/29/2005 0557934 528631 09/29/2005 0557934 529374 10/13/2005 0557934…Read the article
-
Expression Too Complex In Access 2007
- by Jazzepi
When I try to run this query in Access through the ODBC interface into a MySQL database I get an "Expression too complex in query expression" error. The essential thing I'm trying to do is translate abbreviated names of languages into their full body English counterparts. I was curious if there was some way to "trick" access into thinking the…Read the article
-
ALTER TABLE error
- by Travis
Can someone explain to me why I am receiving the following error? I want to rename the column "exerciseID" to "ID" in a mysql table using the following syntax. ALTER TABLE `exercises` CHANGE `exerciseID` `ID` INT( 11 ) NOT NULL AUTO_INCREMENT However I receive the following error: MySQL said: #1025 - Error on rename of…Read the article
-
Running a simple VBA script to test a connection
- by brohjoe
I'm trying to test the connection of a GoDaddy SQL Server database. I'm getting an 'invalid connection string attribute.' What's wrong with this script? Dim cnn As ADODB.Connection Dim canConnect As Boolean Public Sub TestConnection() Set cnn = New ADODB.Connection cnn.Open "Provider=sqloledb;Data…Read the article
-
PL/SQL profiler missing data
- by user289429
We are using pl/sql profiler to collect metrics. We noticed that on one of the environment the plsql_profiler_runs table is populated with the total execution time but the finer details that gets collected in the table plsql_profiler_data is missing. Any idea why this would be happening? We do use…Read the article
-
Removing Database References from an ASP.NET MVC Site
- by Maxim Z.
I'm building a very simple ASP.NET MVC site that doesn't require a database and doesn't have user accounts or any other special ASP.NET stuff. When I first created the site with the ASP.NET MVC 1.0 site template in Visual Studio, the web.config page was configured to automatically connect to SQL…Read the article
-
Visual Studio Setup Project Installer Prerequisite for SQL Server CE
- by blu
I have a Setup Project in my solution in Visual Studio 2008 SP1. The application installs fine but it is not loading my prerequisite of SQL Server CE. I have the following configurations set: Do I need to do anything else, like with a Custom Action or anything like that? Thanks.Read the article
-
CLR SQL Assembly: Get the Bytestream?!
- by OMG Ponies
I have a SQL CLR dll I want to deploy, but have found you can embed the byte stream/varbinary_literal/ varbinary_expression/assembly bits into a text file to get around the messy hassle of packaging a DLL and making sure it's accessible for the CREATE ASSEMBLY command. But what I have yet to…Read the article
-
ASP.NET MVC Stored Procedure
- by Pinu
I am using a ms sql stored procedure to get a set of records , when i am adding this stored procedure to my LinqToSql class and using it my repository it shows like it is returning a int value but it should be returning a set of rows. Is there some thing wrong with my stored procedure or…Read the article
-
Sql script, create a database
- by Blanca
Hi! I have the next file: create_mysql.sql DROP DATABASE IF EXISTS playence_media; CREATE DATABASE playence_media; USE playence_media; GRANT ALL PRIVILEGES ON . TO 'media'@'localhost' IDENTIFIED BY 'media' WITH GRANT OPTION; But I don't know how to create this database.…Read the article
-
Refresh tables in Visual Studio?
- by Curtis White
How can I refresh the tab in Visual Studio for a database table? Currently I re-open the table but I would think there is a way to refresh the table. I am referring to tables opened via the Server Explorer/SQL Express. The clear results does not seem to refresh.Read the article
-
Reset AutoNumber(Identity Field) in DataBase
- by hosseinsinohe
Hi All I Use a Sql Server Compact DataBase File For Store the Data in My Windows Application Software.In this DataBase I have A Table With Identity Field.When I Insert A Record To the Table, identity Code increment Automatically.But When I Delete All Records From Table,And Insert Records …Read the article
-
Connecting to MS sql through hibernate
- by Rima
Hello All, I want to connect to MS SQl server 2005 using hibernate in java. i am unable to find the jars and the hibernate.cfg.xml file for the same. can someone help me with the same Thanks in Advance Regards, RimaRead the article
-
Conditional SQLite check constraint?
- by Rezzie
I have a table defined by the following SQL: CREATE TABLE test ( id integer PRIMARY KEY NOT NULL UNIQUE, status text NOT NULL, enddate date, /* Checks */ CHECK (status IN ("Current", "Complete")) ); I'd like to add a constraint that requires enddate to be non-null if…Read the article
-
why restoring database never finishes?
- by LingAi
Hi all, I have really wired problems here. I am using MS 2008 sql server at the moment. After I did a tail-log backup, the target database is automatically restoring and keeping on restoring. Does anyone know what's the problem? Thanks, LingRead the article
-
text search with two parameters
- by stck777
The user should input two strings and the script will performe a text search: $sql = "SELECT * FROM table_one WHERE name='%$str1%' AND MATCH (street, city, pin) AGAINST ('$hrtg'IN BOOLEAN MODE)"; somehow the % does not work, but it alwas did actually. please help?Read the article
-
How to create a class in dbml file dynamically
- by Naseem
Hi, I'm using linq to sql and I need to have a class in the dbml file which some of its properties are creating dynamically . Is there any way to have a class in dbml file with some pre defined properties and some dynamic properties . Or is there any way to create a class in dbml file…Read the article
-
Free DBMS with encryption support and without size limitations
- by Sphynx
I really need a free database which supports encryption, but doesn't have size limitations like 4 GB in SQL Server Express. Suggestions welcome!Read the article
