Topics
Started by
Posts
Last post
I created a Login: create login ravid with password = 'ravid', DEFAULT_DATABASE = plu Then tried to…
3 replies
My job requires me to parse files in various formats, and standardize them into our system's format…
28 replies
Hi all... If I debug/step through the following TSQL: BEGIN Transaction update company set name…
5 replies
When I execute the following T-SQL DDL statement: create login ravid with password = 'ravid' DEFAUL…
2 replies
Hi, i need to get good knowledge on partitions(vertical and horizontal partitioning). Will anyone c…
2 replies
Hi, I need your expertise on this issue. Basically the reason to do this is to calculate YTD values…
2 replies
I am trying to delete oldest records after the last n records where n could be 5 or 6 (this would b…
4 replies
Hiya, I have the following query, which returns data from our clocking in database; SELECTE.EMP_F…
9 replies
I would like to join two tables. If there is no match for one column, I would like to say join with…
9 replies
I have to write a stored procedure which serves as a universal stored procedure for all the tables …
15 replies
I know that its different and reading the execution plan obviously shows it's different, but I'm tr…
8 replies
TABLE: CREATE TABLE [dbo].[vwCourseClass]( [CourseTitle] [nchar](10) NULL, [ClassTitle] [nchar](1…
14 replies
Scenario: We currently have an Address table with roughly 500,000 rows in it. This data represent…
7 replies
HI All, I've about 50 Procdures in my Db,in which each Procedure has certian columns that are encry…
4 replies
I am geting some crazy results on my stored procedure I created, cannot seem to get the sytax corre…
3 replies
Viewing 15 topics - 8,146 through 8,160 (of 10,647 total)
You must be logged in to create new topics.