SQL Server is a relational database management system from Microsoft. Use this tag for all SQL Server editions including Compact, Express, Azure, FastTrack and PDW.
0
votes
0answers
23 views
what is wrong with this code? i am trying to
I am trying to get "CTDESC " value in combobox named " cmbCTDesc". And sqlConnection is already created. In which event do i add this code-SelectedIndexChanged or button ?
DataSet ds = ...
1
vote
0answers
8 views
app.config and Entity Framework for remote connection
I have a connection string to a local database which works ok.
<connectionStrings>
<add name="Entities"
connectionString="metadata=res://*/RNADataModel.csdl|
...
0
votes
0answers
9 views
User defined data types in sql azure
I have created user defined data types in my project now I am going to deploy my project on AZURE.
I have defined user defined data types in my sql server 2008 database. As much I read out User ...
azure
2
votes
1answer
12 views
SQL query performance and dropcleanbuffers
There is a "best practice" that you have to run
DBCC FREESESSIONCACHE
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
Before doing performance analysis on a SQL query.
Yet, for example, the later one ...
0
votes
2answers
17 views
SQL Aggregate function: Sum of some rows in another row
I have following scenario with sql server 2008
**** Original Result ****
================================================
Year month Category Count_days
...
0
votes
0answers
3 views
OData Date Filtering from JS
I am using the DXTREME framework from Devexpress to connect a HTML mobile app to an OData source.
One of my tables in SQL Server, exposed through the OData service is a table with a date (not ...
0
votes
0answers
3 views
Passing NULL value into parameterized delphi SQL server query
I am trying to pass in a null value to a TSQLDataset parameter. The query has the form:
Query_text:='MERGE INTO [Table]
USING (VALUES (:A,:B)) AS Source (Source_A, Source_B)
...
1
vote
3answers
31 views
Adding different values in a single cell
Imagine we have a table as:
AAA BBB 123
AAA BBB 456
AAA BBB 789
How can i see these three in a single row as:
AAA BBB 123-456-789 (multiple cells are added to a single cell using a delimiter)
...
0
votes
3answers
33 views
Display datetime with php
I have a column with the datatype datetime in sql server and i would like to echo the date only with php.
Currently I'm using this function to output everything:
<?php
include 'DB_Connect.php';
...
0
votes
0answers
20 views
datagrid checkbox writes Null instead of 0 (false) into database
I have a Table in my sql-database that has the following fields: Name(string), Quartal1(bit), Quartal2(bit), Quartal3(bit), Quartal4(bit).
I bound that Table to a datagrid (winform in visual studio). ...
0
votes
1answer
14 views
How to retrieve a certain column content after execution a stored procedure?
In my stored procedure I need to insert a record in a particulat table using corresponded stored procedure.
This procedure returns as a result a hell of fields, but what I need from the stored ...
0
votes
0answers
4 views
How to deploy SQLServer CE for VSPackage?
I like to deploy SQLServer CE privately on my VSPackage application.
I already tried the following information:
Using Entity Framework with an SQL Compact Private Installation
as well as this one:
...
-1
votes
2answers
37 views
Split one long comma string into multi column new table
I am newish to SQL to please excuse any ignorance. I have a table, called 'temp' that contains one Field with one long comma seperated string, thus:
Field1
Apples,oranges, pears, berries, melons
I ...
0
votes
0answers
6 views
Which one is better for search sql server full text or luscene.net
I had implemented Sql Server full text search in past on a website and now we are redesigning the application, I got to know about luscene.net and heard that it is really very good by some of my ...
-1
votes
0answers
17 views
Python Ubuntu SQL Server return value
I am trying to connect it to the sql server using python in ubuntu. Googling through many sites, I was able to alteast connect to the database and execute the stored procedure with no parameters which ...
