Topics
Started by
Posts
Last post
Hi, Can anyone tell me why SQL Server Execution Plan gives the same plan for these two queries? SE…
1 replies
Can anyone tell why ltrim and rtrin function truncate value of float datatype values ?
16 replies
Hi, I have a products table and a storage products table. CREATE TABLE Products (Product INT NOT N…
6 replies
I have a table named Absence Details and i want a to group sequential dates . Here is the data EID…
8 replies
Table contains Orderdate Column which contains years starting from 2001 to 2010. i need to get curr…
11 replies
how to find duplicate indexes in a table ,example a nonclustered index names FX_LOCATION_ID is crea…
7 replies
The issue is that the query runs in test and doesnt run in prod. We have 2 fields in my example: f…
8 replies
Hi, Sorry if this is a dumb question... Our application is installed on several customers, some of …
1 replies
Hi all, I have a table which has some 10 million records. Now i want to take backup of this table b…
4 replies
I need to query some tables looking for All Sales that are active at the same time and have at leas…
14 replies
I have a date query as below: SET DATEFIRST 1 -- Sets Monday as First Day of Week ;with mycte as ( …
2 replies
Could you please help me find records described as per below scenario. Campus code,address,CampusID…
7 replies
how to find duplicate default constraints in a table ,example DF_abc1 is a default constraint FOR c…
3 replies
How do you create a database from a data and log file?
3 replies
Hi, Many Thanks for your help in advance, this one has my stumped. I would like to concatenate the …
10 replies
Viewing 15 topics - 5,146 through 5,160 (of 10,640 total)
You must be logged in to create new topics.