Search Results

Search found 847 results on 34 pages for 'sqlserver'.

Page 8/34 | < Previous Page | 4 5 6 7 8 9 10 11 12 13 14 15  | Next Page >

• How to use Common Table Expression and check no duplication in sqlserver

  - by vodkhang

  I have a table references to itself. User table: id, username, managerid and managerid links back to id Now, I want to get all the managers including direct manager, manager of direct manager, so on and so forth... The problem is that I do not want to have a unstop recursive sql. So, I want to check if an id alreay in a list, I will not include it…

  Read the article

• SQLServer:Namespaces preventing access to query data

  - by Brian

  Hi A beginners question, hopefully easily answered. I've got an xml file I want to load into SQLServer 2008 and extract the useful informaiton. I'm starting simple and just trying to extract the name (\gpx\name). The code I have is: DECLARE @x xml; SELECT @x = xCol.BulkColumn FROM OPENROWSET (BULK 'C:\Data\EM.gpx', SINGLE_BLOB) AS xCol; --…

  Read the article

• Encrypt column names of tables in SQL SERVER EXPRESS

  - by Josh

  Hello, What is the best way to encrypt columns in SQLSERVER 2005 EXPRESS edition so that no one can steal our database design? Thanks

  Read the article

• Do you know SqlServer ? Do you want an iPad ?

  - by Dave Ballantyne

  If you’ve answered yes to both of those questions , Jacob Sebastian has some more question for you. Every day in March there is a different question set by a SqlServer community notable member. At the end of the month the answers will be judged, scored and tallied.  The person with the most points will be the proud owner of a shiny new…

  Read the article

• Failed to resolve include text for file:SQLServer.ttinclude

  - by bigred

  I updated to the version 3.0.0.3. Dragged the new ActiveRecord directory in VS08, and added the newer dll. I'm not sure whats going on yet. When I try to compile the project I get that error. My SVN server just lost my old version, so I'll have to download the older Subsonic version and see if that fixes the problem. I have no clue what…

  Read the article

• SQL Server Account will work for SQLSERVER but fails to ReportServer

  - by Larry

  Setting up SSRS. For Service Account, 1. I set a domain account as the Report Server Service Account. 2. click apply 3. SQL Server Connection Dialog pops up. Need to specify an account with admin privileges. i. set Credentials Type = SQL Server Account ii. I use sa account (which works, verified many ways with sql server management…

  Read the article

• Change SQL SERVER EXPRESS 2008 TCP port with Microsoft.SqlServer.Management.Smo

  - by Norman

  I need to change the default port(1433) of SQL EXPRESS 2008 instance in c#.

  Read the article

• Multiple rows with a single INSERT in SQLServer 2008

  - by Todd

  I am testing the speed of inserting multiple rows with a single INSERT statement. For example: INSERT INTO [MyTable] VALUES (5, 'dog'), (6, 'cat'), (3, 'fish) This is very fast until I pass 50 rows on a single statement, then the speed drops significantly. Inserting 10000 rows with batches of 50 take 0.9 seconds. Inserting 10000 rows…

  Read the article

• sqlserver 2008 and sql CE over Microsoft sync framework

  - by malik

  The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection.…

  Read the article

• SqlServer / MySql Connection pool: is it really important ?

  - by stighy

  Hy guys, after a lot of problem with my hoster, i decided to disable connection pooling of my application. The problem was related to the number of concurrent connections : only five. So i decided to disable connection pooling: the result is that my web app don't crash. So i'm asking you: are there some "collateral" effect…

  Read the article

• Problem with SqlServer 2005 when opening connections

  - by Jose Obregon

  I have a Winforms application and I use EntLib to connect to a SQL Server 2005 DB. The application is working ok, but sometimes, and lately more often, we have started receiving this error from the db when opening the connection: A connection was successfully established with the server, but then an error occurred during…

  Read the article

• SqlServer Split operation

  - by Geetha

  Hi All, How to split a string in sql server. Ex: Input String: stack over flow Result: stack over flow Geetha.

  Read the article

• Inserting an image into sqlserver gives an "operand type clash"

  - by Termedi

  I'm trying to save an image in a sql server 2000 database. The data type of the column is image. Here is the code: Image Upload: <?php include('config.php'); if(is_uploaded_file($_FILES['userfile']['tmp_name'])) { $fileName = $_FILES['userfile']['name']; $tmpName =…

  Read the article

• SQLServer 2008 Pivot

  - by Mitch

  I need to show some information in a graph, the data is held in a SQL Server 2008 table. The graph is expecting 2 columns, one for QuestionNumber and the other for Score. The table containing the data has column names that correspond to the question numbers ie A1, A2, A3, A4, B1, B2, B3, B4, C1, C2.…

  Read the article

• why shrink a sqlserver 2005 database?

  - by digiguru

  What are the advantages and disadvantages of shrinking a database? Are there any performance implications?

  Read the article

• VBA Excel To SqlServer

  - by adrianm

  What is the best way to write VBA code to connect to SQL Server 2005 from Excel? The users of the excel file might run XP, Vista, Win7 and I want to prevent driver installation as much as possible. My understanding is that XP uses MDAC while Vista/Win7 uses DAC. Does that mean that a reference to…

  Read the article

• Round .net DateTime milliseconds, so it can fit the sqlserver milliseconds

  - by stacker

  I want to convert the datetime value to the value that I will get from sql server 2008. Sql server truncate the milliseconds to 3 digits, so I truncate the milliseconds already. But the problem is that as you can see here:…

  Read the article

• SQLServer triggers

  - by Evl-ntnt

  Please help me to write trigger that, adds new rows in table I have 3 tables in my database. 1) Regions (id, name); id - primary 2) Technics (id, name); id - primary 3) Availability (id, region, technic, count); id -…

  Read the article

• Entity Framework How to specify paramter type in generated SQL (SQLServer 2005) Nvarchar vs Varchar

  - by Gratzy

  In entity framework I have an Entity 'Client' that was generated from a database. There is a property called 'Account' it is defined in the storage model as: <Property Name="Account" Type="char" Nullable="false"…

  Read the article

• Image insert problem php sqlserver

  - by Termedi

  Hi I can not save image inside a sql server 2000 database. datatype is image here is the code: // Image Upload <?php include('config.php'); if(is_uploaded_file($_FILES['userfile']['tmp_name'])) { …

  Read the article

• SQLserver multithreaded locking with TABLOCKX

  - by WilfriedVS

  I have a table "tbluser" with 2 fields: userid = integer (autoincrement) user = nvarchar(100) I have a multithreaded/multi server application that uses this table. I want to accomplish the following: Guarantee…

  Read the article

• writing an Dynamic query in sqlserver

  - by prince23

  hi, DECLARE @sqlCommand varchar(1000) DECLARE @columnList varchar(75) DECLARE @city varchar(75) DECLARE @region varchar(75) SET @columnList = 'first_name, last_name, city' SET @city = '''London''' SET @region =…

  Read the article

• Where can I get the Microsoft.SqlServer.Mso.dll & Microsoft.SqlServer.ConnectionInfo?

  - by naspinski

  I can't seem to find these anywhere, I want to do some SMO stuff. I am using VS 2010 Ultimate and SQL Express 2008; thank you.

  Read the article

• Drawbacks of Dynamic Query in Sqlserver 2005 ?

  - by KuldipMCA

  I have using the many dynamic Query in my database for the procedures because my filter is not fix so i have taken @filter as parameter and pass in the procedure. Declare @query as varchar(8000) Declare @Filter…

  Read the article

• Import Excel to sqlserver 2005 using Sqlbulkupload

  - by Jayesh

  Hi all, I want to upload excel file using SqlBulkCopy into sql server 2005 table. My excel file size is 43MB. When i am uploading this file it will display error message that "The request filtering module is…

  Read the article

< Previous Page | 4 5 6 7 8 9 10 11 12 13 14 15  | Next Page >