I have for example a table with 2 fields:
- ID: autonumber
- Message: varchar
Now I want to know the ID right after I insert a new record. It should be something like this:
Set cmn = O...
Is there a way to get sql to return the starting day for a week number? Ex: When datepart returns week 2 can I get it to return Jan 6,2002
I would like to create SQL programs in MS Notepad and then run them by opening them(and the Database itself) in an MS-DOS/C-prompt window.
I would also like to pipe the query results to a s...
hi! i am trying to use a variable in a TSQL string.
In the first select statement i find the name of the 7th column of table alerts.
I retrieve the name(which is called 'Sol') using a curs...
I have made a project using VB and it's DataEnvironment
when I setup my package in some computer, the .exe file returns an error:
"The given type name was unrecognized"
while running ...
Thank you for your input at
http://www.experts-exchange.com/jsp/qManageQuestion.jsp?qid=20268887
Thank you for your input at
http://www.experts-exchange.com/jsp/qManageQuestion.jsp?qid=20268887
When I import from Access creating a new sql table Access creates a column typed 'ntext' for fields that had been Memo in Access. My ASP pages refuse (no errors...just no data) to output ntext...
Hi experts,
I understand that 'sp_attach_single_file_db' can automatically create a new log file, if it can't find one. But, what I have observed is it always creating the log file in the s...
Is it possible to have conditional statements in the column formula (when designing a table)? What is the correct syntax?
hi
i am trying to use vb as my front end and sql server as the back end db. I want to use application roles.
I understand that after executing sp_setapprole the users permissions are ign...
When i am trying to run query i get the following error:
Server: Msg 4408, Level 16, State 1, Line 1
The query and the views or functions in it exceed the limit of 256 tables.
the query...
hello, what's is uniqueidentifier datatype in MSSQL? I've just created a field with this type and trying to fill it, but i've got error message: "the value you entered is not consistent with t...
I am attempting to set up a simple snapshot replication between two SQL 2000 servers. I have set a machine up to do a pull replication from another machine. The setup process seemed to work fi...
Hi, I want to write a query to list all tables in a particular database having 2 columns
Name | No. of Rows.
Thanks.
Found this in the SQL log. Does anyone know what it means? Why would it place an entry in the log when it uses a particular dll? Is is something that I should be worried about?
Thanks fo...
HI,
How can I copy a whole table and some certain records from one DB to another.
The two DB are identical, but run under a diffrent Ip address.
I execute the SQL commands in MFC applicatio...
Does the replace function not work in SQL 6.5?
Here is what I am trying?
/* Delete existing data */
DELETE FROM DEV_INTERFACES..AFS
INSERT INTO DEV_INTERFACES..AFS
(name,
...
I am creating a link server in sql 2005. The drop down does ont list IBM DB2 UDB for iseries OLE DB provider as it does in SQl 2000
Any inputs?
I have several Database in MS SQL server. I backup them by schedule. However one of them has trouble recently. I try use DBCC checkalloc ('Northwind',REPAIR_REBUILD) But I got error message wh...
Hi,
We have a new server, backed up db on SQL1 restored into SQL2.
We have apps which are now coming up with a SQL Web Assistant: Webtasks not found.
Transactions aren't being processed.
...
I am trying to setup a snapshot table which has an archive of data that we can look back on over time. I have created a table and an insert routine that does exactly what we want except I am u...
Hi
I have one SQL DB, currently I'm taking Daily Full Backup. I want to replicate data between the server and another server using Log Shipping, but at the same time I want to keep taking t...
Can anyone provide me with where I can obtain documentation (url please) on the maximum number of nodes a SQL Server cluster can have running SQL Server 2000 Enterprise and Windows 2003 Server...
I have been around a couple of blocks with SQL Server. But one direction I am not clear about is whether or not to use SELECT * in my views and stored procedures.
For maintenance purposes, ...
