SQL Server - SQL Command
Asked By Just Dee
10-Feb-12 07:21 AM
New to SQL and a friend asked What is the output of the following )
Select Max (len(first_name)fromMember_DIM)
Who wants to clue me in ... I just know tha basic commands at The moment CONTAINING SLELECT................FROM................WHERE ............
Dilip Sharma replied to Just Dee
this is not right syntax....
right syntax will be
Select Max (len(first_name)) from Member_DIM
this will work..
and
len function return length of string...
so it will return length of first_name which is max in
Dilip Sharma replied to Just Dee
this is not right syntax....
right syntax will be
Select Max (len(first_name)) from Member_DIM
this will work..
and
len function return length of string...
so it will return length of first_name which is max
Somesh Yadav replied to Just Dee
HI,
right syntax will be
Select Max (len(first_name)) from Member_DIM
and it will return length of string.
so it will return length of first_name which is max in
kalpana aparnathi replied to Just Dee
hi,
Select Max (len(first_name)) from Member_DIM
Explanation:
This select command gives maximum length of the first name column from Member_DIM table.
Just Dee replied to Dilip Sharma
Just Dee replied to Somesh Yadav
Just Dee replied to kalpana aparnathi
We used to have automatic scheduled task to backup the LCS Standard edition (running on SQL Desktop Edition). However, it looks like it hasn't been backing up the database for last few months and when i run the command directly, i get the following: - -- -- -- -- -- -- -- -- -- -- C: \ > "C: \ Program Files \ Microsoft LC 2005 Server \ Support \ dbbackup.exe" / backupfile:"C: \ LC \ LC Backup" Connecting to SQL Server. . . Performing backup. . . Error: Failed to backup database. SQL Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'mirror_count'. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
server SQL Server Do I have to set up a sql server database on a sql server? Or can I do this on any server SQL Server Setup Discussions SQL Server (1) CREATE DATABASE (1) Databases (1) Database (1) Create
strawberry perl and sql server SQL Server I need to connect to sql server from strawberry perl. Is anyone aware of any free driver for this. thanks. SQL Server Discussions SQL Server 2005 (1) SQL Server 2000 (1) SQL Express (1) SQL Server (1
MSDE on Windows 2003 R2 box, new DL385G6 - Install Fails during SQL Services SQL Server I have been finding that I am having trouble with the Crystal Reports Server XI installation failing when it is dealing with SQL. So, as a thought and in case there was something wrong with my SQL portion of the isntall. I thought ok, I will try installing the actual MSDE application direct from Microsoft. So, I downloaded the MSDE for SQL 2000 (which is msde2000a.exe), set my switches and off to the races. It quit seconds left to the installation and bombed with the same errors as the Crystal Reports Server install. The error is the same whether I try to install MSDE by itself or
Additonal thoughts, you should be able to connect to SQL Server via SQL Server SQL Server Additonal thoughts, you should be able to connect to SQL Server via SQL Server Management Studio. This will provide you with whether or not SQL Server