Search Results

Search found 28930 results on 1158 pages for 'sql ce'.

Page 70/1158 | < Previous Page | 66 67 68 69 70 71 72 73 74 75 76 77  | Next Page >

• Adding a SQL Server Membership Provider using the aspnet_regsql.exe Utility

  - by nannette

  You may add a SQL Server Membership Provider using the aspnet_regsql.exe Utility on either your SQL Server Express local database or on a full-blown SQL Server database . In both implementations, you would use the aspnet_regsql.exe utility. This tool is installed when you install your .NET Framework. To use this on your SQL Server 2008 database…

  Read the article

• SQL SERVER Generate Database Script for SQL Azure

  When talking about SQL Azure the common complain I hear is that the script generated from stand-along SQL Server database is not compatible with SQL Azure. This was true for some time for sure but not any more. If you have SQL Server 2008 R2 installed you can follow the guideline below to generate script [...]...Did you know that DotNetSlackers…

  Read the article

• On Handling Dates in SQL

  The calendar is inherently complex by the very nature of the astronomy that underlies the year, and the conflicting historical conventions. The handling of dates in TSQL is even more complex because, when SQL Server was Sybase, it was forced by the lack of prevailing standards in SQL to create its own ways of processing and formatting dates…

  Read the article

• Window Functions in SQL Server

  When SQL Server introduced Window Functions in SQL Server 2005, it was done in a rather tentative way, with only a handful of functions being introduced. This was frustrating, as they remove the last excuse for cursor-based operations by providing aggregations over a partition of the result set, and imposing an ordered sequence over a…

  Read the article

• SQL Server 2008 table variable error: Must declare the scalar variable "@RESULT".

  - by Trindaz

  I'm using table values for the first time as a parameter to a function in SQL Server 2008. The code below produces this error: Must declare the scalar variable "@RESULT". Why?! I'm declaring it on the first line of the function! ALTER FUNCTION f_Get_Total_Amount_Due( @CUSTOMER_LIST [tpCSFM_CUSTOMER_SET_FOR_MONEY]…

  Read the article

• Does the sort order of an index matter in SQL Server?

  - by Mr. Flibble

  When creating an index in SQL Server you can set the sort order to either ascending or descending. What effect does this have to your queries? When would it make sense to use descending?

  Read the article

• What is the Auto-Close option when creating a new database in SQL Server 2008?

  - by brian

  What is the Auto-Close option when creating a new database in SQL Server 2008? EDIT: and how do you decide whether to turn it on or off?

  Read the article

• How to organize infinite while loop in SQL Server ?

  - by alpav

  I want to use infinite WHILE loop in SQL Server 2005 and use BREAK keyword to exit from it on certain condition. while true does not work, so I have to use while 1=1. Is there a better way to organize infinite loop ? I know that I can use goto, but while 1=1 begin .. end looks better structurally.

  Read the article

• SQL - SSMS2005 - How do I copy a database diagram to another database?

  - by hamlin11

  Is there a simple method for copying a database diagram from one database server to another? I have a diagram on a development server that needs to be moved to the production server. Thanks (Sql server 2005, SSMS2005 Express)

  Read the article

• SQL query that returns columns form table A plus a bit column that specifies with the PK of table A

  - by dannie.f

  How can I write an efficient SQL query that returns columns form table A plus a bit column that specifies whether the PK of table A exists in table B? I am using MS SQLServer 2005. Thanks.

  Read the article

• How to get Master and Slave Table data in one row using SQL Server ?

  - by Space Cracker

  I have main table called 'Employee' and another slave table called 'EmployeeTypes' that has a FK from 'Employee'. Each row in 'Employee' can have zero or many rows in 'EmployeeTypes' and I want to make an SQL Query that returns data of all Employees and each employee row should contain its related data in 'EmployeeTypes' (for…

  Read the article

• How many maximum recursion possible for CTE in SQL server?

  - by Paresh

  How many maximum recursion level possible for CTE in SQL server? If maximum recursion level is reached then what are the alternative way?

  Read the article

• What kind of encryption mechanisms does MS SQL Server 2008 Standard offer?

  - by Przemyslaw Rózycki

  As I see, TDE and EKM mechanisms are available only in Enterprise edition. How can I encrypt data in tables in Standard edition of SQL Server 2008?

  Read the article

• Why do updates inside of a SQL transaction still need disk IO?

  - by usr

  In SQL Profiler you can see that very simple updates to a table by primary key take about 10-30ms each. On about every 10th update the write column shows 1, on all other updates it shows 0. This must mean that about every 10th update statement still requires disk IO. I wonder why that is. Would it not be more efficient queue…

  Read the article

• How to get size of file uploaded to SQL-Server?

  - by MadBoy

  Is there a way to tell how to get a file size that is uploaded to database? SELECT [ID] ,[File] FROM [dbo].[Reports] I would like to be able to tell user the size of File which is VarBinary(max) field in MS SQL 2005/2008. How to do that? Maybe the only way to do is to create another column and when inserting…

  Read the article

• Anyone know a program to automatically dump a bunch of test (dummy) data into a sql database?

  - by naspinski

  I am running SQL Server 2005 and I want to dump some dummy data into a large table with about 50 columns (I did not design it :P) - anyone know a tool to do this automatically? I want the rows to have all sorts of different data, and I would rather not write a script if there is already a tool out there - thanks.

  Read the article

• sql - ModifyDate column - Is using a Computed Column a correct way to implement this?

  - by hamlin11

  I just want to have a "ModifyDate" column automatically populated for me when a record is either inserted or updated. Should I be using triggers or is it OK to use a Computed Column? (Using SSMS2005 and SQL Server 2005 Express)

  Read the article

• BizTalk and SQL: Alternatives to the SQL receive adapter. Using Msmq to receive SQL data

  - by Leonid Ganeline

  If we have to get data from the SQL database, the standard way is to use a receive port with SQL adapter. SQL receive adapter is a solicit-response adapter. It periodically polls the SQL database with queries. That’s only way it can work. Sometimes it is undesirable. With new WCF-SQL adapter we can use the lightweight…

  Read the article

• Slow Update/insert into SQL Server CE using LinqToDatasets

  - by Vaccano

  I have a mobile app that is using LinqToDatasets to update/insert into a SQL Server CE 3.5 File. My Code looks like this: // All the MyClass Updates MyTableAdapter myTableAdapter = new MyTableAdapter(); foreach (MyClassToInsert myClass in updates.MyClassChanges) { // Update the row if it is already there …

  Read the article

• install SSMSE 2008 after VS 2010

  - by snehalpatkar

  hi guys i have installed VS 2010 ultimate on windows 7 machine which by default install sql server 2008. now i want to install SSMSE 2008 i download the following file SQLEXPRWT_x86_ENU and tried to install it but it give me error. [Window Title] Program Compatibility Assistant [Main Instruction] This program…

  Read the article

• J2ME VS Android VS iPhone VS Symbian VS Windows CE

  - by Sadi

  I have very little idea about mobile platform, though I am interested to program for mobile platform. Would you please compare between J2ME VS Android VS iPhone VS Symbian VS Windows CE. I would like to know which one is better, and if there is any VM technology to test the programs. Which one should I choose and…

  Read the article

• Unable to set enviornment variable in platform builder win CE 6.0

  - by mukesh

  Actually while building the win ce project getting the two errors -: Error 1 BUILD: [00:0000000015:ERRORE] C:\WINCE600\PLATFORM\ICOP_Vortex86_60CS\SRC\OAL\OALLIB\obj\x86\debug_objects.mac: create file failed. 2 Error 3 BLDDEMO: There were errors building mytest I think it's comes, due to unset of environmnet…

  Read the article

• Debugging dynamic sql + dynamic tables in MS SQL Server 2008.

  - by Hamish Grubijan

  Hi, I have a messy stored procedure which uses dynamic sql. I can debug it in runtime by adding print @sql; where @sql; is the string containing the dynamic SQL, right before I call execute (@sql);. Now, the multi-page stored procedure also creates dynamic tables and uses them in a query. I want to print those…

  Read the article

• Connecting Named SQL Server Express 2005 from MySQL Migration Toolkit 1.1.10

  - by KoolKabin

  Hi guys, I am trying to migrate SQL Server Express 2005 database to mysql. I came across the mysql migration toolkit. When i started with the tool it asked for my sql server express information. I provided all the information of the sql express but it still can't connect. My machine has got 1.) SQL Server 2000…

  Read the article

• Enumerating all open file handles and/or registry handles in Windows Mobile / Windows CE 5.x

  - by jdstroy

  Hi all, Is there a way to enumerate all open file handles and/or registry handles in Windows Mobile 5 / Windows CE 5.x? In particular, I'd like to get the handles for all processes in the system, and not just the ones for my application. This would be similar to the list of handles in Sysinternals's Process…

  Read the article

< Previous Page | 66 67 68 69 70 71 72 73 74 75 76 77  | Next Page >