Topics
Started by
Posts
Last post
My understanding is that if I run SELECT * FROM <tablename> on a table with a clustered ind…
5 replies
Is this possible in sql server 2008? I want to use the column in the select, and group by. But want…
12 replies
DECLARE @t TABLE( col1 VARCHAR(1), col2 VARCHAR(1), col3 VARCHAR(1), col4 VARCHAR(1) ) INSERT INTO …
5 replies
Hi There I require some assistance or direction with a update Trigger I have 2 tables Client and C…
7 replies
Hi All I want to sort some table data using column index The following query works: declare @index…
24 replies
So I have two tables CREATE TABLE dbo.Orders ( order_id int NOT NULL IDENTITY(1,1) CONSTRAINT…
3 replies
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
Viewing 15 topics - 5,146 through 5,160 (of 10,647 total)
You must be logged in to create new topics.