Topics
Started by
Posts
Last post
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
i need the output to be sort by serial how can i sort this so after 1.3 , 1.5 shall come and then 1…
16 replies
Hello, I am trying to document the environment I am working at. I want to document our clustered se…
3 replies
Viewing 15 topics - 2,611 through 2,625 (of 10,635 total)
You must be logged in to create new topics.