Sql-server Questions

Ad
Ad
Ad

Inheritance in database?

Is there any way to use inheritance in database (specifically in sql server 2005)? suppose i have few field like

SQL: How to remove duplicate rows?

I have the following data that has certain rows which are implicitly duplicated, but don't appear as such. i want to identify them based on
Ad
Ad

SQL Bulk import from CSV

I need to import a large csv file into an sql server. i'm using this : bulk insert csvtest from 'c:\csvfile.txt'

sql authentication or Windows auth

For my asp.net website with forms authentication, i will use windows integrated security to access a sql database. i will give db permissions to
Ad

SQL byte converter function

Is there a function or how would you implement a function that would check the last two characters of a string and convert this string to

Find an exact match in SQL

I'm new to sql programming and i was creating a table doing several when cases and the fact is that i have files that end in '.sas' and i want to
Ad

How to log in T-SQL

I'm using ado.net to access sql server 2005 and would like to be able to log from inside the t-sql stored procedures that i'm calling. is that
Ad

MSSQL2000: get list of role members

I know a role name and want to find all users in this role. how do i acheive this in sql server 2000 (in the sql script, not in management studio
Ad
Ad

Fill NULL and get distinct record

I am ingesting data from two different source (source a and source b). although data may be coming from two different sources, there is a
Ad

Blog Categories

Ad