Topics
Started by
Posts
Last post
anyone know how to alter a column to varchar from text datatype? thanks!! exec('Alter table ' + @tb…
2 replies
We are doing a lot of updating and computation on this temp table inside a stored proc. Can this te…
3 replies
Hi everyone! 1. - I'm making a dynamic list of the last 24 indexes of the Brazilian corresponding t…
7 replies
Hello, I get these sentences: execute sp_executesql N'update ptype set @a=@b where ptype.nname = …
1 replies
The command sp_spaceused @updateusage = true returns following result. How do I have to calculate t…
1 replies
Hello... I have a simple UDF which is part of a query that runds fine. If I take this query, and m…
4 replies
I have a sql script( not a stored procedure) which should run daily at 10 pm.How can i schedule the…
1 replies
I am retrieving the max date field from a table as in Select Max(StartDate) but I also want to get …
2 replies
Hi, I need a report which is called Spending by Budget source,i get the data from a view and its st…
2 replies
I'm validating raw data in a migration process and need a datetime validation function. Can anyone…
5 replies
Hello, i wonder if can i add new columns in run time usign T-SQL, the name of the column is a varia…
1 replies
I have a Table with 27 Mil records in it, (2 Gig Data, 1.5 Gig Indexing), Totaling to 3.5 Gig size …
7 replies
Hello, Could someone please explain to me the difference between 'Autocommit Mode' and 'Implicit Tr…
1 replies
I need to pass SQL to a third party app as a complete string, without the ability to change variabl…
1 replies
Which is better from performance point of view: having a condition in FROM clause or WHERE clause. …
1 replies
Viewing 15 topics - 15,406 through 15,420 (of 17,082 total)
You must be logged in to create new topics.