3,481 Topics
 | |
| | USE [DIAMDBF] GO /****** Object: StoredProcedure [dbo].[STOCKREPORT] Script Date: 01/21/2011 11:32:40 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[JEWELLSTOCKREPORT] @SELDBNM SYSNAME, @FILENO1 nvarchar(7), @FROMCODE nvarchar(20), @TOCODE nvarchar(20), @START nvarchar(12), @LAST nvarchar(12), @DATE1 nvarchar(12), @DATE2 nvarchar(12), @DATEFORMAT varchar(12), @GROUPCODE char(10), @FROMLOT nvarchar(10), @TOLOT nvarchar(10) AS Declare @execstring …  |
| | I want to convert a kind of a large MSSQL table to text -- ideally CSV. One crude way would be to use SQL Developer to do a SELECT * and do a copy-and-paste. But there must be a more precise and efficient way of doing this. Perhaps SQL Developer … |
| | I have 3 tables; Group, MemberOfGroup and Graduates. GroupID is a primary key for Group and MatricNo is a primary key for Graduates. Both GroupID and MatricNo are composite key for MemberOfGroup. I want to show the group lists according to member size. Below is my sql. [CODE]Select g.GroupName, count(m.MatricNo) … |
| | Hi, I have recently finished a windows desktop application for a client that connects to a sql server database. Throughout development while the server instance was on my local machine the application and server communicated fine with the connection string below [CODE] <add name="myString" connectionString="Data Source=myServerName;Initial Catalog="myDbName";Integrated Security=True" providerName="System.Data.SqlClient" /> … |
| | Here is a sample of my table: ID Name Codes 1 John D S12, S13, S89 1 John D S98, T12 2 Joe D X27, S28 3 Bob S F12, F13, X43 3 Bob S S44, X38, S90 4 Steve F D25 I want a query that will return the … |
| | Hi, I tried installing MS SQL server 2008 on win 7 Ultimate x86. It was slipstreamed installation with SQL SP1. I got 7 errors during installation. All of them are showing almost similar messages (but different event ids)except the 2nd error (which was about failure to open some registry). The … |
| | PLEASE I HAVE OVER TEN CLIENT COMPUTERS. AM DESIGNING AN VB.NET WITH MSSQL SERVER 2005 EXPRESS APPLICATION THAT THE CLIENT CAN CONNECT TO THE DATABASE ON A ON COMPUTER HOW DO I DO THAT.# ie vb.net + sql server network application |
| | Hi i was installing sql 2000 on win 7 but it gave a message something like "sql have compatibility issues with this version of windows". I want to use sql 2000 with vs2005. Is it possible to run sql server 2000 on win 7? If yes how can i run …  |
| | 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 … |
| | am designig softwear with vb.net 2008 and mssql server 2005 express that can print on id card. i have the query written correctly that can retrive employee info. including the picture on a report.my question is how to set the report to automatically pick the size of the small id … |
 | 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 registration form for teachers in which teach ID is one coloum name i want message box error if id number already exist in side the table means uniqe ID e.g if id no 1 is already exist then 1 should not be added when next time user … |
 | i find it difficult to add mssql dbs to asp.net website when i am using vs2008. here i intend working locally. please let someone help me.  |
| | 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 there im making a PHP website for this game and the passwords it use are like this [CODE]0x7BF1EA5EBADD9D7DD2D43E25ABEBCD100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 which translates into "999momo999"[/CODE] any idea what sort of cryptography that might be? the pass itself is stored in a MSSQL DB and the column type is BINARY(60) thanks for any … |
| | 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 … |
| | Hi Laptop caught a virus the other day so I have spent all day running virus scans but am now at a complete loss to why I still can't connect to the internet. I have tried pinging yahoo.com to test with no packets lost etc so there is an internet … |
| | 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 … |
| | how can I select one or more columns from a table by column-index and NOT by columnname? I got the columnIndices of table by using this query SELECT name, colid FROM sys.syscolumns WHERE (id = (SELECT id FROM sys.sysobjects WHERE (name = 'table_name'))) |
| | Hi there, I am creating reports in SQL server business intelligent studio and when I deploy it to the report server the report is shown in only on a half a page. How can I make the report height and the width for the report thanksssss |
| | Hi all, DANIWEB saved me a few months ago, and I'm hoping the community can save me again :) I've found myself in the position of needing to extract a very small portion of data from a vast SQL database. I've got the specific table in question, and have isolated … |
| | Need to insert byte array value in to a column using bcp bulk copy. Any way? |
| | Hi, I have to insert fields in a table. I am using VB.net & SQL Server database. The code is: Dim userid As Int32 = Me.classname.UserID Dim strSQLD As String = "Insert into table1 (userid) values (Me.classname.UserID)" userid is of type int While debugging, i can see that variable userid … |
| | Hi, I am working on a server which appears to have both MSSQL 2005 and 2008 installed. When I start the management studio, version 2008 opens. I am unable to debug triggers because I am told by the management studio that this feature is not available with MSSQL 2005. What … |
| | Hi I am trying to write a function in which I customize my select statement. But it is not working as i desire... It is as [CODE] declare @column_name nvarchar(10) set @column_name = 'original' select @column_name from data [/CODE] Here original is the name of one of the columns. I … |
The End.