Topics
Started by
Posts
Last post
Hi all, I am wondering if there is a way to generate ddl on object of database via t-sql ? For exam…
3 replies
I'm trying to create a Stored Procedure... CREATE PROCEDURE [dbo].[R_WhseOrders] @Date1 …
4 replies
I need to be able to store user credentials in the database I'm looking after (SQL Server 2005 and …
1 replies
I am trying to write a VIEW that will show 3 columns: A text field on which I group by. A se…
4 replies
Hi Is there a way to get all the items present in one table and not in other table So if we…
7 replies
Hi All I need to consolidate date ranges where overlaps may occur: if object_i…
5 replies
I have a stored procedure that includes an openquery for a linked server: CREATE PROCEDURE sp_MPMS_…
8 replies
Is there some reason to prefix string fields with an N? I.E.: select * from sysobjects where OBJECT…
3 replies
Hey all, I have a question. I am trying to restore 5 datafiles, 3 index files and 1 log file …
5 replies
hi please help wid this query update [copy_orders] set sumorders=(select sum(quantity) from [order …
9 replies
Hi All, Do you know any script to compare data difference between 2 tables? Thanks for you help. Mi…
1 replies
I need to store Unix Date/Time in one of the columns of a table. What datatype should I use to stor…
7 replies
I have the following T_SQL query which produces an aggregate showing a breakdown of my data by gend…
1 replies
I am having some brain strain trying to figure out how to do this. I have a table of shippers, des…
6 replies
I have a column which has values as 1 2 2.1 3 4 2.1.1 2.1.1.1 2.1.2 2.1.3 2.2 2.1.4 2.3 2.99 2.99.1…
29 replies
Viewing 15 topics - 9,751 through 9,765 (of 17,082 total)
You must be logged in to create new topics.