Topics
Started by
Posts
Last post
1). How do I drop column(S) for a table but ignored whatsoever constraint created for the table? H…
4 replies
Why the sql server agent willbe stopped.Is there any problem with my database if it is stopped.If …
1 replies
I have a question: A database, with the following columns: keyholderid, event, datetime. Basically,…
2 replies
I have a stored procedure that transforms data from one table to another. It uses normal tables to …
3 replies
I am creating a stored proc that will be used to process a group of records, one at a time. The pr…
4 replies
Is there a performance difference if you rearrange the criteria of a WHERE in a SELECT statement (i…
2 replies
I am trying to return a distinct value (unit) and the 1st/top 1 occurance of an id. I cannot figure…
3 replies
I've read here and in various articles that placing an index on a foreign key will boost performanc…
5 replies
I have prepared a query which produces results as such: STORE_ID DBR_DATE TAXABLE_SALES NON_TAXABLE…
9 replies
how do i rename a column name using T-SQL?
2 replies
hello I have a procdure that runs the below code. previous to this it creates all the tables used i…
2 replies
Maybe I don't know enough about the inner workings of SQL Server, but if anyone could shed some lig…
3 replies
Have about 12 SQL 2000 servers. Try to find those, that have logins containing "Ivanov" First crea…
3 replies
We have a table, which after modification finally contains numeric expression in one column like 10…
1 replies
i have a table with 10000 records: id int -- content varchar how do i use t-sql to query like 1st…
1 replies
Viewing 15 topics - 15,391 through 15,405 (of 17,082 total)
You must be logged in to create new topics.