Topics
Started by
Posts
Last post
I have more than 100 views in a database and i would like to change the from clause for all of them…
5 replies
I'm trying to reduce the overhead in some table triggers. I was hoping to replace audit-trail func…
2 replies
Hi, I have created a function using FOR XML to collate all hotel room details, but I have an issue …
2 replies
I am working on a procedure that will check directories using `xp_DirTree` to confirm that the corr…
2 replies
Am having two databases in a instance, both the databases are in sync. but the backup size is too …
1 replies
Hi All, Need your advise to improve my SQL, please. The following statement works well indeed, but …
2 replies
Hi Friends, I found The word alter table "ON DELETE CASCADE" what is use on it? explain me and …
1 replies
Below is the sample sql and what is the best way to create a primary key on it? Is it ok if a colum…
15 replies
Hello Everyone I hope that all is well. I am working with some dates that are in the datetime data …
5 replies
Hello Everyone I am still working on the date and time data. Now I have found they are storing one …
2 replies
Hi Folks, While trying to optimize a purge process for a monster table of 200 GB, I was simply runn…
10 replies
I've one scenario: create table dbo.T_Master(StudentId int, StudentName varchar(50), StudentAge in…
11 replies
Hi all, I have table with following structure: Create table Table1 (ID int identity(1,1),Locale nv…
2 replies
Hi all, I have a script to generate XML data from a table: SELECT [Key] as [Str Value],Value as [St…
1 replies
Dear Friends, I m trying to learn on set operators in MSSQL,so i created two tables CREATE TABLE St…
4 replies
Viewing 15 topics - 2,611 through 2,625 (of 10,647 total)
You must be logged in to create new topics.