2,935 Topics
 | |
| | I am using COLDFUSION . And using coldfusion i am inserting a table using URLEncode function. For instance, the word 'Registration Fee' will be inserted into a table like 'Registration%20Fee' after encoding using URLEncode function in coldfusion.But I need to write a mssql statement to decode the word and want …  |
| | hi there, i have a question in C# files. i have a client application which is created in visual studio C#. and from that i copy a file to a folder in the server computer folder. so when i am trying to display it ot the user i user System.Diagnostic.Prcess.Start(PathToTheFileInTheServer) … |
| | hello Hope u all be fine Plz help i want to create a single database host in a server that is access by both ASP.net website and access remotely by windows mobile Application. The user want to easily update,create,delete their record through mobile application and update,create,delete their record through Asp.net … |
| | Hii plz anyone share me the link where can i download Complete video of SSRS  |
| | How to create xml from MSSQL database.Could any one help me to find out this . It would be much helpful and appreciated if any provide me an example also. |
| | hi i designed my database in vs 2008 and then I want to use this file as odbc database. is there any way to configure it and is odbc support mdf files? |
| | Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ? |
| | I have a program for students in my school uses asp with mssql database with a small server in the school, and I want to make a website with php and mysql database, can I always update the queries by exporting the mssql to mysql? and how I can do … |
 | Hi, I need a little help importing an XML file into sqlserver 2008. I followed this example [url]http://www.sql-server-performance.com/articles/dba/Loading_XML_data_into_SQL_Server_2008_p1.aspx[/url] (make sure you goto the rest of the pages in the article!) , generated the schema etc., but I can't get the import to do what I need. I was able to … |
| | SQL 2008 database disappeared after canceling copy Hi All, We have an SQL 2008 database of around 12GB. I was trying to create a copy of the database through the Microsoft SQL Management Server Studio. The server is in production mode, and it was taking too long to copy, and …  |
| | I want to get the list of items from a database as a Java resultset. When I use the following SQL statement it works perfectly fine [CODE]SELECT First_Name FROM dbo.Names where First_Name LIKE 'A%';[/CODE] However when I pass it as a parameter, it does not work I have tried a … |
| | [CODE]select PREMISEADDRESS1 from PREMISE PREM inner join STATUS ST on PREM.LOCATIONID = ST.LOCATIONID inner join SUPPLIES SUP on ST.STOPID = SUP.STOPID where SUP.ITEMID [COLOR="Red"]=[/COLOR] (select count(ITEMID)[COLOR="Red"] > [/COLOR]10) from SUPPLIES) [/CODE] Hello, I do not use SQL all that often but I would like to view all of the premisesaddresses …  |
| | I need to write a query that will get the value of a previous records and add it to the current record. In detail: I have a table (Table1) that contains PolicyNum, RecordID, and SequenceID PolicyNum RecordID SequenceID 123456 456 0 123456 456 0 123456 789 1 123456 789 1 … |
| | Hello, I have installed DB2 Everyplace, it installed successfully but not able to configure. Getting Error while try to configure it. The error is like this : [CODE] [exec] UPDATE DATABASE CONFIGURATION FOR DSYMSGDB USING MAXLOCKS 50 [exec] SQL1032N No start database manager command was issued. SQLSTATE=57019 [exec] SQL1032N No … |
| | Hi guys, I've started learning SQL after spending several years in the industry. I've got a table defined ... [code] CREATE TABLE [dbo].[Computer]( [Id] [int] NOT NULL, [Name] [nchar](10) NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS …  |
| | I'm making a visitor management application and I made three tables namely tblStudent, tblEmployee and tblVolunteer in SQL. I made a table according to the categories of a visitor. Do I still need to make a tblVisitor that would be the "general" table for the three tables made? I'm really … |
| | [FONT=Courier New]I have been told that views in MS SQL aren’t very good to use. Let’s say that you have a view X with 2 columns Car and Color that looks like this Car Color ----- ------ Alfa Yellow Volvo Yellow Volvo Blue Ford Yellow Ford Blue If you then …  |
| | I am trying to write a trigger that updates a column called CUST_BALANCE in a table called CUSTOMER when new data is entered into another table called INVOICE. What I want to do is when new data is inserted into INVOICE it will take the value in column INV_AMOUNT and …  |
 | Hi everyOne... I am new to sql Server and installed Ms sql 2005. i want to use command prompt for queries But whenever i use the sqlcmd command my computer gets restarted... Why it is so???? can anyOne plz Help... |
| | I have SQL Server 2008 Developer installed in my machine. The thing is that I have this database backup with version 10.50.1600, SQL Server Developer 2008 SP2 has version 10.00.4000. Well, I know there is not an easy workaround or conversion, so I thought well, what If I installed the … |
| | hi.. i'm using ssrs 2008 enterprice edition.. i want to send a report as email.. to my gmail address.. i want to schedule a report so that it can deliver daily to my gmail address.. how to send the report to my gmail address.. i dont know anything about smtp … |
| | Hi All, I have this tables Sales ReportID SalesAmt Branch {LocationA, LocationB} ReportDate What am i missing from this table or i need to create another table to normalize it. |
| | I have simple db with 4 tables: class, book, student and studentbook. studentbook has st_id and book_id as foreign keys and an extra field for result. book has some book for classes. I just insert new students. I'm quite beginner in db and don't know how to fill studentbook. should … |
| | I am using BIDS 2008 to export to flat file(CSV) it will be automatically exported at 11.00 am in the morning. What i want to know, can we make it so the file that are being exported has a unique name each time it was being generated? so each day, … |
| | The issue I am having is the following: Table1.FieldA is unique where as the Table2.FieldA field is not. When I run the following: SELECT Table1.Numbers, Table2.Numbers FROM Table1, Table2 WHERE Table1.ID = Table2.ID I get mutiple records like so: ID Name Numbers 125 John Doe 555, 556, 557 125 John … |
| | hi there, I asked this question before also. i have two date times in a table in the MS SQL server database, when i write the query as below. the Sstart Date and the Due Date is displayed as 12/11/2010 12:00:00 AM it shows correct in the MS SQL business … |
| | I recently installed MS SQL Server 2008 Developer Edition (on my home PC with Win7 Ultimate 64-bit). I have been trying to get it set up for use, but am having some issue. I keep getting an error when trying to connect to the server. On the "Connect to Server" … |
| | Hi there, How can I use the “EncryptByPassphrase” for a table in ms sql server 2008 r2??? or if i can get a good tutorial appriciate a lot thanxxxx |
| | i had a database with two tables a.table1,b.table2. In a.table1 i had three columns i;e a.col1(primary key),a.col2,a.col3 In b.table2 i had three columns i;e b.col1(foreign key),b.col2,b.col3 I want to delete a row in a.table1,b.table2 whose column names are different...but iam getting error as a.col1 is a primary key... so hw … |
| | Hi, I have a question in MS SQ L enter prise edition. I have writtend an application in Visual studio 2008 standard edition and I am connecting to ms sql sever enterprise edition 2008 r2. When I depoy the application I created and install inanother computer some components relating to … |
The End.