Topics
Started by
Posts
Last post
When a database is copied is that captured in a table some where? I know you can query to see when …
10 replies
Being somewhat new to SQLServer, I need a simple way in TSQL to separate 1 column of data with embe…
3 replies
Running SQL 2008 R2 and getting the following error: SQLState = 08001, NativeError = 2 Error = [Mic…
14 replies
I have a query to update a table: UPDATE USERACCOUNT SET USERPASSWORD = (SELECT USERPASSWORD …
3 replies
Hi guys i need your help with a SQL logic. select account, address, addresstypeID from table1 Th…
1 replies
Hi there, I have a query in SQL 2000 DB and I need to migrate it to SQL 2008 DB. It works fine in S…
4 replies
I have a query that I need to return results from 23 to < 6 (hours). If I use comment the datep…
14 replies
Hello, I wish to combine 2 rows of result set of UNION. Example Select A,B,C,D from tabl1 Union Sel…
1 replies
[font="Tahoma"] Hello Friends, I created an Instead Of Trigger for Insert. I added couple of Insert…
1 replies
Main data file Data File CodeIGPDescriptionGroupOrItem ABCProfileXYZBCC ABCProfileYZXCCC A…
3 replies
-- The error was caused by the following statement -- FieldE is an non-null field select FieldA, Fi…
2 replies
In the BOL for SET ROWCOUNT, it says SET ROWCOUNT overrides the SELECT statement TOP keyword if th…
13 replies
Declare @cCompanyNo nvarchar (5), @cStockRoomCode nvarchar(10), @cFromItemCode nvarchar(32), …
4 replies
I got the below from one of the views. Can someone explain what these mean 1. row_number() over (…
2 replies
Dear All, I explain more Details about my Project/database. i have develop on SMS System for one Ma…
1 replies
Viewing 15 topics - 8,371 through 8,385 (of 10,647 total)
You must be logged in to create new topics.