Restore database as
Hi, when doing the database restore in the "options" pane, there is a section name "Restore the database as:". What does this actually say? thanks ...
sql-server
How to connect Ruby Cygwin environment to with a SQL Server 2008 database?
I run a Windows XP machine, and use Cygwin to run my ruby environment. I usually connect to a MySQL database, but for purposes of testing the application when using a SQL Server database I need to setup a connection to my SQL Server database. Does anyone know how to setup my environment to connect to SQL Server? ...
How to access a MS SQL Server using Python 3?
I'm using a linux machine to make a little python program that needs to input its result in a SQL Server 2000 DB. I'm new to python so I'm struggling quite a bit to find what's the best solution to connect to the DB using python 3, since most of the libs I looked only work in python 2. As an added bonus question, the finished version o...
Using Google Maps in PHP and SQL Server
Where can I find the tutorial or example to use Google Maps with PHP, SQL Server and JavaScript? Example: If I want to apply Google Maps into my website, which when the user key in the suburb name, then it will return the map of the suburb and show a mark for each of the locations of shops belonging to my company. ...
Red Gate's SQL Toolbelt or Quest's Toad for SQL Server?
We are evaluating trial versions of Red Gate’s SQL Toolbelt and Quest Software’s Toad for SQL Server. What are the main differences between these tools? The benefits of using these tools are quite obvious but we are wondering which one is more suitable for a developer and development work? Is Toad for SQL Server more focused on DBA work?...
best solution for Null DateTime value
I couldn't find best solution when DateTime value is NULL. I use this techinque When binding; _ACTIVATION_DATE = dt.Rows[0]["ACTIVATION_DATE"] == DBNull.Value ? new DateTime(1970, 12, 30) : (DateTime?)dt.Rows[0]["ACTIVATION_DATE"]; When Inserting; public void Insert() { string ad=""; string dd=""; if (ACTIVATION_DATE ==...
When using the Generate Scripts wizard in SQL Server 2005, where is the Script Behaviour option for DROP followed by CREATE?
Using the Generate Scripts wizard in SQL Server Management Studio 2005 (right click a database -> Tasks -> Generate Scripts...). There is an option for Script Behaviour. The description for the option is as follows: Script Behaviour Generate the script as DROP statements, CREATE statements, or DROP statements followed by CREATE...
SQL Server 2005 error retrieving record based on Datetime primary key column
Hi All, I have a table in SQL Server 2005 with composite primary key, i.e. a foreign key (INT) and DateTime column. When i run the SQL, Select column1 From TABLE where ForeignKey=1 and DateTime='08/26/2010 11:24:36' No record was return when there is such a record. One option to do is Select column1 From TABLE where ForeignKey=1...
Updated query inside EXEC not updating data ?
SET @DynamicSQL = 'UPDATE U SET U.ADDRESS1 = U.ADDRESS2, U.ADDRESS2 = NULL FROM USER U INNER JOIN EMPOYEE E ON E.USER_ID = U.USER_ID WHERE U.TYPE = ''' + @TYPE + '''' EXEC(@DynamicSQL) PRINT @DynamicSQL I am creating the dynamic sql inside the stored procedure as shown above, Now when it executes in SP it prints correct sql i wanted,...
SQL Server security, read-only default to new databases
How do I set a Windows login on SQL Server so that it has read-only access to any database on the server, and will default to having read-only access to any subsequently added database. I would prefer T-SQL code. I am using SQL 2000 ...
Need Help Writing SQL To Apply Promotions to Shopping Basket at Checkout
Hi All, Don't laugh but I'm a Lotus Notes (non-relational database!) developer trying to work with SQL and, although I have the basic concepts nailed, I'm stuck on something I'd consider to be "advanced". Imagine a user reaches an online checkout having added a set of products to their basket. I need to apply promotions to the basket....
The OLE DB provider "MSDASQL" for linked server "(null)" reported an error.
Hi all, I'm very very stuck here, help is greatly appreciated. What am I trying to do? There is an ASP-page (classic ASP) with a CSV upload that gives the following error: Microsoft OLE DB Provider for SQL Server error '80040e14' The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider did not give any...
Simulate SQL Server database going down
I've written an application that connects to a system over the network and logs events from that system to a SQL Server database. I need to test the behaviour of the application when the SQL Server goes down. Is there a way to Kill just the one Database on a SQL Server system without affecting the others? If not is there a way to simul...
Sort Order in SQL Server
Can I change the default sort order in a SQL server database so that nulls and zero length strings are displayed last. Its SQL Server 2000 I stress, I want to change the default order for all queries, if possible ...
how we delete a row from parent table when child table connected with paren table by forigen key.
hi all i am getting a problem while i attenpting to delete a row from parent table, actuall i have created 2 table custmer and account.i make cutomer id(primary key) in customer and customer id (forigen key ) in account.after created it i have filled data inside both table. at this point while i am trying to delete a row from first ta...
.NET: How to insert XML document into SQL Server
i want to insert arbitrary xml into SQL Server. The xml is contained in an XmlDocument object. The column i want to insert into is either nvarchar, ntext, or xml column (If it makes your life easier then you can pick which type it is. Really it's an xml column). Prototype void SaveXmlToDatabase(DbConnection connection, XmlDocume...
from ms sql about copy a table
Hi all is it possible to copy old table (with definition, constrains,identity) to new table. the new table not yet to be create. without prior creation of new table can we copy a table thanks saj ...
Handling NVARCHAR columns with MS SQL Server and Hibernate
I have an application which uses MS SQL Server 2005 as the DBMS and jTDS as the JDBC driver. All the columns storing text are of type VARCHAR. A sendStringParametersAsUnicode=false parameter has been specified for the driver in order to prevent it sending all strings as unicode (which would cause an index scan instead of index seek for i...
How big should I declare my SQL Server column if it's going to hold an Article body?
I'm going to save tutorials and snippets. How big should I declare the column? ...
SQL 1st of the month to the end of the month.
I have an @StartDate and @EndDate. I need the @StartDate to be the day the query is ran(which will always be the first of the month) and the @EndDate to be exaclty at the end of the month no matter if the month is 30 or 31 days, etc. ...