Search Results

Search found 27337 results on 1094 pages for 't sql'.

Page 381/1094 | < Previous Page | 377 378 379 380 381 382 383 384 385 386 387 388  | Next Page >

• Never Bet Against the Impossible

  - by BuckWoody

  My uncle used to say “If a man tells you that his car squirts milk in his eye when you lift the hood, don’t bet against that. You’ll end up with milk in your eye.” My friend Allen White tells me this is taken from a play (and was said about playing cards), but I think the sentiment holds, even in database work. I mentioned the other day that you…

  Read the article

• SQL Server 2012 Express LocalDB &ndash; How to get started

  - by krislankford

  As many of you aware, SQL Server can be a bit of a pig when it comes to system resources on your development machine. As part of the 2012 products Microsoft has added SQL Server 2012 Express LocalDB which is a happy medium for myself when thinking about having to install a full blown SQL Server on my box. This however does not work in all cases…

  Read the article

• Extend linq-to-sql partial class to avoid writing a property?

  - by Curtis White

  I have a linq-to-sql class. I have a property "Password" for which I want to call the underlying ASP.NET Membership provider. Thus, I do not want this property written out directly but via my own code. I basically want to create a facade/proxy for this property such that I may use the underlying membership provider or a custom stored procedure.…

  Read the article

• Is it possible to install SQL Server 2000 on my PC?

  - by Bragaadeesh

  Hi, I am pretty much new to using SQL Server. I have been using only open source databases till this time. I want to know is there any developer version of SQL Server available. Its for learning purposes only. Is it available free or do I need to pay for it? Thanks

  Read the article

• SQL How to correctly set a date variable value and use it?

  - by flavour404

  Hi, I have the following query which uses a date variable, which is generated inside the stored procedure: DECLARE @sp_Date DATETIME SET @sp_Date = DateAdd(m, -6, GETDATE()) SELECT DISTINCT pat.PublicationID FROM PubAdvTransData AS pat INNER JOIN PubAdvertiser AS pa ON pat.AdvTransID = pa.AdvTransID WHERE (pat.LastAdDate >…

  Read the article

• Is there an implementation of Tom Kyte's STRAGG function supporting SQL Server?

  - by s_rajasekar

  STRAGG function implemention returns a result as a single column value. Implementation for Oracle seems pretty generic and can be consumed for different tables (and relationships). Could similar behavior be achieved for SQL Server. A search in the web, appears to return only hard coded implementations and not a generic one. Do we have any known…

  Read the article

• After writing SQL statements in MySQL, how to measure the speed / performance of them?

  - by Jian Lin

  I saw something from an "execution plan" article: 10 rows fetched in 0.0003s (0.7344s) How come there are 2 durations shown? What if I don't have large data set yet. For example, if I have only 20, 50, or even just 100 records, I can't really measure how faster 2 different SQL statements compare in term of speed in real life situation? …

  Read the article

• How to insert a DataTable with existing Key to a SQL Server Table.

  - by user296575

  I am working with VB.NET.. i have a DataTable called "QUESTION", containing 3 fields: QuestionNumber (unique integer key) QuestionText QuestionType In my SQL Server database I created a Table called "QUESTION" with the same fields. QuestionNumber is defined as integer unique key, auto increment Now, when i make a bulk copy to insert the…

  Read the article

• How can i use my SQL based database software from a remote area with the help of internet.

  - by W. Hasan

  How can i use my SQL based database software from a remote area with the help of internet. I m using a Sql based database software in my head office to maintain our material flow, like receiving, issue and some other things. Our site office is also doing the same thing. So, is it possible to give our site office access to my Software…

  Read the article

• Is there a style check tool for T-SQL, just like FxCop to .net?

  - by Ken Yao

  I'm looking for a tool to enforce coding styles, validation check for T-SQL script. And it recommends best-practice when appliable. In .net code domain, the tool for this purpose is FxCop. Is there a counterpart for T-SQL? It will be best it is free or open source tool. Anyone can shed some light?

  Read the article

• Using a Linq-To-SQL class automagically generates the connection string for me; is there a way to ma

  - by Sergio Tapia

  I'm just beginning to use Linq-to-SQL and it's just wonderful to use. The problem is, this software is going to be run on a lot of machines and each machine will have a unique connection string. Is there a way for me to manually set the connection the Linq-to-SQL (.dbml) uses? The way I'm doing things now is creating the .dbml file, and…

  Read the article

• If I can ping my DB server, is my SQL Server connection guaranteed to work?

  - by Matt

  If I can ping my DB server, is my SQL Server connection guaranteed to work? I am using a default connection string in my code. My program runs fine locally but overseas sites are having issues and I am wondering if SQL might be using a TCP or UDP port that is still blocked. Here is the connection string "Data Source=xxxx.xxxx.com;…

  Read the article

• Does PL/SQL have an equivalent StringTokenizer to Java's?

  - by dacracot

  I use java.util.StringTokenizer for simple parsing of delimited strings in java. I have a need for the same type of mechanism in pl/sql. I could write it, but if it already exists, I would prefer to use that. Anyone know of a pl/sql implementation? Some useful alternative?

  Read the article

• Can somebody explain the running total and SQL self-join in this tutorial to me?

  - by Philip Brocoum

  I was reading over the tutorial here: http://www.1keydata.com/sql/sql-running-totals.html and it all made sense until it suddenly got extremely ridiculously unbelievably complicated when it got to rank, median, running totals, etc. Can somebody explain in plain English how that query results in a running total? Thanks!

  Read the article

• Need to remotely create an ODBC connection to a SQl server.

  - by kris

  I have an Access 2007 database with a table in it that is linked to a SQL server. I need to roll this version of the database out to approximately 10 people in different states. In order to do that, they need an ODBC connection to the SQL server installed on their machines. I am looking for a way to do this remotely. Either through…

  Read the article

• Are there any good .Net libraries for building arbitrary sql commands? Not relational data.

  - by Burg

  I am looking for some library that takes the TextWriter approach to writing SQL commands (much like there is the HtmlTextWriter in .Net for writing html). I am NOT writing CRUD-type commands for relational data, I am writing arbitrary SQL (bulk inserts, table creation, creating backups, etc). Any suggestions are appreciated.

  Read the article

• Subsonic: How to exclude a table column so that its not included in the generated SQL query

  - by Fleents

  I need to insert a record to a table. Subsonic builds the query something like this (as far as i know): INSERT INTO Table1 (Title, Description, RowVersion) VALUES (@Title, @Description, @RowVersion) But i want to remove the RowVersion column from the SQL query bacause its autogenerated by the sql server. How can i do that?

  Read the article

• Under what circumstances would a LINQ-to-SQL Entity "lose" a changed field?

  - by John Rudy

  I'm going nuts over what should be a very simple situation. In an ASP.NET MVC 2 app (not that I think this matters), I have an edit action which takes a very small entity and makes a few changes. The key portion (outside of error handling/security) looks like this: Todo t = Repository.GetTodoByID(todoID); UpdateModel(t);…

  Read the article

• can i put password for sql database like (test.mdf) to secure it if no what is he best way to secu

  - by KHALID

  i devoleped windows application with c# and i use local sql database i want to secure it from admins - can i put password for sql database like (test.mdf) to secure it if no what is he best way to secure my database (in other words) can i keep my database not authenticated with windows and only be seen for auser i…

  Read the article

• How to run SQL that contains bind variables in the ODT Query Window?

  - by dnorthut

  How do you run SQL that contains one or more bind variables in the Oracle Developer Tools for Visual Studio Query Window? For example, the following works fine in SQL*Plus: variable x NUMBER; BEGIN :x := 0; END; / SELECT 1 FROM DUAL WHERE :x <> 1; When executed in the ODT Query Window, the following…

  Read the article

• Why doesn't SQL DISTINCT work with ORDER BY CAST?

  - by Tommy

  Including DISTINCT to an SQL query that also uses ORDER BY CAST(thecolumn AS int) as shown here seems to remove that sorting functionality. Any reason these cant work together? (Using sqlite with the C api) Thanks. EDIT: Started with - sprintf(sql, "SELECT DISTINCT rowX FROM TableX Order By Cast(rowX As…

  Read the article

• Are there any modeling tools that can visually generate jpa or sql queries?

  - by Shervin

  Does anyone know of a tool like PowerArchitect or SquirrelSQL or maybe eclipse plugin that lets you also generate jpa/sql queries? Imagine you choosing your database, or your entity beans, and the modeling would reverse engineer your database/entity model, so that you could visually just choose the columns…

  Read the article

• Can you set SQL Server permissions from a Silverlight app?

  - by Paul Smith

  Is it possible to create a Silverlight application which can be used to provide a nice user interface for managing SQL Server permissions? We want to create a simple admin app to allow certain users to create new users, disable old users, and manage specific permissions for those users, but we feel that…

  Read the article

• Where can I find the list of all SQL-standard-mandated aggregate functions? [on hold]

  - by einpoklum

  I know that different DBMSes support different aggregate functions; for example: MySQL's aggregates Oracle's aggregates I want to get the list of aggregates mandated by the SQL standard. Or, to be more precise, the lists of mandatory aggregates for SQL 1992, 1998, 2003, 2008 and 2011 - with 2011…

  Read the article

• Does SQL Server 2008 compress the results sent back to my web server?

  - by Jeff Meatball Yang

  I have a typical reporting application: Large report <-- HTTP Compression --> ASP.NET Web Server <-- ??? --> SQL Server 2008 Since I have so much (repetitive) data to send to the client, I would like both network hops to have compression. Is there a transport-level compression setting…

  Read the article

< Previous Page | 377 378 379 380 381 382 383 384 385 386 387 388  | Next Page >