Viewing 15 topics - 277,651 through 277,665 (of 283,875 total)
Topics
Started by
Posts
Last post
What's an easy way to do "select bottom 5 * from..." to see the last 5 records in a table? Of cours…
2 replies
I have stored my data my using insert into table1(password) values (encrypt('mypassword')). Now how…
9 replies
Hi all Im trying to get an equivalent function to the oracle TO_CHAR, for example: SELECT TO_CHAR(…
5 replies
Does anyone know how add or sub time data types. I have to count how long an employee has been at w…
3 replies
If I test an incoming value to a stored procedure and execute a If block, will there be an compiled…
3 replies
I am writing some stored procedures and want to encrypt the code. I am using the "With Encryption"…
6 replies
We've found SQL Agent jobs as reasonably convenient for what one might think of as batch queues, a …
1 replies
I'm new to SQL and Stored procedures. I'm trying to write a stored procedure and I'm having difficu…
2 replies
hello once again, this time i have encrypted a view and when i open its design view the error comes…
2 replies
Is it possible to disable the semicolon (;) separator (i.e. disable the use of multiple SQL stateme…
6 replies
I'm migrating a data report from a legacy system to SQL Server/Crystal Rpts. The report is grouped…
3 replies
Is it necessary to master t-sql fro 70029 exam ? If yes which is best book for T-Sql self study ? C…
6 replies
I have a TSQL Problem. I can not seem to reuse a temp table name. We are trying the below code, a…
5 replies
I have two triggers on a table, one for ON INSERT and one for ON UPDATE. The two triggers are desig…
10 replies
Generally speaking, if you have a query with several views joined (also with several tables), do th…
4 replies
Viewing 15 topics - 277,651 through 277,665 (of 283,875 total)