Search Results

Search found 36788 results on 1472 pages for 'sql 2008'.

Page 463/1472 | < Previous Page | 459 460 461 462 463 464 465 466 467 468 469 470  | Next Page >

• Import MySQL database into a MS SQL Server

  - by marionmaiden

  I have a .sql file from a MySQL dump containing tables definitions and the data to be inserted in this tables. How can I convert this database represented in the dump file into a MS SQL server database?

  Read the article

• load balance timeout SQL connection string

  - by george9170

  It seems that if there is a sql memory leak somewhere and you dont have time to find it you can use the load balance timeout option in a sql connection string to destory the connection after x seconds. Am i right in assuming I can set the load balance time out to 30-40 seconds and then hunt for the leak latter, while in the mean time the leak will not affect my application too much.

  Read the article

• save 20 users with one sql query?

  - by fayer

  i save a user like this in doctrine: $user = User(); $user->name = 'peter'; $user->save(); is there a way to save 20 users in one sql query? or do i have to loop the above code 20 times hence creating 20 sql queries? thanks

  Read the article

• SQL Math in Excel VBA

  - by Scott

  Excel seems to have a problem with doing math in SQL queries. SELECT ( SELECT sum(column) FROM table1 ) + ( SELECT sum(column) FROM table2 ) AS total This technique works completely fine in ASP and ASP.NET. Has anyone had success doing this in Excel VBA? (My database engine is SQL Server 2000.)

  Read the article

• What is the best way to estimate how much memory a row will require?

  - by Ryan Elkins

  I'm working on a project that will have a single table holding lots and lots of rows on either a SQL Server or SQL Azure installation. I'm trying to estimate how many rows I can store per GB. Is it a matter of simply adding up the memory size of the individual column data types? Is there other overhead to consider?

  Read the article

• MSSQL SQL Building Software

  - by TheGambler

  What are the option in terms of applications that help build SQL statements against a MSSQL database? We have some users that need to build sql statements, perferably through drag and dropping or linking up tables etc.., against a MSSQL databse who don't have any experience in this area. Any Ideas?

  Read the article

• What is better sql string or stored procedures?

  - by Sem Dendoncker

  Hello, I have a dataaccesslayer which uses Enterprice libraries. Now I was wondering what is better? Using stored procedures to create my sql or writing sql strings within the dataaccess classes? Cheers, M

  Read the article

• How do I Make Management Studio Express use proxy settings to connect to online SQL service

  - by TheAgent

  It doesn't seem like SQL Management Studio Express 2005 considers Internet Options proxy settings defined for the LAN when trying to connect to SQL Server 2005. Is there a way to make it use the proxy settings?

  Read the article

• Insert ADO.Net DataTable into an SQL table

  - by strakastroukas

  The current solution i implemented is awful! I use a for... loop for inserting records from an ADO.NET data-table into an SQL table. I would like to insert at once the data-table into the SQL table, without iterating... Is that possible, or am i asking too much?

  Read the article

• Resource database in SQL Server

  - by Dhivagar

  I need to know what the Resource Database in SQL Server is, and why can't we see this physical file in the SQL Server installed directory?

  Read the article

• Resource database in MS SQL Server

  - by Dhivagar

  I need to know what the Resource Database in SQL Server is, and why can't we see this physical file in the SQL Server installed directory?

  Read the article

• Selecting events from SQL Profiler in 2005 for profiling a query

  - by user279521

  Hi, I need to profile a large SQL query (in a particular database, not the whole server), and I cant figure out how to setup the profiler. I tried reading MSDN SQL web site, but it has not helped. I am stuck at the Trace Properties "Events Selection" window. I need help as to which items to select in "Events Selection" window. Thanks

  Read the article

• Excel VBA SQL Data

  - by user307655

  Hi All, I have a small excel program. I would like to be able to use this program to update a SQL table. What would be the function to say update line 2 in SQL table Test in Database ABC Thanks

  Read the article

• Good book for sql

  - by Uday

  I always considered database as a storage . but never thought it can be used for querying across tables etc. Which is a good book for sql for a developer. not just the syntax. How to write a query in different ways How internally queries are executed.etc especially related to microsoft sql server

  Read the article

• convert xml file to sql server 2005 table?

  - by subash

  how to convert a xml file in to sql server 2005 table?can any one help me? do we have any query to convert xml file to sql server 2005 table

  Read the article

• used stored procedure in linq to sql

  - by mazhar kaunain baig

  Do some out there use stored procedures with linq to sql and why? should we use them ? their support is there in linq to sql . I am asking because i use to use it before my recent application

  Read the article

• How to connect to sql server trough a pc(firewall)

  - by umetzu

  i have two pc's on my lan (one with "iis and a public ip) and another with(sql server and lan ip). How i can access to the sql server pc trough iis pc From a pc on the internet?

  Read the article

• nested sql statements

  - by Hadad

  Hello, I've a self join table when I delete or update it's id I want to delete or update all the direct and indirect affected records SQL server does not allow this type of cycle cascading I've decided to use triggers but this triggers will file recursively and they will be terminated at 34 level and I don't know the depth of records and event I disable the trigger and re enable it after completing the process how can I construct a SQL statement that achieve this logic?

  Read the article

• Tool for sql refactoring?

  - by C. Ross

  Is there a refactoring tool available for SQL (TSQL in particular). Is there any tool that can do automatic simplification of SQL? I have a set of views where only the top two are used, and I'd like to refactor this into only two views, hence 10+ queries into two queries.

  Read the article

• Is there any certification in simple SQL

  - by Mirage

  I want to do sql certification but specific like mysql , postgresql , mSsql . Is there any simple sql certification If not which one would be good to do for company level. which covers all topics I am thinking of going in data warehousing, if that helps.

  Read the article

• move data in bulk from oracle to SQL database

  - by Soja

  Hi All... Would like to know which is the best way to move data in bulk from oracle to SQL database programmatically in VB.NET application.This application is suppose to run continuously and moves data from Oracle to SQL whenever data comes. I have found OPENDATASOURCE but does not know the exact syntax. Can someone help me out. Thanks in advance,

  Read the article

• enable TCP in SQL server 2005 express edition

  - by david

  Hello, sorry for answer but how to enable TCP in SQL server 2005 express edition? I used configuration manager, find network configuration/protocols and there enabled TCP, after that I have restarted sql server service and tried installation of problematic software again (software which told me that TCP is not enabled) but I have the same problem :-(

  Read the article

• how to count NULL categories in one SQL question

  - by grzes

  hi, i have a blog application were Post belongsTo Category and Category hasMany Post Post can have a Category or not - in latter case NULL value is present in Post.category_id field. Now i would like to have following category count with single SQL query category|post_count -------------- PHP | 2 JavaScript | 4 SomeOtherCat | 1 NULL | 3 The clue here is that i also want to count posts without category (NULL row above). Is it posibble with one SQL query?

  Read the article

• SQL Server using SSH-tunnel from Visual Studio

  - by pbt

  Hi, I recently contacted a web host regarding support for external database access to a Microsoft SQL Server database included in a package they offer. They replied saying that it is only possible with an SSH-tunnel. Is it possible to connect to a SQL Server database in Visual Studio using an SSH-tunnel? It is important for me to be able to access the database from my local machine (for debugging, generating LINQ classes, editing tables, etc). Or, how should I go about working with their database?

  Read the article

• reading into table: comma values and quotes SQL

  - by every_answer_gets_a_point

  i have a string like this something = "something, something1, "something2, something else", something3" i need it to be read into a table like this: field1 = "something" field2= "something2" field3 = "something2, something else" field4 = "something3" please notice that the double quotes in the something string signified that the string inside the quotes is to be placed in one field anyone know how to do this with an insert into statement or some other way? the answer can be purely sql or can be vba with sql. thanks!

  Read the article

< Previous Page | 459 460 461 462 463 464 465 466 467 468 469 470  | Next Page >