.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: April 10, 2011    Points: 0   Category :


I am using VS2005, with WinCE 6 R3.

Trying to build a ntive application that will wuse the "Microsoft SQL Server Compact 2005" that comes with the VS2005.

I have included the SQL component in the catalog items.

WHen I am trying to compile my application I am getting an error, Not able to locate transact.h. This file is included from sssceoledb.h

Has anyone faced a similiar problem, please suggest where can I get(path) the transact.h file for the compiler ...



View Complete Post

More Related Resource Links

Transact-SQL Built-In Stored Procedures

To assist you with managing Microsoft SQL Server databases, Transact-SQL provides many built-in stored procedures.

Renaming an Object

Sending Email


Defines the attributes of a Transact-SQL server cursor, such as its scrolling behavior and the query used to build the result set on which the cursor operates. DECLARE CURSOR accepts both a syntax based on the ISO standard and a syntax using a set of Transact-SQL extensions.

Transact-sql - tricky query to get a list of people from a table where i belong too.

I've no idea how to manage and optimize this query: I've four table. - User (userId, name) - Member (memberId, name, ownerId) The ownerId = user.userId - PresentPeople (activityId, presentId, ...) so presentId = memberId - Activity (activityId, ownerId, startDate...) and ownerId = user.userId So here for an user, I need members created by this user, and for this members I need the list of presentPeople for the activity that theyjoined. But I don't know how to get this list because they are in the list. Not sure if i'm clear there, Big help would be very helpfull :)) thanks

exec sql and transact

Hello guys. i've a problem, in a stored procedure i have a sql (SELECT * FROM TABLA -is only an example, actually, my sql statment is more complex) if i execute the sql statment the time for delay results is 6 seconds. but if i execute the stored procecure (EXEC spexample that has the same statmen) the results is in 2 minutes. is very slowly exec te store procedure, but the statmen is fast. excuse me for my english!!!

Using equal operator in transact-SQL for ntext datatype column

Hi, I've a problem with using equal operator in transact-SQL for ntext datatype column. (SQL Server 2000) I'm using the following SQL command text. use NorthwindSelect * from Categorieswhere Description ='Seaweed and fish' If I use 'like' operator intead of '=' then the qurey retuns correct value. Any idea about this? Any help is appreciated. Regards, Julia

extract date from text string - Transact-SQL

Hello, I have a field in my database with an archived date... (Giampaoli  Live Oak, Almonds Archive 09/16/10) I need to be able to extract the date from this, then perform a datepart function on it... How do I extract the date into it's own value using just SQL? Thanks, Wes

Is there a way to start SQL Agent from Transact-SQL or SSMS?


Using SQL Server 2008 is there a way to start the SQL Agent service using T-SQL? I don't have remote desktop permissions to that server or I would try to start it from there. While connected to the server in SSMS, in object explorer, if I right-click on the The SQL Server Agent label I see the start and stop options but they are greyed-out. Why?

precise version: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1)

work with xml in Transact SQL


I have a xml-text file. I need to write a stored procedure xml text in input parameters. Procedure what that will parse xml and returns three tables from the input xml-text. The input xml:

 <Order OrderID="1" OrderNumber="Order #1">
   <OrderLine OrderLineID=

Using Transact SQL Queries in Data Source Views


Afternoon all,

Can someone explain how I would use a view defined in SQL in my data source view creation and what the advantages of doing so would be. I've been assigned to a project where I need to build a DSV, but the database has a view that appears to create what I need too.

I've read in some MS literature that a view can be used in lieu of referencing the actual tables.

Can anyone explain how this would work?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend