Using MS SQL Server
in [Microsoft SQL Server]
|
Having problems using BCP for CSV output I have been using SQL Server 2005 for a total of 2 days and am trying to transfer table data from one server to another. For whatever reason the original operator only gave us the DB in a BAK file. The new server for security purpose won't accept that for a restore unless it was made on their server. I inst... 27 Jul 2008 13:31
ALTER proc vs IF EXISTS DROP/CREATE For files saved in source control, is it better to use code to DROP/ CREATE a procedure like this: ------------------------------------------------------------------ IF OBJECT_ID ('procName') IS NOT NULL DROP PROC procName GO CREATE PROCEDURE procName AS BEGIN --proc code END GO GRANT EXECUTE ON procN... 25 Jul 2008 19:41
Delete Trigger I have set up a trigger that updates a table in another part of may database whenever a row is deleted - of the form CREATE TRIGGER t_Delete ON tblOrderDetails AFTER DELETE AS SELECT @Quantity = Quantity FROM DELETED etc etc This works fine if I delete only one row from tblOrderDetails at a time, but if I run ... 25 Jul 2008 04:17
SQL Server Scripting Question I have an SQL Server 2005 database that is populated with a customer's data. I want to create a new database, in exactly the same format, so that I can set up a system for a potential new customer to start converting his data. Initially I want to create a 'blank' database, so I went into SQL Server Management S... 28 Jul 2008 12:03
Now registers the member to bestow 100 integrals! PayPal Now registers the member to bestow 100 integrals! PayPal Now registers the member to bestow 100 integrals! PayPal All completes the order form changes into the corresponding integral! The integral trades the gift,Sends together with yours package! The integral trades the web money,50 integrals = Web money $1 The integral decision different member, enjoys the different ... 23 Jul 2008 12:16
Cheap DG handbags PayPal Cheap DG handbags PayPal welcome to shopping on < http://groups.google.com/group/comp.lang.vhdl/browse_thread/thread/2381d0cc9ca632a8# Now you may momentarily remit money from the W.U to us, after we receive, will transform your web money. After you issue an order form, you need to arrive at the bank tran... 23 Jul 2008 12:16
sql server query problem Hi, I'm trying to use the result from the select within the same query. See code SELECT accountnum, char(ASCII(SUBSTRING(accountnum, 1, 1))) as firstChar from questions where firstchar='m' Is it possible to use the result from char(ASCII(SUBSTRING(accountnum, 1, 1))) within the same query without any neste... 21 Jul 2008 05:51
ANN: Advanced Data Generator 2.3.0 released! Dear ladies and gentlemen, Upscene Productions is happy to announce the next version of their test data generator tool: "Advanced Data Generator 2" (v2.3.0) A fast test-data generator tool that comes with a library of real-life data, can generate data to your database, SQL script or CSV files, many filling op... 21 Jul 2008 03:49
Insert Into Select trouble I've tried for hours... and my issue is this: Table 1 has FirstName, LastName, Address, Birthday, (and other columns) Table 2 has FirstName, LastName, Address, Birthday, (and other columns) Most of Table1.Birthday is null. Some are not. All of Table2.Birthday has valid Birthdays. I want to insert Table2.... 21 Jul 2008 09:57 |