Viewing 15 topics - 268,936 through 268,950 (of 283,816 total)
Topics
Started by
Posts
Last post
This answer implies that you would be moving the primary key constraint to the LAST_ORDER_DT also. …
6 replies
"Drop the primary key clustered index and create a new one on LAST_ORDER_DT" implies to me that you…
11 replies
I am exporting to Excel based on query against an SQL Server table and a lookup against an Access t…
7 replies
hi how can i import with dts a .sql file which contains sql statements like this: delete from tab_c…
9 replies
Hi, Is there any article on the physical space needed to shrink a database. We have 30gb database a…
2 replies
Does anyone have a script which will select the top x rows from every user table in a database? Th…
6 replies
create proc extractdata as begin tran if exists (select * from dbo.sysobjects where id = object_id(…
6 replies
I have a database aaa and i'm taking a full backup daily at 12 Am(I'm overwriting to the existing m…
2 replies
Hi, Is there any article on the physical space needed to shrink a database. We have 30gb database a…
3 replies
Hi All, what's the skinny on using table hints, (nolock), (rowlock) etc.. on Read-only databases? …
1 replies
Kinda dumb question --- sorry What are sql internals while altering tables - adding, updating, or d…
5 replies
How can I pass a table variable as a parameter to a stored procedure ? eg. create proc procname ( @…
2 replies
How can we use comments in access query like -- in SQL My Blog: http://dineshasanka.spaces.live.co…
5 replies
Can any one help me to know the sequence in which the constrains are fired ex.Check constraints, Fo…
2 replies
hi guys, how would i write the following sql statments using pl/sql table? SELECT to_char (orderdat…
1 replies
Viewing 15 topics - 268,936 through 268,950 (of 283,816 total)