SQL Related Problems & Solutions

92 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 92
[Solved] How can I repair a corrupted MDF file?
Summary: I have a corrupted MDF & LDF file. Due to some reason both of my (MDF & LDF) files are corrupted and damaged and doesn’t open properly. Anyone can s...

[Solved] How can I do restoration of the database without the log fil
Summary: Hi! I have large database of 1.5 TB. As it turned out the log file was on another drive. The base was deactivated in the normal mode and at the time o...

[Solved] How can i recover corrupted database file( .mdf .ldf).
Summary: I run MSDE on a Windows XP Server and my database was marked as "suspect" by Enterprise Manager and its icon become gray. I detach that database and ...

VB .net text box to display count based on text in column SQ
Summary: VB .net text box to display count based on text in column SQL eg. i have a sql database called users and a column called IsIn with text Yes (some will...

[Solved] how to call .sql files in .sh file similar to .bat
Summary: how to call .sql file from .sh file like .bat file, i have .bat file which contains list of .sql files with fully qualified path. Below is the .BAT fi...

Can a SQL Output be Made for List of Tables & Fields?
Summary: Is it possible, in SQL (and my knowledge of it is quite basic) to get a readout of all tables and the fields in each table? That way, I can copy it al...

[Solved] How Application User/Group Permissions
Summary: An application that I am creating will have user based permission delegating what the user can do within the application. I have a couple ideas on how...

[Solved] Running a report with with combo box and different tags
Summary: I'm trying to set up a report that managers can select dates and employees from. I have two dates (Date Received and Date Taken) and one combo box I ...

Unable to install Sql Management Studio
Summary: Dear All, I am trying to install SQL Management StudioX64_enu pn windows server 2003 R2. When i RUN the exe just a black screen popup and gone. Is it...

[Solved] is there a developer tool i can use
Summary: i want to make a Gui app and i tried netbeans but i can't use my own app when I'm done i run and build it and does not work is there any other apps li...

[Solved] how do i make my own os using mac
Summary: I'm not talking about the boot up ones. I'm talking about how do i program and make my own operating system ...

what is the difference between MySQL and SQL
Summary: please anybody explain in details the difference between MySQL and SQL,MySQL server and SQL server? Is it true that MySQL is developed by oracle compa...

How to get data from a SQL Sever database
Summary: I need to generate QR Code barcode images using data that is drawn from a SQL Sever database. But I do not the way to draw data. Any help will be appr...

[Solved] list files in excel sheet or list files
Summary: I have sql files in folder say c:\DB\f1.sql, f2.sql, f3.sql and want all file names like f1.sql f2.sql f3.sql as o/p in list.txt file using batch scr...

SQL Query (Do all businesses have computers?)
Summary: How do I make a SQL query like "Do all businesses have computers?" There is a business_ID in business table and computer_ID in computer table, but I ...

[Solved] SQL Query (List the computers which have warranties)
Summary: List the computers which have warranties expiring within a year. How do I put this in a SQL Query? select computer_id,datediff(day,warranty_expiration...

To create a batch file to run all the sql scripts
Summary: hi i have my table_schema sql scripts in d: i need to create a batch file so that when i deploy, it should automatically create the table schema in my...

Drop table by using store procedure on oracle sql developer
Summary: Hi, I need to drop table which datas belong to last year by using store procedure on oracle SQL developer as soon as possible. Please help me =( ...

[Solved] Forfiles execute a command for each file
Summary: This one is a challenge for me. So we have: - %CD% (where %CD% may or may not have spaces) - file.sql - I want to execute %CD%\sqlite.exe3 file.sql > ...

[Solved] Improve MS SQL performance
Summary: Hello, I'm using MS SQL 2008 SP3 as a back end in my performance testing of my web application. At some point performance degraded and analyses pointe...

[Solved] Sql select statement and calculations
Summary: I have a database with a table called employee with the following fields name.date of birth,sex,qualification,first appointment date,grade,date of lic...

while running shell script it's including query also in the
Summary: I need to extract the data from the Db and want to import that data in a csv file using shell script. am getting the data from the database and able t...

[Solved] ms sql server 2005
Summary: Hello I have a windows server 2003 and i have already setup ms sql 2005 express , i want to manage the sql server with a client or something for examp...

[Solved] Comparing several files using specific parts of their names
Summary: Hi, Is it possible to compare two or more files using not their whole names, but parts of their names? Like this: Let's say I am deploying a .sql file...

[Solved] Getting a user input, storing it, and reusing it.
Summary: Hey everyone, I am working on a batch script/program that automates some regular day-to-day operations, DDL Deployments to be more precise. The sql f...

Creating log file in c#.net Windows
Summary: Please assist in creating log file in c#.net which will validate data from SQL TABLE and if record exist it should print log report and should save l...

[Solved] List Filenames and Date
Summary: Hey, thanks for reading this :D What i needed help in, is getting into a csv fileformat (';' separating values, and '\n' separating rows), all the *.s...

[Solved] i want to add single quote to a character in my file
Summary: i want to add single quote to a character in my file in unix. i want SENT =Y to be SENT='Y' i am using below command sed -e 's?SENT =Y?SENT='Y'?' Upd...

Shell script to connect to Oracle
Summary: I'm developing a script using bash to comnnect to Oracle and execute some SQL queries. I found this answer given by Nails, http://www.computing.net/an...

[Solved] Can this be done in SQL?
Summary: I'm trying to manipulate some data so that i can determine how many companies in our database have different country classifications between our diffe...

1234


Ask Question